=begin
--------------------------------------------------------------------------------------------------------------------
Copyright (c) 2023 Aspose.Cells Cloud
Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.
--------------------------------------------------------------------------------------------------------------------
=end
require "uri"
module AsposeCellsCloud
class CellsApi
attr_accessor :api_client
def initialize(client_id,client_secret, app_version = 'v3.0', app_host = 'api.aspose.cloud', api_client = ApiClient.default)
@api_client = api_client
@api_client.config.client_secret = client_secret
@api_client.config.client_id = client_id
@api_client.config.api_version = app_version
@api_client.config.host = app_host
end
# Retrieve the description of auto filters from a worksheet.
def get_worksheet_auto_filter( get_worksheet_auto_filter_request, opts = {})
data, _status_code, _headers = get_worksheet_auto_filter_request.create_http_request(@api_client,opts )
return data
end
# Apply a date filter in the worksheet.
def put_worksheet_date_filter( put_worksheet_date_filter_request, opts = {})
data, _status_code, _headers = put_worksheet_date_filter_request.create_http_request(@api_client,opts )
return data
end
# Add a filter for a column in the worksheet.
def put_worksheet_filter( put_worksheet_filter_request, opts = {})
data, _status_code, _headers = put_worksheet_filter_request.create_http_request(@api_client,opts )
return data
end
# Add an icon filter in the worksheet.
def put_worksheet_icon_filter( put_worksheet_icon_filter_request, opts = {})
data, _status_code, _headers = put_worksheet_icon_filter_request.create_http_request(@api_client,opts )
return data
end
# Filter a list with custom criteria in the worksheet.
def put_worksheet_custom_filter( put_worksheet_custom_filter_request, opts = {})
data, _status_code, _headers = put_worksheet_custom_filter_request.create_http_request(@api_client,opts )
return data
end
# Add a dynamic filter in the worksheet.
def put_worksheet_dynamic_filter( put_worksheet_dynamic_filter_request, opts = {})
data, _status_code, _headers = put_worksheet_dynamic_filter_request.create_http_request(@api_client,opts )
return data
end
# Filter the top 10 items in the list in the worksheet.
def put_worksheet_filter_top10( put_worksheet_filter_top10_request, opts = {})
data, _status_code, _headers = put_worksheet_filter_top10_request.create_http_request(@api_client,opts )
return data
end
# Add a color filter in the worksheet.
def put_worksheet_color_filter( put_worksheet_color_filter_request, opts = {})
data, _status_code, _headers = put_worksheet_color_filter_request.create_http_request(@api_client,opts )
return data
end
# Match all blank cells in the list.
def post_worksheet_match_blanks( post_worksheet_match_blanks_request, opts = {})
data, _status_code, _headers = post_worksheet_match_blanks_request.create_http_request(@api_client,opts )
return data
end
# Match all not blank cells in the list.
def post_worksheet_match_non_blanks( post_worksheet_match_non_blanks_request, opts = {})
data, _status_code, _headers = post_worksheet_match_non_blanks_request.create_http_request(@api_client,opts )
return data
end
# Refresh auto filters in the worksheet.
def post_worksheet_auto_filter_refresh( post_worksheet_auto_filter_refresh_request, opts = {})
data, _status_code, _headers = post_worksheet_auto_filter_refresh_request.create_http_request(@api_client,opts )
return data
end
# Remove a date filter in the worksheet.
def delete_worksheet_date_filter( delete_worksheet_date_filter_request, opts = {})
data, _status_code, _headers = delete_worksheet_date_filter_request.create_http_request(@api_client,opts )
return data
end
# Delete a filter for a column in the worksheet.
def delete_worksheet_filter( delete_worksheet_filter_request, opts = {})
data, _status_code, _headers = delete_worksheet_filter_request.create_http_request(@api_client,opts )
return data
end
# Get autoshapes description in worksheet.
def get_worksheet_autoshapes( get_worksheet_autoshapes_request, opts = {})
data, _status_code, _headers = get_worksheet_autoshapes_request.create_http_request(@api_client,opts )
return data
end
# Get autoshape description in some format.
def get_worksheet_autoshape_with_format( get_worksheet_autoshape_with_format_request, opts = {})
data, _status_code, _headers = get_worksheet_autoshape_with_format_request.create_http_request(@api_client,opts )
return data
end
# Batch converting files that meet specific matching conditions.
def post_batch_convert( post_batch_convert_request, opts = {})
data, _status_code, _headers = post_batch_convert_request.create_http_request(@api_client,opts )
return data
end
# Batch protecting files that meet specific matching conditions.
def post_batch_protect( post_batch_protect_request, opts = {})
data, _status_code, _headers = post_batch_protect_request.create_http_request(@api_client,opts )
return data
end
# Batch locking files that meet specific matching conditions.
def post_batch_lock( post_batch_lock_request, opts = {})
data, _status_code, _headers = post_batch_lock_request.create_http_request(@api_client,opts )
return data
end
# Batch unlocking files that meet specific matching conditions.
def post_batch_unlock( post_batch_unlock_request, opts = {})
data, _status_code, _headers = post_batch_unlock_request.create_http_request(@api_client,opts )
return data
end
# Batch splitting files that meet specific matching conditions.
def post_batch_split( post_batch_split_request, opts = {})
data, _status_code, _headers = post_batch_split_request.create_http_request(@api_client,opts )
return data
end
# Clear cell area contents in the worksheet.
def post_clear_contents( post_clear_contents_request, opts = {})
data, _status_code, _headers = post_clear_contents_request.create_http_request(@api_client,opts )
return data
end
# Clear cell formats in the worksheet.
def post_clear_formats( post_clear_formats_request, opts = {})
data, _status_code, _headers = post_clear_formats_request.create_http_request(@api_client,opts )
return data
end
# Update cell range styles in the worksheet.
def post_update_worksheet_range_style( post_update_worksheet_range_style_request, opts = {})
data, _status_code, _headers = post_update_worksheet_range_style_request.create_http_request(@api_client,opts )
return data
end
# Merge cells in the worksheet.
def post_worksheet_merge( post_worksheet_merge_request, opts = {})
data, _status_code, _headers = post_worksheet_merge_request.create_http_request(@api_client,opts )
return data
end
# Unmerge cells in the worksheet.
def post_worksheet_unmerge( post_worksheet_unmerge_request, opts = {})
data, _status_code, _headers = post_worksheet_unmerge_request.create_http_request(@api_client,opts )
return data
end
# Retrieve cell descriptions in a specified format.
def get_worksheet_cells( get_worksheet_cells_request, opts = {})
data, _status_code, _headers = get_worksheet_cells_request.create_http_request(@api_client,opts )
return data
end
# Retrieve cell data using either cell reference or method name in the worksheet.
def get_worksheet_cell( get_worksheet_cell_request, opts = {})
data, _status_code, _headers = get_worksheet_cell_request.create_http_request(@api_client,opts )
return data
end
# Retrieve cell style descriptions in the worksheet.
def get_worksheet_cell_style( get_worksheet_cell_style_request, opts = {})
data, _status_code, _headers = get_worksheet_cell_style_request.create_http_request(@api_client,opts )
return data
end
# Set cell value using cell name in the worksheet.
def post_worksheet_cell_set_value( post_worksheet_cell_set_value_request, opts = {})
data, _status_code, _headers = post_worksheet_cell_set_value_request.create_http_request(@api_client,opts )
return data
end
# Set cell style using cell name in the worksheet.
def post_update_worksheet_cell_style( post_update_worksheet_cell_style_request, opts = {})
data, _status_code, _headers = post_update_worksheet_cell_style_request.create_http_request(@api_client,opts )
return data
end
# Set the value of the range in the worksheet.
def post_set_cell_range_value( post_set_cell_range_value_request, opts = {})
data, _status_code, _headers = post_set_cell_range_value_request.create_http_request(@api_client,opts )
return data
end
# Copy data from a source cell to a destination cell in the worksheet.
def post_copy_cell_into_cell( post_copy_cell_into_cell_request, opts = {})
data, _status_code, _headers = post_copy_cell_into_cell_request.create_http_request(@api_client,opts )
return data
end
# Retrieve the HTML string containing data and specific formats in this cell.
def get_cell_html_string( get_cell_html_string_request, opts = {})
data, _status_code, _headers = get_cell_html_string_request.create_http_request(@api_client,opts )
return data
end
# Set the HTML string containing data and specific formats in this cell.
def post_set_cell_html_string( post_set_cell_html_string_request, opts = {})
data, _status_code, _headers = post_set_cell_html_string_request.create_http_request(@api_client,opts )
return data
end
# Calculate cell formula in the worksheet.
def post_cell_calculate( post_cell_calculate_request, opts = {})
data, _status_code, _headers = post_cell_calculate_request.create_http_request(@api_client,opts )
return data
end
# Set cell characters in the worksheet.
def post_cell_characters( post_cell_characters_request, opts = {})
data, _status_code, _headers = post_cell_characters_request.create_http_request(@api_client,opts )
return data
end
# Get worksheet columns description.
def get_worksheet_columns( get_worksheet_columns_request, opts = {})
data, _status_code, _headers = get_worksheet_columns_request.create_http_request(@api_client,opts )
return data
end
# Sets worksheet column width.
def post_set_worksheet_column_width( post_set_worksheet_column_width_request, opts = {})
data, _status_code, _headers = post_set_worksheet_column_width_request.create_http_request(@api_client,opts )
return data
end
# Gets worksheet column data by column's index.
def get_worksheet_column( get_worksheet_column_request, opts = {})
data, _status_code, _headers = get_worksheet_column_request.create_http_request(@api_client,opts )
return data
end
# Insert worksheet columns.
def put_insert_worksheet_columns( put_insert_worksheet_columns_request, opts = {})
data, _status_code, _headers = put_insert_worksheet_columns_request.create_http_request(@api_client,opts )
return data
end
# Delete worksheet columns.
def delete_worksheet_columns( delete_worksheet_columns_request, opts = {})
data, _status_code, _headers = delete_worksheet_columns_request.create_http_request(@api_client,opts )
return data
end
# Hide worksheet columns.
def post_hide_worksheet_columns( post_hide_worksheet_columns_request, opts = {})
data, _status_code, _headers = post_hide_worksheet_columns_request.create_http_request(@api_client,opts )
return data
end
# Unhide worksheet columns.
def post_unhide_worksheet_columns( post_unhide_worksheet_columns_request, opts = {})
data, _status_code, _headers = post_unhide_worksheet_columns_request.create_http_request(@api_client,opts )
return data
end
# Group worksheet columns.
def post_group_worksheet_columns( post_group_worksheet_columns_request, opts = {})
data, _status_code, _headers = post_group_worksheet_columns_request.create_http_request(@api_client,opts )
return data
end
# Ungroup worksheet columns.
def post_ungroup_worksheet_columns( post_ungroup_worksheet_columns_request, opts = {})
data, _status_code, _headers = post_ungroup_worksheet_columns_request.create_http_request(@api_client,opts )
return data
end
# Copy data to destination columns from source columns in worksheet.
def post_copy_worksheet_columns( post_copy_worksheet_columns_request, opts = {})
data, _status_code, _headers = post_copy_worksheet_columns_request.create_http_request(@api_client,opts )
return data
end
# Sets column style in worksheet.
def post_column_style( post_column_style_request, opts = {})
data, _status_code, _headers = post_column_style_request.create_http_request(@api_client,opts )
return data
end
# Get rows description in worksheet.
def get_worksheet_rows( get_worksheet_rows_request, opts = {})
data, _status_code, _headers = get_worksheet_rows_request.create_http_request(@api_client,opts )
return data
end
# Gets row data by row's index in worksheet.
def get_worksheet_row( get_worksheet_row_request, opts = {})
data, _status_code, _headers = get_worksheet_row_request.create_http_request(@api_client,opts )
return data
end
# Deletes row in worksheet.
def delete_worksheet_row( delete_worksheet_row_request, opts = {})
data, _status_code, _headers = delete_worksheet_row_request.create_http_request(@api_client,opts )
return data
end
# Delete several rows in worksheet.
def delete_worksheet_rows( delete_worksheet_rows_request, opts = {})
data, _status_code, _headers = delete_worksheet_rows_request.create_http_request(@api_client,opts )
return data
end
# Insert several new rows in worksheet.
def put_insert_worksheet_rows( put_insert_worksheet_rows_request, opts = {})
data, _status_code, _headers = put_insert_worksheet_rows_request.create_http_request(@api_client,opts )
return data
end
# Inserts new row in worksheet.
def put_insert_worksheet_row( put_insert_worksheet_row_request, opts = {})
data, _status_code, _headers = put_insert_worksheet_row_request.create_http_request(@api_client,opts )
return data
end
# Updates row in worksheet.
def post_update_worksheet_row( post_update_worksheet_row_request, opts = {})
data, _status_code, _headers = post_update_worksheet_row_request.create_http_request(@api_client,opts )
return data
end
# Hide rows in worksheet.
def post_hide_worksheet_rows( post_hide_worksheet_rows_request, opts = {})
data, _status_code, _headers = post_hide_worksheet_rows_request.create_http_request(@api_client,opts )
return data
end
# Unhide rows in worksheet.
def post_unhide_worksheet_rows( post_unhide_worksheet_rows_request, opts = {})
data, _status_code, _headers = post_unhide_worksheet_rows_request.create_http_request(@api_client,opts )
return data
end
# Group rows in worksheet.
def post_group_worksheet_rows( post_group_worksheet_rows_request, opts = {})
data, _status_code, _headers = post_group_worksheet_rows_request.create_http_request(@api_client,opts )
return data
end
# Ungroup rows in worksheet.
def post_ungroup_worksheet_rows( post_ungroup_worksheet_rows_request, opts = {})
data, _status_code, _headers = post_ungroup_worksheet_rows_request.create_http_request(@api_client,opts )
return data
end
# Copies data and formats of some whole rows in worksheet.
def post_copy_worksheet_rows( post_copy_worksheet_rows_request, opts = {})
data, _status_code, _headers = post_copy_worksheet_rows_request.create_http_request(@api_client,opts )
return data
end
# Applies formats for a whole row in worksheet.
def post_row_style( post_row_style_request, opts = {})
data, _status_code, _headers = post_row_style_request.create_http_request(@api_client,opts )
return data
end
# Retrieve cell descriptions in a specified format.
def get_cells_cloud_services_health_check( get_cells_cloud_services_health_check_request, opts = {})
data, _status_code, _headers = get_cells_cloud_services_health_check_request.create_http_request(@api_client,opts )
return data
end
# Aspose.Cells Cloud service health status check.
def get_cells_cloud_service_status( get_cells_cloud_service_status_request, opts = {})
data, _status_code, _headers = get_cells_cloud_service_status_request.create_http_request(@api_client,opts )
return data
end
# Retrieve chart area description in the worksheet.
def get_chart_area( get_chart_area_request, opts = {})
data, _status_code, _headers = get_chart_area_request.create_http_request(@api_client,opts )
return data
end
# Retrieve chart area fill format description in the worksheet.
def get_chart_area_fill_format( get_chart_area_fill_format_request, opts = {})
data, _status_code, _headers = get_chart_area_fill_format_request.create_http_request(@api_client,opts )
return data
end
# Retrieve chart area border description.
def get_chart_area_border( get_chart_area_border_request, opts = {})
data, _status_code, _headers = get_chart_area_border_request.create_http_request(@api_client,opts )
return data
end
# Retrieve descriptions of charts in the worksheet.
def get_worksheet_charts( get_worksheet_charts_request, opts = {})
data, _status_code, _headers = get_worksheet_charts_request.create_http_request(@api_client,opts )
return data
end
# Retrieve the chart in a specified format.
def get_worksheet_chart( get_worksheet_chart_request, opts = {})
data, _status_code, _headers = get_worksheet_chart_request.create_http_request(@api_client,opts )
return data
end
# Add a new chart in the worksheet.
def put_worksheet_add_chart( put_worksheet_add_chart_request, opts = {})
data, _status_code, _headers = put_worksheet_add_chart_request.create_http_request(@api_client,opts )
return data
end
# Delete a chart by index in the worksheet.
def delete_worksheet_delete_chart( delete_worksheet_delete_chart_request, opts = {})
data, _status_code, _headers = delete_worksheet_delete_chart_request.create_http_request(@api_client,opts )
return data
end
# Update chart properties in the worksheet.
def post_worksheet_chart( post_worksheet_chart_request, opts = {})
data, _status_code, _headers = post_worksheet_chart_request.create_http_request(@api_client,opts )
return data
end
# Retrieve chart legend description in the worksheet.
def get_worksheet_chart_legend( get_worksheet_chart_legend_request, opts = {})
data, _status_code, _headers = get_worksheet_chart_legend_request.create_http_request(@api_client,opts )
return data
end
# Update chart legend in the worksheet.
def post_worksheet_chart_legend( post_worksheet_chart_legend_request, opts = {})
data, _status_code, _headers = post_worksheet_chart_legend_request.create_http_request(@api_client,opts )
return data
end
# Show chart legend in worksheet.
def put_worksheet_chart_legend( put_worksheet_chart_legend_request, opts = {})
data, _status_code, _headers = put_worksheet_chart_legend_request.create_http_request(@api_client,opts )
return data
end
# Hides chart legend in worksheet.
def delete_worksheet_chart_legend( delete_worksheet_chart_legend_request, opts = {})
data, _status_code, _headers = delete_worksheet_chart_legend_request.create_http_request(@api_client,opts )
return data
end
# Clear the charts in worksheets.
def delete_worksheet_clear_charts( delete_worksheet_clear_charts_request, opts = {})
data, _status_code, _headers = delete_worksheet_clear_charts_request.create_http_request(@api_client,opts )
return data
end
# Gets chart title description in worksheet.
def get_worksheet_chart_title( get_worksheet_chart_title_request, opts = {})
data, _status_code, _headers = get_worksheet_chart_title_request.create_http_request(@api_client,opts )
return data
end
# Update chart title in worksheet.
def post_worksheet_chart_title( post_worksheet_chart_title_request, opts = {})
data, _status_code, _headers = post_worksheet_chart_title_request.create_http_request(@api_client,opts )
return data
end
# Add chart title / Set chart title visible
def put_worksheet_chart_title( put_worksheet_chart_title_request, opts = {})
data, _status_code, _headers = put_worksheet_chart_title_request.create_http_request(@api_client,opts )
return data
end
# Hides chart title in worksheet.
def delete_worksheet_chart_title( delete_worksheet_chart_title_request, opts = {})
data, _status_code, _headers = delete_worksheet_chart_title_request.create_http_request(@api_client,opts )
return data
end
def get_chart_series_axis( get_chart_series_axis_request, opts = {})
data, _status_code, _headers = get_chart_series_axis_request.create_http_request(@api_client,opts )
return data
end
def get_chart_category_axis( get_chart_category_axis_request, opts = {})
data, _status_code, _headers = get_chart_category_axis_request.create_http_request(@api_client,opts )
return data
end
def get_chart_value_axis( get_chart_value_axis_request, opts = {})
data, _status_code, _headers = get_chart_value_axis_request.create_http_request(@api_client,opts )
return data
end
def get_chart_second_category_axis( get_chart_second_category_axis_request, opts = {})
data, _status_code, _headers = get_chart_second_category_axis_request.create_http_request(@api_client,opts )
return data
end
def get_chart_second_value_axis( get_chart_second_value_axis_request, opts = {})
data, _status_code, _headers = get_chart_second_value_axis_request.create_http_request(@api_client,opts )
return data
end
def post_chart_series_axis( post_chart_series_axis_request, opts = {})
data, _status_code, _headers = post_chart_series_axis_request.create_http_request(@api_client,opts )
return data
end
def post_chart_category_axis( post_chart_category_axis_request, opts = {})
data, _status_code, _headers = post_chart_category_axis_request.create_http_request(@api_client,opts )
return data
end
def post_chart_value_axis( post_chart_value_axis_request, opts = {})
data, _status_code, _headers = post_chart_value_axis_request.create_http_request(@api_client,opts )
return data
end
def post_chart_second_category_axis( post_chart_second_category_axis_request, opts = {})
data, _status_code, _headers = post_chart_second_category_axis_request.create_http_request(@api_client,opts )
return data
end
def post_chart_second_value_axis( post_chart_second_value_axis_request, opts = {})
data, _status_code, _headers = post_chart_second_value_axis_request.create_http_request(@api_client,opts )
return data
end
# Get conditional formattings description.
def get_worksheet_conditional_formattings( get_worksheet_conditional_formattings_request, opts = {})
data, _status_code, _headers = get_worksheet_conditional_formattings_request.create_http_request(@api_client,opts )
return data
end
# Gets conditional formatting description in worksheet.
def get_worksheet_conditional_formatting( get_worksheet_conditional_formatting_request, opts = {})
data, _status_code, _headers = get_worksheet_conditional_formatting_request.create_http_request(@api_client,opts )
return data
end
# Adds a condition formatting in worksheet.
def put_worksheet_conditional_formatting( put_worksheet_conditional_formatting_request, opts = {})
data, _status_code, _headers = put_worksheet_conditional_formatting_request.create_http_request(@api_client,opts )
return data
end
# Adds a format condition in worksheet.
def put_worksheet_format_condition( put_worksheet_format_condition_request, opts = {})
data, _status_code, _headers = put_worksheet_format_condition_request.create_http_request(@api_client,opts )
return data
end
# Adds a cell area for format condition.
def put_worksheet_format_condition_area( put_worksheet_format_condition_area_request, opts = {})
data, _status_code, _headers = put_worksheet_format_condition_area_request.create_http_request(@api_client,opts )
return data
end
# Adds a condition for format condition.
def put_worksheet_format_condition_condition( put_worksheet_format_condition_condition_request, opts = {})
data, _status_code, _headers = put_worksheet_format_condition_condition_request.create_http_request(@api_client,opts )
return data
end
# Clear all condition formattings.
def delete_worksheet_conditional_formattings( delete_worksheet_conditional_formattings_request, opts = {})
data, _status_code, _headers = delete_worksheet_conditional_formattings_request.create_http_request(@api_client,opts )
return data
end
# Remove a conditional formatting.
def delete_worksheet_conditional_formatting( delete_worksheet_conditional_formatting_request, opts = {})
data, _status_code, _headers = delete_worksheet_conditional_formatting_request.create_http_request(@api_client,opts )
return data
end
# Removes cell area from conditional formatting.
def delete_worksheet_conditional_formatting_area( delete_worksheet_conditional_formatting_area_request, opts = {})
data, _status_code, _headers = delete_worksheet_conditional_formatting_area_request.create_http_request(@api_client,opts )
return data
end
# Retrieve workbooks in various formats.
def get_workbook( get_workbook_request, opts = {})
data, _status_code, _headers = get_workbook_request.create_http_request(@api_client,opts )
return data
end
# Convert the workbook from the requested content into files in different formats.
def put_convert_workbook( put_convert_workbook_request, opts = {})
data, _status_code, _headers = put_convert_workbook_request.create_http_request(@api_client,opts )
return data
end
# Save an Excel file in various formats.
def post_workbook_save_as( post_workbook_save_as_request, opts = {})
data, _status_code, _headers = post_workbook_save_as_request.create_http_request(@api_client,opts )
return data
end
# Convert Excel file to PDF files.
def post_convert_workbook_to_pdf( post_convert_workbook_to_pdf_request, opts = {})
data, _status_code, _headers = post_convert_workbook_to_pdf_request.create_http_request(@api_client,opts )
return data
end
# Convert Excel file to PNG files.
def post_convert_workbook_to_png( post_convert_workbook_to_png_request, opts = {})
data, _status_code, _headers = post_convert_workbook_to_png_request.create_http_request(@api_client,opts )
return data
end
# Convert Excel file to Docx files.
def post_convert_workbook_to_docx( post_convert_workbook_to_docx_request, opts = {})
data, _status_code, _headers = post_convert_workbook_to_docx_request.create_http_request(@api_client,opts )
return data
end
# Convert Excel file to Pptx files.
def post_convert_workbook_to_pptx( post_convert_workbook_to_pptx_request, opts = {})
data, _status_code, _headers = post_convert_workbook_to_pptx_request.create_http_request(@api_client,opts )
return data
end
# Convert Excel file to HTML files.
def post_convert_workbook_to_html( post_convert_workbook_to_html_request, opts = {})
data, _status_code, _headers = post_convert_workbook_to_html_request.create_http_request(@api_client,opts )
return data
end
# Convert Excel file to Markdown files.
def post_convert_workbook_to_markdown( post_convert_workbook_to_markdown_request, opts = {})
data, _status_code, _headers = post_convert_workbook_to_markdown_request.create_http_request(@api_client,opts )
return data
end
# Convert Excel file to Json files.
def post_convert_workbook_to_json( post_convert_workbook_to_json_request, opts = {})
data, _status_code, _headers = post_convert_workbook_to_json_request.create_http_request(@api_client,opts )
return data
end
# Convert Excel file to SQL Script files.
def post_convert_workbook_to_sql( post_convert_workbook_to_sql_request, opts = {})
data, _status_code, _headers = post_convert_workbook_to_sql_request.create_http_request(@api_client,opts )
return data
end
# Convert Excel file to Csv files.
def post_convert_workbook_to_csv( post_convert_workbook_to_csv_request, opts = {})
data, _status_code, _headers = post_convert_workbook_to_csv_request.create_http_request(@api_client,opts )
return data
end
# Export Excel internal elements or the workbook itself to various format files.
def post_export( post_export_request, opts = {})
data, _status_code, _headers = post_export_request.create_http_request(@api_client,opts )
return data
end
# Export XML data from an Excel file.
# When there are XML Maps in an Excel file, export XML data. When there is no XML map in the Excel file, convert the Excel file to an XML file.
def post_workbook_export_xml( post_workbook_export_xml_request, opts = {})
data, _status_code, _headers = post_workbook_export_xml_request.create_http_request(@api_client,opts )
return data
end
# Import a JSON data file into the workbook. The JSON data file can either be a cloud file or data from an HTTP URI.
def post_workbook_import_json( post_workbook_import_json_request, opts = {})
data, _status_code, _headers = post_workbook_import_json_request.create_http_request(@api_client,opts )
return data
end
# Import an XML data file into an Excel file. The XML data file can either be a cloud file or data from an HTTP URI.
def post_workbook_import_xml( post_workbook_import_xml_request, opts = {})
data, _status_code, _headers = post_workbook_import_xml_request.create_http_request(@api_client,opts )
return data
end
# Import data into the Excel file.
def post_import_data( post_import_data_request, opts = {})
data, _status_code, _headers = post_import_data_request.create_http_request(@api_client,opts )
return data
end
# Get hyperlinks description in worksheet.
def get_worksheet_hyperlinks( get_worksheet_hyperlinks_request, opts = {})
data, _status_code, _headers = get_worksheet_hyperlinks_request.create_http_request(@api_client,opts )
return data
end
# Gets hyperlink description by index in worksheet.
def get_worksheet_hyperlink( get_worksheet_hyperlink_request, opts = {})
data, _status_code, _headers = get_worksheet_hyperlink_request.create_http_request(@api_client,opts )
return data
end
# Deletes hyperlink by index in worksheet.
def delete_worksheet_hyperlink( delete_worksheet_hyperlink_request, opts = {})
data, _status_code, _headers = delete_worksheet_hyperlink_request.create_http_request(@api_client,opts )
return data
end
# Updates hyperlink by index in worksheet.
def post_worksheet_hyperlink( post_worksheet_hyperlink_request, opts = {})
data, _status_code, _headers = post_worksheet_hyperlink_request.create_http_request(@api_client,opts )
return data
end
# Adds hyperlink in worksheet.
def put_worksheet_hyperlink( put_worksheet_hyperlink_request, opts = {})
data, _status_code, _headers = put_worksheet_hyperlink_request.create_http_request(@api_client,opts )
return data
end
# Delete all hyperlinks in worksheet.
def delete_worksheet_hyperlinks( delete_worksheet_hyperlinks_request, opts = {})
data, _status_code, _headers = delete_worksheet_hyperlinks_request.create_http_request(@api_client,opts )
return data
end
# Assemble data files with template files to generate files in various formats.
def post_assemble( post_assemble_request, opts = {})
data, _status_code, _headers = post_assemble_request.create_http_request(@api_client,opts )
return data
end
# Compress files and generate target files in various formats, supported file formats are include Xls, Xlsx, Xlsm, Xlsb, Ods and more.
def post_compress( post_compress_request, opts = {})
data, _status_code, _headers = post_compress_request.create_http_request(@api_client,opts )
return data
end
# Merge cells in the worksheet.
def post_merge( post_merge_request, opts = {})
data, _status_code, _headers = post_merge_request.create_http_request(@api_client,opts )
return data
end
# Split Excel spreadsheet files based on worksheets and create output files in various formats.
def post_split( post_split_request, opts = {})
data, _status_code, _headers = post_split_request.create_http_request(@api_client,opts )
return data
end
# Search for specified text within Excel files.
def post_search( post_search_request, opts = {})
data, _status_code, _headers = post_search_request.create_http_request(@api_client,opts )
return data
end
# Replace specified text with new text in Excel files.
def post_replace( post_replace_request, opts = {})
data, _status_code, _headers = post_replace_request.create_http_request(@api_client,opts )
return data
end
# Import data into an Excel file and generate output files in various formats.
def post_import( post_import_request, opts = {})
data, _status_code, _headers = post_import_request.create_http_request(@api_client,opts )
return data
end
# Add Text Watermark to Excel files and generate output files in various formats.
def post_watermark( post_watermark_request, opts = {})
data, _status_code, _headers = post_watermark_request.create_http_request(@api_client,opts )
return data
end
# Clear internal elements in Excel files and generate output files in various formats.
def post_clear_objects( post_clear_objects_request, opts = {})
data, _status_code, _headers = post_clear_objects_request.create_http_request(@api_client,opts )
return data
end
# Reverse rows or columns in Excel files and create output files in various formats.
def post_reverse( post_reverse_request, opts = {})
data, _status_code, _headers = post_reverse_request.create_http_request(@api_client,opts )
return data
end
# Repair abnormal files and generate files in various formats.
def post_repair( post_repair_request, opts = {})
data, _status_code, _headers = post_repair_request.create_http_request(@api_client,opts )
return data
end
# Rotate rows, columns, or other objects in Excel files and save them in various formats.
def post_rotate( post_rotate_request, opts = {})
data, _status_code, _headers = post_rotate_request.create_http_request(@api_client,opts )
return data
end
# Update document properties in Excel file, and save them is various formats.
def post_metadata( post_metadata_request, opts = {})
data, _status_code, _headers = post_metadata_request.create_http_request(@api_client,opts )
return data
end
# Get cells document properties.
def get_metadata( get_metadata_request, opts = {})
data, _status_code, _headers = get_metadata_request.create_http_request(@api_client,opts )
return data
end
# Delete cells document properties in Excel file, and save them is various formats.
def delete_metadata( delete_metadata_request, opts = {})
data, _status_code, _headers = delete_metadata_request.create_http_request(@api_client,opts )
return data
end
# Get listobjects description in worksheet.
def get_worksheet_list_objects( get_worksheet_list_objects_request, opts = {})
data, _status_code, _headers = get_worksheet_list_objects_request.create_http_request(@api_client,opts )
return data
end
# Gets list object description by index in worksheet.
def get_worksheet_list_object( get_worksheet_list_object_request, opts = {})
data, _status_code, _headers = get_worksheet_list_object_request.create_http_request(@api_client,opts )
return data
end
# Adds a list object in worksheet.
def put_worksheet_list_object( put_worksheet_list_object_request, opts = {})
data, _status_code, _headers = put_worksheet_list_object_request.create_http_request(@api_client,opts )
return data
end
# Delete worksheet list objects in worksheet.
def delete_worksheet_list_objects( delete_worksheet_list_objects_request, opts = {})
data, _status_code, _headers = delete_worksheet_list_objects_request.create_http_request(@api_client,opts )
return data
end
# Deletes list object by index in worksheet.
def delete_worksheet_list_object( delete_worksheet_list_object_request, opts = {})
data, _status_code, _headers = delete_worksheet_list_object_request.create_http_request(@api_client,opts )
return data
end
# Updates list object in worksheet.
def post_worksheet_list_object( post_worksheet_list_object_request, opts = {})
data, _status_code, _headers = post_worksheet_list_object_request.create_http_request(@api_client,opts )
return data
end
# Converts list object to range in worksheet.
def post_worksheet_list_object_convert_to_range( post_worksheet_list_object_convert_to_range_request, opts = {})
data, _status_code, _headers = post_worksheet_list_object_convert_to_range_request.create_http_request(@api_client,opts )
return data
end
# Creates pivot table with list object in worksheet.
def post_worksheet_list_object_summarize_with_pivot_table( post_worksheet_list_object_summarize_with_pivot_table_request, opts = {})
data, _status_code, _headers = post_worksheet_list_object_summarize_with_pivot_table_request.create_http_request(@api_client,opts )
return data
end
# Sorts list object in worksheet.
def post_worksheet_list_object_sort_table( post_worksheet_list_object_sort_table_request, opts = {})
data, _status_code, _headers = post_worksheet_list_object_sort_table_request.create_http_request(@api_client,opts )
return data
end
# Remove duplicates on list object.
def post_worksheet_list_object_remove_duplicates( post_worksheet_list_object_remove_duplicates_request, opts = {})
data, _status_code, _headers = post_worksheet_list_object_remove_duplicates_request.create_http_request(@api_client,opts )
return data
end
# Insert slicer for list object.
def post_worksheet_list_object_insert_slicer( post_worksheet_list_object_insert_slicer_request, opts = {})
data, _status_code, _headers = post_worksheet_list_object_insert_slicer_request.create_http_request(@api_client,opts )
return data
end
# Update list column properties.
def post_worksheet_list_column( post_worksheet_list_column_request, opts = {})
data, _status_code, _headers = post_worksheet_list_column_request.create_http_request(@api_client,opts )
return data
end
# Update table total of list columns.
def post_worksheet_list_columns_total( post_worksheet_list_columns_total_request, opts = {})
data, _status_code, _headers = post_worksheet_list_columns_total_request.create_http_request(@api_client,opts )
return data
end
# Get OLE objects description in worksheet.
def get_worksheet_ole_objects( get_worksheet_ole_objects_request, opts = {})
data, _status_code, _headers = get_worksheet_ole_objects_request.create_http_request(@api_client,opts )
return data
end
# Gets OLE object info or get the OLE object in some format.
def get_worksheet_ole_object( get_worksheet_ole_object_request, opts = {})
data, _status_code, _headers = get_worksheet_ole_object_request.create_http_request(@api_client,opts )
return data
end
# Delete all OLE objects in worksheet.
def delete_worksheet_ole_objects( delete_worksheet_ole_objects_request, opts = {})
data, _status_code, _headers = delete_worksheet_ole_objects_request.create_http_request(@api_client,opts )
return data
end
# Deletes an OLE object in worksheet.
def delete_worksheet_ole_object( delete_worksheet_ole_object_request, opts = {})
data, _status_code, _headers = delete_worksheet_ole_object_request.create_http_request(@api_client,opts )
return data
end
# Update an OLE object in worksheet.
def post_update_worksheet_ole_object( post_update_worksheet_ole_object_request, opts = {})
data, _status_code, _headers = post_update_worksheet_ole_object_request.create_http_request(@api_client,opts )
return data
end
# Add an OLE object in worksheet.
def put_worksheet_ole_object( put_worksheet_ole_object_request, opts = {})
data, _status_code, _headers = put_worksheet_ole_object_request.create_http_request(@api_client,opts )
return data
end
# Get vertical page breaks description in worksheet.
def get_vertical_page_breaks( get_vertical_page_breaks_request, opts = {})
data, _status_code, _headers = get_vertical_page_breaks_request.create_http_request(@api_client,opts )
return data
end
# Get horizontal page breaks descripton in worksheet.
def get_horizontal_page_breaks( get_horizontal_page_breaks_request, opts = {})
data, _status_code, _headers = get_horizontal_page_breaks_request.create_http_request(@api_client,opts )
return data
end
# Gets a vertical page break description in worksheet.
def get_vertical_page_break( get_vertical_page_break_request, opts = {})
data, _status_code, _headers = get_vertical_page_break_request.create_http_request(@api_client,opts )
return data
end
# Gets a horizontal page breaks descripton in worksheet.
def get_horizontal_page_break( get_horizontal_page_break_request, opts = {})
data, _status_code, _headers = get_horizontal_page_break_request.create_http_request(@api_client,opts )
return data
end
# Adds a vertical page break in worksheet.
def put_vertical_page_break( put_vertical_page_break_request, opts = {})
data, _status_code, _headers = put_vertical_page_break_request.create_http_request(@api_client,opts )
return data
end
# Adds a horizontal page breaks in worksheet.
def put_horizontal_page_break( put_horizontal_page_break_request, opts = {})
data, _status_code, _headers = put_horizontal_page_break_request.create_http_request(@api_client,opts )
return data
end
# Delete vertical page breaks in worksheet.
def delete_vertical_page_breaks( delete_vertical_page_breaks_request, opts = {})
data, _status_code, _headers = delete_vertical_page_breaks_request.create_http_request(@api_client,opts )
return data
end
# Delete horizontal page breaks in worksheet.
def delete_horizontal_page_breaks( delete_horizontal_page_breaks_request, opts = {})
data, _status_code, _headers = delete_horizontal_page_breaks_request.create_http_request(@api_client,opts )
return data
end
# Delete a vertical page breaks in worksheet.
def delete_vertical_page_break( delete_vertical_page_break_request, opts = {})
data, _status_code, _headers = delete_vertical_page_break_request.create_http_request(@api_client,opts )
return data
end
# Delete a horizontal page breaks in worksheet.
def delete_horizontal_page_break( delete_horizontal_page_break_request, opts = {})
data, _status_code, _headers = delete_horizontal_page_break_request.create_http_request(@api_client,opts )
return data
end
# Gets page setup description in worksheet.
def get_page_setup( get_page_setup_request, opts = {})
data, _status_code, _headers = get_page_setup_request.create_http_request(@api_client,opts )
return data
end
# Updates page setup in worksheet.
def post_page_setup( post_page_setup_request, opts = {})
data, _status_code, _headers = post_page_setup_request.create_http_request(@api_client,opts )
return data
end
# Clears header footer in worksheet.
def delete_header_footer( delete_header_footer_request, opts = {})
data, _status_code, _headers = delete_header_footer_request.create_http_request(@api_client,opts )
return data
end
# Gets page header description in worksheet.
def get_header( get_header_request, opts = {})
data, _status_code, _headers = get_header_request.create_http_request(@api_client,opts )
return data
end
# Updates page header in worksheet.
def post_header( post_header_request, opts = {})
data, _status_code, _headers = post_header_request.create_http_request(@api_client,opts )
return data
end
# Gets page footer description in worksheet.
def get_footer( get_footer_request, opts = {})
data, _status_code, _headers = get_footer_request.create_http_request(@api_client,opts )
return data
end
# Update page footer description in worksheet.
def post_footer( post_footer_request, opts = {})
data, _status_code, _headers = post_footer_request.create_http_request(@api_client,opts )
return data
end
# Get pictures description in worksheet.
def get_worksheet_pictures( get_worksheet_pictures_request, opts = {})
data, _status_code, _headers = get_worksheet_pictures_request.create_http_request(@api_client,opts )
return data
end
# Gets a picture by number in worksheet.
def get_worksheet_picture_with_format( get_worksheet_picture_with_format_request, opts = {})
data, _status_code, _headers = get_worksheet_picture_with_format_request.create_http_request(@api_client,opts )
return data
end
# Adds a new picture in worksheet.
def put_worksheet_add_picture( put_worksheet_add_picture_request, opts = {})
data, _status_code, _headers = put_worksheet_add_picture_request.create_http_request(@api_client,opts )
return data
end
# Updates a picture by index in worksheet.
def post_worksheet_picture( post_worksheet_picture_request, opts = {})
data, _status_code, _headers = post_worksheet_picture_request.create_http_request(@api_client,opts )
return data
end
# Deletes a picture object in worksheet
def delete_worksheet_picture( delete_worksheet_picture_request, opts = {})
data, _status_code, _headers = delete_worksheet_picture_request.create_http_request(@api_client,opts )
return data
end
# Delete all pictures in worksheet.
def delete_worksheet_pictures( delete_worksheet_pictures_request, opts = {})
data, _status_code, _headers = delete_worksheet_pictures_request.create_http_request(@api_client,opts )
return data
end
# Get worksheet pivottables description.
def get_worksheet_pivot_tables( get_worksheet_pivot_tables_request, opts = {})
data, _status_code, _headers = get_worksheet_pivot_tables_request.create_http_request(@api_client,opts )
return data
end
# Gets a pivottable info by index in worksheet.
def get_worksheet_pivot_table( get_worksheet_pivot_table_request, opts = {})
data, _status_code, _headers = get_worksheet_pivot_table_request.create_http_request(@api_client,opts )
return data
end
# Gets pivot field description in pivot table.
def get_pivot_table_field( get_pivot_table_field_request, opts = {})
data, _status_code, _headers = get_pivot_table_field_request.create_http_request(@api_client,opts )
return data
end
# Gets pivot table filters in worksheet.
def get_worksheet_pivot_table_filters( get_worksheet_pivot_table_filters_request, opts = {})
data, _status_code, _headers = get_worksheet_pivot_table_filters_request.create_http_request(@api_client,opts )
return data
end
# Gets pivot table filters in worksheet.
def get_worksheet_pivot_table_filter( get_worksheet_pivot_table_filter_request, opts = {})
data, _status_code, _headers = get_worksheet_pivot_table_filter_request.create_http_request(@api_client,opts )
return data
end
# Adds a pivot table in worksheet.
def put_worksheet_pivot_table( put_worksheet_pivot_table_request, opts = {})
data, _status_code, _headers = put_worksheet_pivot_table_request.create_http_request(@api_client,opts )
return data
end
# Adds a pivot field in pivot table
def put_pivot_table_field( put_pivot_table_field_request, opts = {})
data, _status_code, _headers = put_pivot_table_field_request.create_http_request(@api_client,opts )
return data
end
# Adds a pivot filter for piovt table index
def put_worksheet_pivot_table_filter( put_worksheet_pivot_table_filter_request, opts = {})
data, _status_code, _headers = put_worksheet_pivot_table_filter_request.create_http_request(@api_client,opts )
return data
end
# Hides pivot field item in pivot table.
def post_pivot_table_field_hide_item( post_pivot_table_field_hide_item_request, opts = {})
data, _status_code, _headers = post_pivot_table_field_hide_item_request.create_http_request(@api_client,opts )
return data
end
# Moves pivot field in pivot table.
def post_pivot_table_field_move_to( post_pivot_table_field_move_to_request, opts = {})
data, _status_code, _headers = post_pivot_table_field_move_to_request.create_http_request(@api_client,opts )
return data
end
# Updates cell style in pivot table.
def post_pivot_table_cell_style( post_pivot_table_cell_style_request, opts = {})
data, _status_code, _headers = post_pivot_table_cell_style_request.create_http_request(@api_client,opts )
return data
end
# Updates style in pivot table.
def post_pivot_table_style( post_pivot_table_style_request, opts = {})
data, _status_code, _headers = post_pivot_table_style_request.create_http_request(@api_client,opts )
return data
end
def post_pivot_table_update_pivot_fields( post_pivot_table_update_pivot_fields_request, opts = {})
data, _status_code, _headers = post_pivot_table_update_pivot_fields_request.create_http_request(@api_client,opts )
return data
end
def post_pivot_table_update_pivot_field( post_pivot_table_update_pivot_field_request, opts = {})
data, _status_code, _headers = post_pivot_table_update_pivot_field_request.create_http_request(@api_client,opts )
return data
end
# Calculates pivottable's data to cells.
def post_worksheet_pivot_table_calculate( post_worksheet_pivot_table_calculate_request, opts = {})
data, _status_code, _headers = post_worksheet_pivot_table_calculate_request.create_http_request(@api_client,opts )
return data
end
# Moves pivot table in worksheet.
def post_worksheet_pivot_table_move( post_worksheet_pivot_table_move_request, opts = {})
data, _status_code, _headers = post_worksheet_pivot_table_move_request.create_http_request(@api_client,opts )
return data
end
# Delete pivot tables in worksheet.
def delete_worksheet_pivot_tables( delete_worksheet_pivot_tables_request, opts = {})
data, _status_code, _headers = delete_worksheet_pivot_tables_request.create_http_request(@api_client,opts )
return data
end
# Deletes pivot table by index in worksheet.
def delete_worksheet_pivot_table( delete_worksheet_pivot_table_request, opts = {})
data, _status_code, _headers = delete_worksheet_pivot_table_request.create_http_request(@api_client,opts )
return data
end
# Deletes pivot field in pivot table.
def delete_pivot_table_field( delete_pivot_table_field_request, opts = {})
data, _status_code, _headers = delete_pivot_table_field_request.create_http_request(@api_client,opts )
return data
end
# Delete all pivot filters in piovt table.
def delete_worksheet_pivot_table_filters( delete_worksheet_pivot_table_filters_request, opts = {})
data, _status_code, _headers = delete_worksheet_pivot_table_filters_request.create_http_request(@api_client,opts )
return data
end
# Deletes a pivot filter in piovt table.
def delete_worksheet_pivot_table_filter( delete_worksheet_pivot_table_filter_request, opts = {})
data, _status_code, _headers = delete_worksheet_pivot_table_filter_request.create_http_request(@api_client,opts )
return data
end
# Get document properties description.
def get_document_properties( get_document_properties_request, opts = {})
data, _status_code, _headers = get_document_properties_request.create_http_request(@api_client,opts )
return data
end
# Sets/creates a sdocument property.
def put_document_property( put_document_property_request, opts = {})
data, _status_code, _headers = put_document_property_request.create_http_request(@api_client,opts )
return data
end
# Gets document property by name.
def get_document_property( get_document_property_request, opts = {})
data, _status_code, _headers = get_document_property_request.create_http_request(@api_client,opts )
return data
end
# Deletes a document property.
def delete_document_property( delete_document_property_request, opts = {})
data, _status_code, _headers = delete_document_property_request.create_http_request(@api_client,opts )
return data
end
# Delete all custom document properties and clean built-in ones.
def delete_document_properties( delete_document_properties_request, opts = {})
data, _status_code, _headers = delete_document_properties_request.create_http_request(@api_client,opts )
return data
end
# Excel file digital signature.
def post_digital_signature( post_digital_signature_request, opts = {})
data, _status_code, _headers = post_digital_signature_request.create_http_request(@api_client,opts )
return data
end
# Excel Encryption.
def post_encrypt_workbook( post_encrypt_workbook_request, opts = {})
data, _status_code, _headers = post_encrypt_workbook_request.create_http_request(@api_client,opts )
return data
end
# Excel files decryption.
def delete_decrypt_workbook( delete_decrypt_workbook_request, opts = {})
data, _status_code, _headers = delete_decrypt_workbook_request.create_http_request(@api_client,opts )
return data
end
# Excel protection.
def post_protect_workbook( post_protect_workbook_request, opts = {})
data, _status_code, _headers = post_protect_workbook_request.create_http_request(@api_client,opts )
return data
end
# Excel unprotection.
def delete_un_protect_workbook( delete_un_protect_workbook_request, opts = {})
data, _status_code, _headers = delete_un_protect_workbook_request.create_http_request(@api_client,opts )
return data
end
# Excel file write protection.
def put_document_protect_from_changes( put_document_protect_from_changes_request, opts = {})
data, _status_code, _headers = put_document_protect_from_changes_request.create_http_request(@api_client,opts )
return data
end
# Excel file cancel write protection.
def delete_document_un_protect_from_changes( delete_document_un_protect_from_changes_request, opts = {})
data, _status_code, _headers = delete_document_un_protect_from_changes_request.create_http_request(@api_client,opts )
return data
end
# Unlock Excel files.
def post_unlock( post_unlock_request, opts = {})
data, _status_code, _headers = post_unlock_request.create_http_request(@api_client,opts )
return data
end
# Lock Excel files.
def post_lock( post_lock_request, opts = {})
data, _status_code, _headers = post_lock_request.create_http_request(@api_client,opts )
return data
end
# Excel files encryption.
def post_protect( post_protect_request, opts = {})
data, _status_code, _headers = post_protect_request.create_http_request(@api_client,opts )
return data
end
# Copys content to destination range from source range in worksheet.
def post_worksheet_cells_ranges_copy( post_worksheet_cells_ranges_copy_request, opts = {})
data, _status_code, _headers = post_worksheet_cells_ranges_copy_request.create_http_request(@api_client,opts )
return data
end
# Combines a range of cells into a single cell.
def post_worksheet_cells_range_merge( post_worksheet_cells_range_merge_request, opts = {})
data, _status_code, _headers = post_worksheet_cells_range_merge_request.create_http_request(@api_client,opts )
return data
end
# Unmerges merged cells of this range.
def post_worksheet_cells_range_un_merge( post_worksheet_cells_range_un_merge_request, opts = {})
data, _status_code, _headers = post_worksheet_cells_range_un_merge_request.create_http_request(@api_client,opts )
return data
end
# Sets the style of the range.
def post_worksheet_cells_range_style( post_worksheet_cells_range_style_request, opts = {})
data, _status_code, _headers = post_worksheet_cells_range_style_request.create_http_request(@api_client,opts )
return data
end
# Get the value of cells in range.
def get_worksheet_cells_range_value( get_worksheet_cells_range_value_request, opts = {})
data, _status_code, _headers = get_worksheet_cells_range_value_request.create_http_request(@api_client,opts )
return data
end
# Puts a value into the range, if appropriate the value will be converted to other data type and cell's number format will be reset.
def post_worksheet_cells_range_value( post_worksheet_cells_range_value_request, opts = {})
data, _status_code, _headers = post_worksheet_cells_range_value_request.create_http_request(@api_client,opts )
return data
end
# Moves the current range to the dest range.
def post_worksheet_cells_range_move_to( post_worksheet_cells_range_move_to_request, opts = {})
data, _status_code, _headers = post_worksheet_cells_range_move_to_request.create_http_request(@api_client,opts )
return data
end
# Sets data sort around a range of cells.
def post_worksheet_cells_range_sort( post_worksheet_cells_range_sort_request, opts = {})
data, _status_code, _headers = post_worksheet_cells_range_sort_request.create_http_request(@api_client,opts )
return data
end
# Sets outline border around a range of cells.
def post_worksheet_cells_range_outline_border( post_worksheet_cells_range_outline_border_request, opts = {})
data, _status_code, _headers = post_worksheet_cells_range_outline_border_request.create_http_request(@api_client,opts )
return data
end
# Sets column width of range.
def post_worksheet_cells_range_column_width( post_worksheet_cells_range_column_width_request, opts = {})
data, _status_code, _headers = post_worksheet_cells_range_column_width_request.create_http_request(@api_client,opts )
return data
end
# Sets row height of range.
def post_worksheet_cells_range_row_height( post_worksheet_cells_range_row_height_request, opts = {})
data, _status_code, _headers = post_worksheet_cells_range_row_height_request.create_http_request(@api_client,opts )
return data
end
# Inserts a range of cells and shift cells according to the shift option.
def put_worksheet_cells_range( put_worksheet_cells_range_request, opts = {})
data, _status_code, _headers = put_worksheet_cells_range_request.create_http_request(@api_client,opts )
return data
end
# Deletes a range of cells and shift cells according to the shift option.
def delete_worksheet_cells_range( delete_worksheet_cells_range_request, opts = {})
data, _status_code, _headers = delete_worksheet_cells_range_request.create_http_request(@api_client,opts )
return data
end
# Get shapes description in worksheet.
def get_worksheet_shapes( get_worksheet_shapes_request, opts = {})
data, _status_code, _headers = get_worksheet_shapes_request.create_http_request(@api_client,opts )
return data
end
# Gets shape description in worksheet.
def get_worksheet_shape( get_worksheet_shape_request, opts = {})
data, _status_code, _headers = get_worksheet_shape_request.create_http_request(@api_client,opts )
return data
end
# Adds shape in worksheet.
def put_worksheet_shape( put_worksheet_shape_request, opts = {})
data, _status_code, _headers = put_worksheet_shape_request.create_http_request(@api_client,opts )
return data
end
# delete all shapes in worksheet.
def delete_worksheet_shapes( delete_worksheet_shapes_request, opts = {})
data, _status_code, _headers = delete_worksheet_shapes_request.create_http_request(@api_client,opts )
return data
end
# Deletes a shape in worksheet.
def delete_worksheet_shape( delete_worksheet_shape_request, opts = {})
data, _status_code, _headers = delete_worksheet_shape_request.create_http_request(@api_client,opts )
return data
end
# Updates a shape in worksheet.
def post_worksheet_shape( post_worksheet_shape_request, opts = {})
data, _status_code, _headers = post_worksheet_shape_request.create_http_request(@api_client,opts )
return data
end
def post_worksheet_group_shape( post_worksheet_group_shape_request, opts = {})
data, _status_code, _headers = post_worksheet_group_shape_request.create_http_request(@api_client,opts )
return data
end
def post_worksheet_ungroup_shape( post_worksheet_ungroup_shape_request, opts = {})
data, _status_code, _headers = post_worksheet_ungroup_shape_request.create_http_request(@api_client,opts )
return data
end
# Get worksheet sparkline groups description.
def get_worksheet_sparkline_groups( get_worksheet_sparkline_groups_request, opts = {})
data, _status_code, _headers = get_worksheet_sparkline_groups_request.create_http_request(@api_client,opts )
return data
end
# Get worksheet sparkline group description.
def get_worksheet_sparkline_group( get_worksheet_sparkline_group_request, opts = {})
data, _status_code, _headers = get_worksheet_sparkline_group_request.create_http_request(@api_client,opts )
return data
end
# Delete worksheet sparkline groups description.
def delete_worksheet_sparkline_groups( delete_worksheet_sparkline_groups_request, opts = {})
data, _status_code, _headers = delete_worksheet_sparkline_groups_request.create_http_request(@api_client,opts )
return data
end
# Delete worksheet sparkline group description.
def delete_worksheet_sparkline_group( delete_worksheet_sparkline_group_request, opts = {})
data, _status_code, _headers = delete_worksheet_sparkline_group_request.create_http_request(@api_client,opts )
return data
end
# Put worksheet sparkline group description.
def put_worksheet_sparkline_group( put_worksheet_sparkline_group_request, opts = {})
data, _status_code, _headers = put_worksheet_sparkline_group_request.create_http_request(@api_client,opts )
return data
end
# Post worksheet sparkline group description.
def post_worksheet_sparkline_group( post_worksheet_sparkline_group_request, opts = {})
data, _status_code, _headers = post_worksheet_sparkline_group_request.create_http_request(@api_client,opts )
return data
end
# Run tasks.
def post_run_task( post_run_task_request, opts = {})
data, _status_code, _headers = post_run_task_request.create_http_request(@api_client,opts )
return data
end
# Gets workbook default style description.
def get_workbook_default_style( get_workbook_default_style_request, opts = {})
data, _status_code, _headers = get_workbook_default_style_request.create_http_request(@api_client,opts )
return data
end
# Get workbook's text items.
def get_workbook_text_items( get_workbook_text_items_request, opts = {})
data, _status_code, _headers = get_workbook_text_items_request.create_http_request(@api_client,opts )
return data
end
# Get workbook's names.
def get_workbook_names( get_workbook_names_request, opts = {})
data, _status_code, _headers = get_workbook_names_request.create_http_request(@api_client,opts )
return data
end
# Defines a new name in workbook.
def put_workbook_name( put_workbook_name_request, opts = {})
data, _status_code, _headers = put_workbook_name_request.create_http_request(@api_client,opts )
return data
end
# Gets workbook's name description.
def get_workbook_name( get_workbook_name_request, opts = {})
data, _status_code, _headers = get_workbook_name_request.create_http_request(@api_client,opts )
return data
end
# Update workbook's name.
def post_workbook_name( post_workbook_name_request, opts = {})
data, _status_code, _headers = post_workbook_name_request.create_http_request(@api_client,opts )
return data
end
# Gets workbook's name value.
def get_workbook_name_value( get_workbook_name_value_request, opts = {})
data, _status_code, _headers = get_workbook_name_value_request.create_http_request(@api_client,opts )
return data
end
# Delete workbook's names.
def delete_workbook_names( delete_workbook_names_request, opts = {})
data, _status_code, _headers = delete_workbook_names_request.create_http_request(@api_client,opts )
return data
end
# Gets workbook's name description.
def delete_workbook_name( delete_workbook_name_request, opts = {})
data, _status_code, _headers = delete_workbook_name_request.create_http_request(@api_client,opts )
return data
end
# Merge workbooks.
def post_workbooks_merge( post_workbooks_merge_request, opts = {})
data, _status_code, _headers = post_workbooks_merge_request.create_http_request(@api_client,opts )
return data
end
# Search text in workbook.
def post_workbooks_text_search( post_workbooks_text_search_request, opts = {})
data, _status_code, _headers = post_workbooks_text_search_request.create_http_request(@api_client,opts )
return data
end
# Replaces text in workbook.
def post_workbook_text_replace( post_workbook_text_replace_request, opts = {})
data, _status_code, _headers = post_workbook_text_replace_request.create_http_request(@api_client,opts )
return data
end
# Smart marker processing result.
def post_workbook_get_smart_marker_result( post_workbook_get_smart_marker_result_request, opts = {})
data, _status_code, _headers = post_workbook_get_smart_marker_result_request.create_http_request(@api_client,opts )
return data
end
# Creates new workbook using deferent methods.
def put_workbook_create( put_workbook_create_request, opts = {})
data, _status_code, _headers = put_workbook_create_request.create_http_request(@api_client,opts )
return data
end
# Splits workbook.
def post_workbook_split( post_workbook_split_request, opts = {})
data, _status_code, _headers = post_workbook_split_request.create_http_request(@api_client,opts )
return data
end
# Calculate all formulas in workbook.
def post_workbook_calculate_formula( post_workbook_calculate_formula_request, opts = {})
data, _status_code, _headers = post_workbook_calculate_formula_request.create_http_request(@api_client,opts )
return data
end
# Autofit workbook rows.
def post_autofit_workbook_rows( post_autofit_workbook_rows_request, opts = {})
data, _status_code, _headers = post_autofit_workbook_rows_request.create_http_request(@api_client,opts )
return data
end
def post_autofit_workbook_columns( post_autofit_workbook_columns_request, opts = {})
data, _status_code, _headers = post_autofit_workbook_columns_request.create_http_request(@api_client,opts )
return data
end
# Gets workbook settings description.
def get_workbook_settings( get_workbook_settings_request, opts = {})
data, _status_code, _headers = get_workbook_settings_request.create_http_request(@api_client,opts )
return data
end
# Updates workbook setting.
def post_workbook_settings( post_workbook_settings_request, opts = {})
data, _status_code, _headers = post_workbook_settings_request.create_http_request(@api_client,opts )
return data
end
# Set workbook background.
def put_workbook_background( put_workbook_background_request, opts = {})
data, _status_code, _headers = put_workbook_background_request.create_http_request(@api_client,opts )
return data
end
# Delete workbook background.
def delete_workbook_background( delete_workbook_background_request, opts = {})
data, _status_code, _headers = delete_workbook_background_request.create_http_request(@api_client,opts )
return data
end
# Set workbook water marker.
def put_workbook_water_marker( put_workbook_water_marker_request, opts = {})
data, _status_code, _headers = put_workbook_water_marker_request.create_http_request(@api_client,opts )
return data
end
def get_page_count( get_page_count_request, opts = {})
data, _status_code, _headers = get_page_count_request.create_http_request(@api_client,opts )
return data
end
# Get worksheets description.
def get_worksheets( get_worksheets_request, opts = {})
data, _status_code, _headers = get_worksheets_request.create_http_request(@api_client,opts )
return data
end
# Gets worksheet in some format.
def get_worksheet_with_format( get_worksheet_with_format_request, opts = {})
data, _status_code, _headers = get_worksheet_with_format_request.create_http_request(@api_client,opts )
return data
end
# Changes worksheet visibility.
def put_change_visibility_worksheet( put_change_visibility_worksheet_request, opts = {})
data, _status_code, _headers = put_change_visibility_worksheet_request.create_http_request(@api_client,opts )
return data
end
# Active sheet
def put_active_worksheet( put_active_worksheet_request, opts = {})
data, _status_code, _headers = put_active_worksheet_request.create_http_request(@api_client,opts )
return data
end
# Inserts new worksheet in workbook.
def put_insert_new_worksheet( put_insert_new_worksheet_request, opts = {})
data, _status_code, _headers = put_insert_new_worksheet_request.create_http_request(@api_client,opts )
return data
end
# Adds new worksheet in workbook.
def put_add_new_worksheet( put_add_new_worksheet_request, opts = {})
data, _status_code, _headers = put_add_new_worksheet_request.create_http_request(@api_client,opts )
return data
end
# Deletes a worksheet in workbook.
def delete_worksheet( delete_worksheet_request, opts = {})
data, _status_code, _headers = delete_worksheet_request.create_http_request(@api_client,opts )
return data
end
def delete_worksheets( delete_worksheets_request, opts = {})
data, _status_code, _headers = delete_worksheets_request.create_http_request(@api_client,opts )
return data
end
# Move worksheet in workbook.
def post_move_worksheet( post_move_worksheet_request, opts = {})
data, _status_code, _headers = post_move_worksheet_request.create_http_request(@api_client,opts )
return data
end
# Protects worksheet.
def put_protect_worksheet( put_protect_worksheet_request, opts = {})
data, _status_code, _headers = put_protect_worksheet_request.create_http_request(@api_client,opts )
return data
end
# Unprotects worksheet.
def delete_unprotect_worksheet( delete_unprotect_worksheet_request, opts = {})
data, _status_code, _headers = delete_unprotect_worksheet_request.create_http_request(@api_client,opts )
return data
end
# Get text items in worksheet.
def get_worksheet_text_items( get_worksheet_text_items_request, opts = {})
data, _status_code, _headers = get_worksheet_text_items_request.create_http_request(@api_client,opts )
return data
end
# Get comments description in worksheet.
def get_worksheet_comments( get_worksheet_comments_request, opts = {})
data, _status_code, _headers = get_worksheet_comments_request.create_http_request(@api_client,opts )
return data
end
# Gets comment by cell name in worksheet.
def get_worksheet_comment( get_worksheet_comment_request, opts = {})
data, _status_code, _headers = get_worksheet_comment_request.create_http_request(@api_client,opts )
return data
end
# Adds cell comment in worksheet.
def put_worksheet_comment( put_worksheet_comment_request, opts = {})
data, _status_code, _headers = put_worksheet_comment_request.create_http_request(@api_client,opts )
return data
end
# Updates cell comment in worksheet.
def post_worksheet_comment( post_worksheet_comment_request, opts = {})
data, _status_code, _headers = post_worksheet_comment_request.create_http_request(@api_client,opts )
return data
end
# Deletes cell comment in worksheet.
def delete_worksheet_comment( delete_worksheet_comment_request, opts = {})
data, _status_code, _headers = delete_worksheet_comment_request.create_http_request(@api_client,opts )
return data
end
# Delete all comments in worksheet.
def delete_worksheet_comments( delete_worksheet_comments_request, opts = {})
data, _status_code, _headers = delete_worksheet_comments_request.create_http_request(@api_client,opts )
return data
end
# Get worksheet merged cells.
def get_worksheet_merged_cells( get_worksheet_merged_cells_request, opts = {})
data, _status_code, _headers = get_worksheet_merged_cells_request.create_http_request(@api_client,opts )
return data
end
# Gets merged cell description by its index in worksheet.
def get_worksheet_merged_cell( get_worksheet_merged_cell_request, opts = {})
data, _status_code, _headers = get_worksheet_merged_cell_request.create_http_request(@api_client,opts )
return data
end
# Calculates formula value in worksheet.
def get_worksheet_calculate_formula( get_worksheet_calculate_formula_request, opts = {})
data, _status_code, _headers = get_worksheet_calculate_formula_request.create_http_request(@api_client,opts )
return data
end
# Calculates formula value in worksheet.
def post_worksheet_calculate_formula( post_worksheet_calculate_formula_request, opts = {})
data, _status_code, _headers = post_worksheet_calculate_formula_request.create_http_request(@api_client,opts )
return data
end
# Searchs text in worksheet.
def post_worksheet_text_search( post_worksheet_text_search_request, opts = {})
data, _status_code, _headers = post_worksheet_text_search_request.create_http_request(@api_client,opts )
return data
end
# Replaces text in worksheet.
def post_worsheet_text_replace( post_worsheet_text_replace_request, opts = {})
data, _status_code, _headers = post_worsheet_text_replace_request.create_http_request(@api_client,opts )
return data
end
# Sorts range in worksheet.
def post_worksheet_range_sort( post_worksheet_range_sort_request, opts = {})
data, _status_code, _headers = post_worksheet_range_sort_request.create_http_request(@api_client,opts )
return data
end
# Autofits row in worksheet.
def post_autofit_worksheet_row( post_autofit_worksheet_row_request, opts = {})
data, _status_code, _headers = post_autofit_worksheet_row_request.create_http_request(@api_client,opts )
return data
end
# Autofit rows in worksheet.
def post_autofit_worksheet_rows( post_autofit_worksheet_rows_request, opts = {})
data, _status_code, _headers = post_autofit_worksheet_rows_request.create_http_request(@api_client,opts )
return data
end
def post_autofit_worksheet_columns( post_autofit_worksheet_columns_request, opts = {})
data, _status_code, _headers = post_autofit_worksheet_columns_request.create_http_request(@api_client,opts )
return data
end
# Sets background image in worksheet.
def put_worksheet_background( put_worksheet_background_request, opts = {})
data, _status_code, _headers = put_worksheet_background_request.create_http_request(@api_client,opts )
return data
end
# Delete background image in worksheet.
def delete_worksheet_background( delete_worksheet_background_request, opts = {})
data, _status_code, _headers = delete_worksheet_background_request.create_http_request(@api_client,opts )
return data
end
# Sets freeze panes in worksheet.
def put_worksheet_freeze_panes( put_worksheet_freeze_panes_request, opts = {})
data, _status_code, _headers = put_worksheet_freeze_panes_request.create_http_request(@api_client,opts )
return data
end
# Unfreezes panes in worksheet.
def delete_worksheet_freeze_panes( delete_worksheet_freeze_panes_request, opts = {})
data, _status_code, _headers = delete_worksheet_freeze_panes_request.create_http_request(@api_client,opts )
return data
end
# Copies contents and formats from another worksheet.
def post_copy_worksheet( post_copy_worksheet_request, opts = {})
data, _status_code, _headers = post_copy_worksheet_request.create_http_request(@api_client,opts )
return data
end
# Rename worksheet.
def post_rename_worksheet( post_rename_worksheet_request, opts = {})
data, _status_code, _headers = post_rename_worksheet_request.create_http_request(@api_client,opts )
return data
end
# Update worksheet properties.
def post_update_worksheet_property( post_update_worksheet_property_request, opts = {})
data, _status_code, _headers = post_update_worksheet_property_request.create_http_request(@api_client,opts )
return data
end
# Get worksheets ranges description.
def get_named_ranges( get_named_ranges_request, opts = {})
data, _status_code, _headers = get_named_ranges_request.create_http_request(@api_client,opts )
return data
end
# Get range values.
def get_named_range_value( get_named_range_value_request, opts = {})
data, _status_code, _headers = get_named_range_value_request.create_http_request(@api_client,opts )
return data
end
# Updates worksheet zoom.
def post_update_worksheet_zoom( post_update_worksheet_zoom_request, opts = {})
data, _status_code, _headers = post_update_worksheet_zoom_request.create_http_request(@api_client,opts )
return data
end
def get_worksheet_page_count( get_worksheet_page_count_request, opts = {})
data, _status_code, _headers = get_worksheet_page_count_request.create_http_request(@api_client,opts )
return data
end
# Get validations description in worksheet.
def get_worksheet_validations( get_worksheet_validations_request, opts = {})
data, _status_code, _headers = get_worksheet_validations_request.create_http_request(@api_client,opts )
return data
end
# Gets a validation by index in worksheet.
def get_worksheet_validation( get_worksheet_validation_request, opts = {})
data, _status_code, _headers = get_worksheet_validation_request.create_http_request(@api_client,opts )
return data
end
# Adds a validation at index in worksheet.
def put_worksheet_validation( put_worksheet_validation_request, opts = {})
data, _status_code, _headers = put_worksheet_validation_request.create_http_request(@api_client,opts )
return data
end
# Updates a validation by index in worksheet.
def post_worksheet_validation( post_worksheet_validation_request, opts = {})
data, _status_code, _headers = post_worksheet_validation_request.create_http_request(@api_client,opts )
return data
end
# Deletes a validation by index in worksheet.
def delete_worksheet_validation( delete_worksheet_validation_request, opts = {})
data, _status_code, _headers = delete_worksheet_validation_request.create_http_request(@api_client,opts )
return data
end
# Delete all validations in worksheet.
def delete_worksheet_validations( delete_worksheet_validations_request, opts = {})
data, _status_code, _headers = delete_worksheet_validations_request.create_http_request(@api_client,opts )
return data
end
def download_file( download_file_request, opts = {})
data, _status_code, _headers = download_file_request.create_http_request(@api_client,opts )
return data
end
def upload_file( upload_file_request, opts = {})
data, _status_code, _headers = upload_file_request.create_http_request(@api_client,opts )
return data
end
def copy_file( copy_file_request, opts = {})
data, _status_code, _headers = copy_file_request.create_http_request(@api_client,opts )
return data
end
def move_file( move_file_request, opts = {})
data, _status_code, _headers = move_file_request.create_http_request(@api_client,opts )
return data
end
def delete_file( delete_file_request, opts = {})
data, _status_code, _headers = delete_file_request.create_http_request(@api_client,opts )
return data
end
def get_files_list( get_files_list_request, opts = {})
data, _status_code, _headers = get_files_list_request.create_http_request(@api_client,opts )
return data
end
def create_folder( create_folder_request, opts = {})
data, _status_code, _headers = create_folder_request.create_http_request(@api_client,opts )
return data
end
def copy_folder( copy_folder_request, opts = {})
data, _status_code, _headers = copy_folder_request.create_http_request(@api_client,opts )
return data
end
def move_folder( move_folder_request, opts = {})
data, _status_code, _headers = move_folder_request.create_http_request(@api_client,opts )
return data
end
def delete_folder( delete_folder_request, opts = {})
data, _status_code, _headers = delete_folder_request.create_http_request(@api_client,opts )
return data
end
def storage_exists( storage_exists_request, opts = {})
data, _status_code, _headers = storage_exists_request.create_http_request(@api_client,opts )
return data
end
def object_exists( object_exists_request, opts = {})
data, _status_code, _headers = object_exists_request.create_http_request(@api_client,opts )
return data
end
def get_disc_usage( get_disc_usage_request, opts = {})
data, _status_code, _headers = get_disc_usage_request.create_http_request(@api_client,opts )
return data
end
def get_file_versions( get_file_versions_request, opts = {})
data, _status_code, _headers = get_file_versions_request.create_http_request(@api_client,opts )
return data
end
end
end