=begin -------------------------------------------------------------------------------------------------------------------- Copyright (c) 2024 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 # Perform business analysis of data in Excel files. def post_analyze_excel( post_analyze_excel_request, opts = {}) data, _status_code, _headers = post_analyze_excel_request.create_http_request(@api_client,opts ) return data 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 # Retrieve descriptions of worksheet columns. 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 # Set 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 # Retrieve worksheet column data by column 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 in the worksheet. 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 in the worksheet. 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 in the worksheet. 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 in the worksheet. 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 in the worksheet. 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 from source columns to destination columns in the 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 # Set column style in the 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 # Retrieve descriptions of rows in the 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 # Retrieve row data by the row's index in the 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 # Delete a row in the 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 the 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 the 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 # Insert a new row in the 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 # Update height of rows in the 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 the 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 the 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 the 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 # Copy data and formats from specific entire rows in the 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 # Apply formats to an entire row in the 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_chart( put_worksheet_chart_request, opts = {}) data, _status_code, _headers = put_worksheet_chart_request.create_http_request(@api_client,opts ) return data end # Delete a chart by index in the worksheet. def delete_worksheet_chart( delete_worksheet_chart_request, opts = {}) data, _status_code, _headers = delete_worksheet_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 the 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 the 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 the worksheets. def delete_worksheet_charts( delete_worksheet_charts_request, opts = {}) data, _status_code, _headers = delete_worksheet_charts_request.create_http_request(@api_client,opts ) return data end # Retrieve chart title description in the 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 the 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 # Set chart title in the worksheet. 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 # Hide chart title in the 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 # Retrieve descriptions of chart seriesaxis in the chart. 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 # Retrieve descriptions of chart series axis in the chart. 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 # Retrieve chart value axis in the chart. 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 # Retrieve chart second category axis in the chart 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 # Retrieve chart second value axis in the chart. 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 # Update chart series axis in the chart. 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 # Update chart category axis in the chart. 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 # Update chart value axis in the chart. 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 # Update chart sencond category axis in the chart. 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 # Update chart sencond value axis in the chart. 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 # Retrieve descriptions of conditional formattings in a worksheet. 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 # Retrieve conditional formatting descriptions in the 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 # Add conditional formatting in the 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 # Add a format condition in the 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 # Add a cell area for the format condition in the worksheet. 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 # Add a condition for the format condition in the worksheet. 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 conditional formattings in the worksheet. 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 # Remove 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 # Retrieve descriptions of hyperlinks in the 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 # Retrieve hyperlink description by index in the 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 # Delete hyperlink by index in the 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 # Update hyperlink by index in the 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 # Add hyperlink in the 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 the 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 # Retrieve descriptions of ListObjects in the 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 # Retrieve list object description by index in the 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 # Add a ListObject in the 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 ListObjects in the 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 # Delete list object by index in the 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 # Update list object by index in the 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 # Convert list object to range in the 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 # Create a pivot table with a list object in the 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 # Sort list object in the 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 in 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 in list object. 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 total of list columns in the table. 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 # Retrieve descriptions of OLE objects in the 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 # Retrieve the OLE object in a specified format in the worksheet. 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 the 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 # Delete an OLE object in the 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 the 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 # Retrieve descriptions of vertical page breaks in the 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 # Retrieve descriptions of horizontal page breaks in the 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 # Retrieve a vertical page break description in the 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 # Retrieve a horizontal page break descripton in the 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 # Add a vertical page break in the 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 # Add a horizontal page breaks in the 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 the 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 the 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 break in the 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 break in the 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 # Retrieve page setup description in the 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 # Update page setup in the 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 # Clear header and footer in the 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 # Retrieve page header description in the worksheet. def get_header( get_header_request, opts = {}) data, _status_code, _headers = get_header_request.create_http_request(@api_client,opts ) return data end # Update page header in the worksheet. def post_header( post_header_request, opts = {}) data, _status_code, _headers = post_header_request.create_http_request(@api_client,opts ) return data end # Retrieve page footer description in the 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 in the worksheet. def post_footer( post_footer_request, opts = {}) data, _status_code, _headers = post_footer_request.create_http_request(@api_client,opts ) return data end # Set the scale at which the page will fit wide when printed on the sheet. def post_fit_wide_to_pages( post_fit_wide_to_pages_request, opts = {}) data, _status_code, _headers = post_fit_wide_to_pages_request.create_http_request(@api_client,opts ) return data end # Set the scale at which the page will fit tall when printed on the sheet. def post_fit_tall_to_pages( post_fit_tall_to_pages_request, opts = {}) data, _status_code, _headers = post_fit_tall_to_pages_request.create_http_request(@api_client,opts ) return data end # Retrieve descriptions of pictures in the 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 # Retrieve a picture by number in the 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 # Add a new picture in the 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 # Update a picture by index in the 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 # Delete a picture object by index in the 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 the 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 # Retrieve descriptions of pivottables in the worksheet. 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 # Retrieve PivotTable information by index in the 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 # Retrieve descriptions of pivot fields in the PivotTable. 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 PivotTable 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 # Retrieve PivotTable filters in the 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 # Add a PivotTable in the 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 # Add a pivot field in the PivotTable. 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 # Add a pivot filter to the PivotTable. 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 # Hide a pivot field item in the PivotTable. 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 # Move a pivot field in the PivotTable. 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 # Update cell style in the PivotTable. 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 # Update style in the PivotTable. 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 # Update pivot fields in the PivotTable. 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 # Update pivot field in the PivotTable. 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 # Calculate 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 # Move PivotTable in the 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 PivotTables in the 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 # Delete PivotTable by index in the 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 # Delete a pivot field in the PivotTable. 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 the PivotTable. 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 # Delete a pivot filter in the PivotTable. 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 # Retrieve descriptions of Excel file properties. 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 # Set or add an Excel 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 # Get Excel 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 # Delete an Excel 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 reset 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 # Copy content from the source range to the destination range in the 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 # Merge 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 # Unmerge merged cells within 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 # Set the style for the specified 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 # Retrieve the values of cells within the specified 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 # Assign a value to the range; if necessary, the value will be converted to another data type, and the 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 # Move the current range to the destination 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 # Perform data sorting 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 # Apply an 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 # Set the column width of the specified 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 # Insert a range of cells and shift existing cells based on the specified 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 # Delete a range of cells and shift existing cells based on the specified 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 # Retrieve descriptions of shapes in the 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 # Retrieve description of shape in the 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 # Add a shape in the 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 the 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 # Delete a shape in the 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 # Update a shape in the 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 # Group shapes in the worksheet. 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 # Ungroup shapes in the worksheet. 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 # Retrieve descriptions of sparkline groups in the worksheet. 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 # Retrieve description of a sparkline group in the worksheet. 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 sparkline groups in the worksheet. 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 a sparkline group in the worksheet. 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 # Add a sparkline group in the worksheet. 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 # Update a sparkline group in the worksheet. 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 # Retrieve the description of the default style for the workbook. 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 # Retrieve text items in the workbook. 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 # Retrieve named ranges in the workbook. 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 # Define a new name in the 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 # Retrieve description of a named range in the workbook. 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 a named range in the workbook. 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 # Retrieve the value of a named range in the workbook. 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 all named ranges in the workbook. 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 # Delete a named range in the workbook. 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 a workbook into the existing workbook. 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 for text in the 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 # Replace text in the 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. 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 # Create a new workbook using different 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 # Split the workbook with a specific format. 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 the 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 rows in the workbook. 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 # Autofit columns in the workbook. 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 # Retrieve descriptions of workbook settings. 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 # Update setting in the workbook. 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 background in the workbook. 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 background in the workbook. 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 water marker in the workbook. 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 # Get page count in the workbook. 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 # Retrieve the description of worksheets from a workbook. def get_worksheets( get_worksheets_request, opts = {}) data, _status_code, _headers = get_worksheets_request.create_http_request(@api_client,opts ) return data end # Retrieve the worksheet in a specified format from the workbook. 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 # Change worksheet visibility in the workbook. 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 # Set active worksheet index in the workbook. 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 # Insert a new worksheet in the 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 # Add a new worksheet in the 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 # Delete a worksheet in the workbook. def delete_worksheet( delete_worksheet_request, opts = {}) data, _status_code, _headers = delete_worksheet_request.create_http_request(@api_client,opts ) return data end # Delete matched worksheets in the workbook. 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 the 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 # Protect 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 # Unprotect 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 # Retrieve text items in the 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 # Retrieve the description of comments in the 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 # Retrieve the description of comment in the 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 # Add cell comment in the 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 # Update cell comment in the 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 # Delete cell comment in the 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 the 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 # Retrieve description of a merged cell by its index in the 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 # Calculate formula in the 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 # Calculate formula in the 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 # Search for text in the 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 # Replace old text with new text in the worksheet. def post_worksheet_text_replace( post_worksheet_text_replace_request, opts = {}) data, _status_code, _headers = post_worksheet_text_replace_request.create_http_request(@api_client,opts ) return data end # Sort a range in the 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 # Autofit a row in the 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 the 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 # Autofit columns in the worksheet. 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 # Set background image in the 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 the 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 # Set freeze panes in the 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 # Unfreeze 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 # Copy 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 in the workbook. 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 in the workbook. 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 # Retrieve descriptions of ranges in the worksheets. 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 # Retrieve values in range. 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 # Update the scaling percentage in the worksheet. It should be between 10 and 400. 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 # Get page count in the worksheet. 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 # Retrieve descriptions of validations in the 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 # Retrieve a validation by its index in the 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 # Add a validation at index in the 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 # Update a validation by index in the 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 # Delete 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 the 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