Class: AsposeCellsCloud::CellsApi

Inherits:

Object

• Object
• AsposeCellsCloud::CellsApi

Defined in:

lib/aspose_cells_cloud/api/cells_api.rb

Instance Attribute Summary

• #api_client ⇒ Object

  Returns the value of attribute api_client.

Instance Method Summary

• #add_picture_in_cell(add_picture_in_cell_request, opts = {}) ⇒ Object

  add new picture in the cells.

• #add_worksheet_to_spreadsheet(add_worksheet_to_spreadsheet_request, opts = {}) ⇒ Object

  The Web API enables users to add a new worksheet to a workbook, specifying the worksheet’s type, position, and name.

• #aggregate_cells_by_color(aggregate_cells_by_color_request, opts = {}) ⇒ Object

  The Aggregate by Color API provides a convenient way to perform calculations on cells that share the same fill or font color.

• #check_cloud_service_health(check_cloud_service_health_request, opts = {}) ⇒ Object

  Check the Health Status of Aspose.Cells Cloud Service.

• #check_workbook_formula_errors(check_workbook_formula_errors_request, opts = {}) ⇒ Object
• #check_wrokbook_external_reference(check_wrokbook_external_reference_request, opts = {}) ⇒ Object

  Export Excel internal elements or the workbook itself to various format files.

• #codegen_spec(codegen_spec_request, opts = {}) ⇒ Object
• #compress_spreadsheet(compress_spreadsheet_request, opts = {}) ⇒ Object

  The Web API endpoint allows users to compress a spreadsheet to reduce its file size.

• #convert_chart_to_image(convert_chart_to_image_request, opts = {}) ⇒ Object

  Converts a chart of spreadsheet on a local drive to image.

• #convert_chart_to_pdf(convert_chart_to_pdf_request, opts = {}) ⇒ Object

  Converts a chart of spreadsheet on a local drive to pdf.

• #convert_range_to_csv(convert_range_to_csv_request, opts = {}) ⇒ Object

  Converts a range of spreadsheet on a local drive to the csv file.

• #convert_range_to_html(convert_range_to_html_request, opts = {}) ⇒ Object

  Converts a range of spreadsheet on a local drive to the html file.

• #convert_range_to_image(convert_range_to_image_request, opts = {}) ⇒ Object

  Converts a range of spreadsheet on a local drive to the image file.

• #convert_range_to_json(convert_range_to_json_request, opts = {}) ⇒ Object

  Converts a range of spreadsheet on a local drive to the json file.

• #convert_range_to_pdf(convert_range_to_pdf_request, opts = {}) ⇒ Object

  Converts a range of spreadsheet on a local drive to the pdf file.

• #convert_spreadsheet(convert_spreadsheet_request, opts = {}) ⇒ Object

  Converts a spreadsheet on a local drive to the specified format.

• #convert_table_to_csv(convert_table_to_csv_request, opts = {}) ⇒ Object

  Converts a table of spreadsheet on a local drive to the csv file.

• #convert_table_to_html(convert_table_to_html_request, opts = {}) ⇒ Object

  Converts a table of spreadsheet on a local drive to the html file.

• #convert_table_to_image(convert_table_to_image_request, opts = {}) ⇒ Object

  Converts a table of spreadsheet on a local drive to the image file.

• #convert_table_to_json(convert_table_to_json_request, opts = {}) ⇒ Object

  Converts a table of spreadsheet on a local drive to the json file.

• #convert_table_to_pdf(convert_table_to_pdf_request, opts = {}) ⇒ Object

  Converts a table of spreadsheet on a local drive to the pdf file.

• #convert_worksheet_to_image(convert_worksheet_to_image_request, opts = {}) ⇒ Object

  Converts a worksheet of spreadsheet on a local drive to the image format.

• #convert_worksheet_to_pdf(convert_worksheet_to_pdf_request, opts = {}) ⇒ Object

  Converts a worksheet of spreadsheet on a local drive to the pdf file.

• #copy_file(copy_file_request, opts = {}) ⇒ Object
• #copy_folder(copy_folder_request, opts = {}) ⇒ Object
• #create_folder(create_folder_request, opts = {}) ⇒ Object
• #create_spreadsheet(create_spreadsheet_request, opts = {}) ⇒ Object

  The Web API allows users to create a new spreadsheet with a specified name.

• #delete_decrypt_workbook(delete_decrypt_workbook_request, opts = {}) ⇒ Object

  Excel files decryption.

• #delete_document_properties(delete_document_properties_request, opts = {}) ⇒ Object

  Delete all custom document properties and reset built-in ones.

• #delete_document_property(delete_document_property_request, opts = {}) ⇒ Object

  Delete an Excel property.

• #delete_document_un_protect_from_changes(delete_document_un_protect_from_changes_request, opts = {}) ⇒ Object

  Excel file cancel write protection.

• #delete_file(delete_file_request, opts = {}) ⇒ Object
• #delete_folder(delete_folder_request, opts = {}) ⇒ Object
• #delete_header_footer(delete_header_footer_request, opts = {}) ⇒ Object

  Clear header and footer in the worksheet.

• #delete_horizontal_page_break(delete_horizontal_page_break_request, opts = {}) ⇒ Object

  Delete a horizontal page break in the worksheet.

• #delete_horizontal_page_breaks(delete_horizontal_page_breaks_request, opts = {}) ⇒ Object

  Delete horizontal page breaks in the worksheet.

• #delete_metadata(delete_metadata_request, opts = {}) ⇒ Object

  Delete cells document properties in Excel file, and save them is various formats.

• #delete_pivot_table_field(delete_pivot_table_field_request, opts = {}) ⇒ Object

  Delete a pivot field in the PivotTable.

• #delete_spreadsheet_blank_columns(delete_spreadsheet_blank_columns_request, opts = {}) ⇒ Object

  Delete all blank columns which do not contain any data.

• #delete_spreadsheet_blank_rows(delete_spreadsheet_blank_rows_request, opts = {}) ⇒ Object

  Delete all blank rows which do not contain any data or other object.

• #delete_spreadsheet_blank_worksheets(delete_spreadsheet_blank_worksheets_request, opts = {}) ⇒ Object

  Delete all blank worksheets which do not contain any data or other object.

• #delete_un_protect_workbook(delete_un_protect_workbook_request, opts = {}) ⇒ Object

  Excel unprotection.

• #delete_unprotect_worksheet(delete_unprotect_worksheet_request, opts = {}) ⇒ Object

  Unprotect worksheet.

• #delete_vertical_page_break(delete_vertical_page_break_request, opts = {}) ⇒ Object

  Delete a vertical page break in the worksheet.

• #delete_vertical_page_breaks(delete_vertical_page_breaks_request, opts = {}) ⇒ Object

  Delete vertical page breaks in the worksheet.

• #delete_workbook_background(delete_workbook_background_request, opts = {}) ⇒ Object

  Delete background in the workbook.

• #delete_workbook_name(delete_workbook_name_request, opts = {}) ⇒ Object

  Delete a named range in the workbook.

• #delete_workbook_names(delete_workbook_names_request, opts = {}) ⇒ Object

  Delete all named ranges in the workbook.

• #delete_worksheet(delete_worksheet_request, opts = {}) ⇒ Object

  Delete a worksheet in the workbook.

• #delete_worksheet_background(delete_worksheet_background_request, opts = {}) ⇒ Object

  Delete background image in the worksheet.

• #delete_worksheet_cells_range(delete_worksheet_cells_range_request, opts = {}) ⇒ Object

  Delete a range of cells and shift existing cells based on the specified shift option.

• #delete_worksheet_chart(delete_worksheet_chart_request, opts = {}) ⇒ Object

  Delete a chart by index in the worksheet.

• #delete_worksheet_chart_legend(delete_worksheet_chart_legend_request, opts = {}) ⇒ Object

  Hides chart legend in the worksheet.

• #delete_worksheet_chart_title(delete_worksheet_chart_title_request, opts = {}) ⇒ Object

  Hide chart title in the worksheet.

• #delete_worksheet_charts(delete_worksheet_charts_request, opts = {}) ⇒ Object

  Clear the charts in the worksheets.

• #delete_worksheet_columns(delete_worksheet_columns_request, opts = {}) ⇒ Object

  Delete worksheet columns in the worksheet.

• #delete_worksheet_comment(delete_worksheet_comment_request, opts = {}) ⇒ Object

  Delete cell comment in the worksheet.

• #delete_worksheet_comments(delete_worksheet_comments_request, opts = {}) ⇒ Object

  Delete all comments in the worksheet.

• #delete_worksheet_conditional_formatting(delete_worksheet_conditional_formatting_request, opts = {}) ⇒ Object

  Remove a conditional formatting.

• #delete_worksheet_conditional_formatting_area(delete_worksheet_conditional_formatting_area_request, opts = {}) ⇒ Object

  Remove cell area from conditional formatting.

• #delete_worksheet_conditional_formattings(delete_worksheet_conditional_formattings_request, opts = {}) ⇒ Object

  Clear all conditional formattings in the worksheet.

• #delete_worksheet_date_filter(delete_worksheet_date_filter_request, opts = {}) ⇒ Object

  Remove a date filter in the worksheet.

• #delete_worksheet_filter(delete_worksheet_filter_request, opts = {}) ⇒ Object

  Delete a filter for a column in the worksheet.

• #delete_worksheet_freeze_panes(delete_worksheet_freeze_panes_request, opts = {}) ⇒ Object

  Unfreeze panes in worksheet.

• #delete_worksheet_from_spreadsheet(delete_worksheet_from_spreadsheet_request, opts = {}) ⇒ Object

  The Web API endpoint allows users to delete a specified worksheet from a workbook.

• #delete_worksheet_hyperlink(delete_worksheet_hyperlink_request, opts = {}) ⇒ Object

  Delete hyperlink by index in the worksheet.

• #delete_worksheet_hyperlinks(delete_worksheet_hyperlinks_request, opts = {}) ⇒ Object

  Delete all hyperlinks in the worksheet.

• #delete_worksheet_list_object(delete_worksheet_list_object_request, opts = {}) ⇒ Object

  Delete list object by index in the worksheet.

• #delete_worksheet_list_objects(delete_worksheet_list_objects_request, opts = {}) ⇒ Object

  Delete ListObjects in the worksheet.

• #delete_worksheet_ole_object(delete_worksheet_ole_object_request, opts = {}) ⇒ Object

  Delete an OLE object in the worksheet.

• #delete_worksheet_ole_objects(delete_worksheet_ole_objects_request, opts = {}) ⇒ Object

  Delete all OLE objects in the worksheet.

• #delete_worksheet_picture(delete_worksheet_picture_request, opts = {}) ⇒ Object

  Delete a picture object by index in the worksheet.

• #delete_worksheet_pictures(delete_worksheet_pictures_request, opts = {}) ⇒ Object

  Delete all pictures in the worksheet.

• #delete_worksheet_pivot_table(delete_worksheet_pivot_table_request, opts = {}) ⇒ Object

  Delete PivotTable by index in the worksheet.

• #delete_worksheet_pivot_table_filter(delete_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object

  Delete a pivot filter in the PivotTable.

• #delete_worksheet_pivot_table_filters(delete_worksheet_pivot_table_filters_request, opts = {}) ⇒ Object

  Delete all pivot filters in the PivotTable.

• #delete_worksheet_pivot_tables(delete_worksheet_pivot_tables_request, opts = {}) ⇒ Object

  Delete PivotTables in the worksheet.

• #delete_worksheet_row(delete_worksheet_row_request, opts = {}) ⇒ Object

  Delete a row in the worksheet.

• #delete_worksheet_rows(delete_worksheet_rows_request, opts = {}) ⇒ Object

  Delete several rows in the worksheet.

• #delete_worksheet_shape(delete_worksheet_shape_request, opts = {}) ⇒ Object

  Delete a shape in the worksheet.

• #delete_worksheet_shapes(delete_worksheet_shapes_request, opts = {}) ⇒ Object

  Delete all shapes in the worksheet.

• #delete_worksheet_sparkline_group(delete_worksheet_sparkline_group_request, opts = {}) ⇒ Object

  Delete a sparkline group in the worksheet.

• #delete_worksheet_sparkline_groups(delete_worksheet_sparkline_groups_request, opts = {}) ⇒ Object

  Delete sparkline groups in the worksheet.

• #delete_worksheet_validation(delete_worksheet_validation_request, opts = {}) ⇒ Object

  Delete a validation by index in worksheet.

• #delete_worksheet_validations(delete_worksheet_validations_request, opts = {}) ⇒ Object

  Delete all validations in the worksheet.

• #delete_worksheets(delete_worksheets_request, opts = {}) ⇒ Object

  Delete matched worksheets in the workbook.

• #download_file(download_file_request, opts = {}) ⇒ Object
• #export_chart_as_format(export_chart_as_format_request, opts = {}) ⇒ Object

  Converts a chart of spreadsheet in cloud storage to the specified format.

• #export_range_as_format(export_range_as_format_request, opts = {}) ⇒ Object

  Converts the range of spreadsheet in cloud storage to the specified format.

• #export_spreadsheet_as_format(export_spreadsheet_as_format_request, opts = {}) ⇒ Object

  Converts a spreadsheet in cloud storage to the specified format.

• #export_table_as_format(export_table_as_format_request, opts = {}) ⇒ Object

  Converts a table of spreadsheet in cloud storage to the specified format.

• #export_worksheet_as_format(export_worksheet_as_format_request, opts = {}) ⇒ Object

  Converts a worksheet of spreadsheet in cloud storage to the specified format.

• #get_all_styles(get_all_styles_request, opts = {}) ⇒ Object

  Get all style in the workbook.

• #get_aspose_cells_cloud_status(get_aspose_cells_cloud_status_request, opts = {}) ⇒ Object

  Check the Health Status of Aspose.Cells Cloud Service.

• #get_cell_html_string(get_cell_html_string_request, opts = {}) ⇒ Object

  Retrieve the HTML string containing data and specific formats in this cell.

• #get_cells_cloud_service_status(get_cells_cloud_service_status_request, opts = {}) ⇒ Object

  Aspose.Cells Cloud service health status check.

• #get_cells_cloud_services_health_check(get_cells_cloud_services_health_check_request, opts = {}) ⇒ Object

  Retrieve cell descriptions in a specified format.

• #get_chart_area(get_chart_area_request, opts = {}) ⇒ Object

  Retrieve chart area description in the worksheet.

• #get_chart_area_border(get_chart_area_border_request, opts = {}) ⇒ Object

  Retrieve chart area border description.

• #get_chart_area_fill_format(get_chart_area_fill_format_request, opts = {}) ⇒ Object

  Retrieve chart area fill format description in the worksheet.

• #get_chart_category_axis(get_chart_category_axis_request, opts = {}) ⇒ Object

  Retrieve descriptions of chart series axis in the chart.

• #get_chart_second_category_axis(get_chart_second_category_axis_request, opts = {}) ⇒ Object

  Retrieve chart second category axis in the chart.

• #get_chart_second_value_axis(get_chart_second_value_axis_request, opts = {}) ⇒ Object

  Retrieve chart second value axis in the chart.

• #get_chart_series_axis(get_chart_series_axis_request, opts = {}) ⇒ Object

  Retrieve descriptions of chart seriesaxis in the chart.

• #get_chart_value_axis(get_chart_value_axis_request, opts = {}) ⇒ Object

  Retrieve chart value axis in the chart.

• #get_disc_usage(get_disc_usage_request, opts = {}) ⇒ Object
• #get_document_properties(get_document_properties_request, opts = {}) ⇒ Object

  Retrieve descriptions of Excel file properties.

• #get_document_property(get_document_property_request, opts = {}) ⇒ Object

  Get Excel property by name.

• #get_file_versions(get_file_versions_request, opts = {}) ⇒ Object
• #get_files_list(get_files_list_request, opts = {}) ⇒ Object
• #get_footer(get_footer_request, opts = {}) ⇒ Object

  Retrieve page footer description in the worksheet.

• #get_header(get_header_request, opts = {}) ⇒ Object

  Retrieve page header description in the worksheet.

• #get_horizontal_page_break(get_horizontal_page_break_request, opts = {}) ⇒ Object

  Retrieve a horizontal page break descripton in the worksheet.

• #get_horizontal_page_breaks(get_horizontal_page_breaks_request, opts = {}) ⇒ Object

  Retrieve descriptions of horizontal page breaks in the worksheet.

• #get_metadata(get_metadata_request, opts = {}) ⇒ Object

  Get cells document properties.

• #get_named_range_value(get_named_range_value_request, opts = {}) ⇒ Object

  Retrieve values in range.

• #get_named_ranges(get_named_ranges_request, opts = {}) ⇒ Object

  Retrieve descriptions of ranges in the worksheets.

• #get_page_count(get_page_count_request, opts = {}) ⇒ Object

  Get page count in the workbook.

• #get_page_setup(get_page_setup_request, opts = {}) ⇒ Object

  Retrieve page setup description in the worksheet.

• #get_pivot_table_field(get_pivot_table_field_request, opts = {}) ⇒ Object

  Retrieve descriptions of pivot fields in the PivotTable.

• #get_public_key(get_public_key_request, opts = {}) ⇒ Object

  Get an asymmetric public key.

• #get_vertical_page_break(get_vertical_page_break_request, opts = {}) ⇒ Object

  Retrieve a vertical page break description in the worksheet.

• #get_vertical_page_breaks(get_vertical_page_breaks_request, opts = {}) ⇒ Object

  Retrieve descriptions of vertical page breaks in the worksheet.

• #get_workbook(get_workbook_request, opts = {}) ⇒ Object

  Retrieve workbooks in various formats.

• #get_workbook_default_style(get_workbook_default_style_request, opts = {}) ⇒ Object

  Retrieve the description of the default style for the workbook .

• #get_workbook_name(get_workbook_name_request, opts = {}) ⇒ Object

  Retrieve description of a named range in the workbook.

• #get_workbook_name_value(get_workbook_name_value_request, opts = {}) ⇒ Object

  Retrieve the value of a named range in the workbook.

• #get_workbook_names(get_workbook_names_request, opts = {}) ⇒ Object

  Retrieve named ranges in the workbook.

• #get_workbook_settings(get_workbook_settings_request, opts = {}) ⇒ Object

  Retrieve descriptions of workbook settings.

• #get_workbook_text_items(get_workbook_text_items_request, opts = {}) ⇒ Object

  Retrieve text items in the workbook.

• #get_worksheet_auto_filter(get_worksheet_auto_filter_request, opts = {}) ⇒ Object

  Retrieve the description of auto filters from a worksheet.

• #get_worksheet_autoshape_with_format(get_worksheet_autoshape_with_format_request, opts = {}) ⇒ Object

  Get autoshape description in some format.

• #get_worksheet_autoshapes(get_worksheet_autoshapes_request, opts = {}) ⇒ Object

  Get autoshapes description in worksheet.

• #get_worksheet_calculate_formula(get_worksheet_calculate_formula_request, opts = {}) ⇒ Object

  Calculate formula in the worksheet.

• #get_worksheet_cell(get_worksheet_cell_request, opts = {}) ⇒ Object

  Retrieve cell data using either cell reference or method name in the worksheet.

• #get_worksheet_cell_style(get_worksheet_cell_style_request, opts = {}) ⇒ Object

  Retrieve cell style descriptions in the worksheet.

• #get_worksheet_cells(get_worksheet_cells_request, opts = {}) ⇒ Object

  Retrieve cell descriptions in a specified format.

• #get_worksheet_cells_range_value(get_worksheet_cells_range_value_request, opts = {}) ⇒ Object

  Retrieve the values of cells within the specified range.

• #get_worksheet_chart(get_worksheet_chart_request, opts = {}) ⇒ Object

  Retrieve the chart in a specified format.

• #get_worksheet_chart_legend(get_worksheet_chart_legend_request, opts = {}) ⇒ Object

  Retrieve chart legend description in the worksheet.

• #get_worksheet_chart_title(get_worksheet_chart_title_request, opts = {}) ⇒ Object

  Retrieve chart title description in the worksheet.

• #get_worksheet_charts(get_worksheet_charts_request, opts = {}) ⇒ Object

  Retrieve descriptions of charts in the worksheet.

• #get_worksheet_column(get_worksheet_column_request, opts = {}) ⇒ Object

  Retrieve worksheet column data by column index.

• #get_worksheet_columns(get_worksheet_columns_request, opts = {}) ⇒ Object

  Retrieve descriptions of worksheet columns.

• #get_worksheet_comment(get_worksheet_comment_request, opts = {}) ⇒ Object

  Retrieve the description of comment in the worksheet.

• #get_worksheet_comments(get_worksheet_comments_request, opts = {}) ⇒ Object

  Retrieve the description of comments in the worksheet.

• #get_worksheet_conditional_formatting(get_worksheet_conditional_formatting_request, opts = {}) ⇒ Object

  Retrieve conditional formatting descriptions in the worksheet.

• #get_worksheet_conditional_formattings(get_worksheet_conditional_formattings_request, opts = {}) ⇒ Object

  Retrieve descriptions of conditional formattings in a worksheet.

• #get_worksheet_hyperlink(get_worksheet_hyperlink_request, opts = {}) ⇒ Object

  Retrieve hyperlink description by index in the worksheet.

• #get_worksheet_hyperlinks(get_worksheet_hyperlinks_request, opts = {}) ⇒ Object

  Retrieve descriptions of hyperlinks in the worksheet.

• #get_worksheet_list_object(get_worksheet_list_object_request, opts = {}) ⇒ Object

  Retrieve list object description by index in the worksheet.

• #get_worksheet_list_objects(get_worksheet_list_objects_request, opts = {}) ⇒ Object

  Retrieve descriptions of ListObjects in the worksheet.

• #get_worksheet_merged_cell(get_worksheet_merged_cell_request, opts = {}) ⇒ Object

  Retrieve description of a merged cell by its index in the worksheet.

• #get_worksheet_merged_cells(get_worksheet_merged_cells_request, opts = {}) ⇒ Object

  Get worksheet merged cells.

• #get_worksheet_ole_object(get_worksheet_ole_object_request, opts = {}) ⇒ Object

  Retrieve the OLE object in a specified format in the worksheet.

• #get_worksheet_ole_objects(get_worksheet_ole_objects_request, opts = {}) ⇒ Object

  Retrieve descriptions of OLE objects in the worksheet.

• #get_worksheet_page_count(get_worksheet_page_count_request, opts = {}) ⇒ Object

  Get page count in the worksheet.

• #get_worksheet_picture_with_format(get_worksheet_picture_with_format_request, opts = {}) ⇒ Object

  Retrieve a picture by number in the worksheet.

• #get_worksheet_pictures(get_worksheet_pictures_request, opts = {}) ⇒ Object

  Retrieve descriptions of pictures in the worksheet.

• #get_worksheet_pivot_table(get_worksheet_pivot_table_request, opts = {}) ⇒ Object

  Retrieve PivotTable information by index in the worksheet.

• #get_worksheet_pivot_table_filter(get_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object

  Retrieve PivotTable filters in the worksheet.

• #get_worksheet_pivot_table_filters(get_worksheet_pivot_table_filters_request, opts = {}) ⇒ Object

  Gets PivotTable filters in worksheet.

• #get_worksheet_pivot_tables(get_worksheet_pivot_tables_request, opts = {}) ⇒ Object

  Retrieve descriptions of pivottables in the worksheet.

• #get_worksheet_row(get_worksheet_row_request, opts = {}) ⇒ Object

  Retrieve row data by the row’s index in the worksheet.

• #get_worksheet_rows(get_worksheet_rows_request, opts = {}) ⇒ Object

  Retrieve descriptions of rows in the worksheet.

• #get_worksheet_shape(get_worksheet_shape_request, opts = {}) ⇒ Object

  Retrieve description of shape in the worksheet.

• #get_worksheet_shapes(get_worksheet_shapes_request, opts = {}) ⇒ Object

  Retrieve descriptions of shapes in the worksheet.

• #get_worksheet_sparkline_group(get_worksheet_sparkline_group_request, opts = {}) ⇒ Object

  Retrieve description of a sparkline group in the worksheet.

• #get_worksheet_sparkline_groups(get_worksheet_sparkline_groups_request, opts = {}) ⇒ Object

  Retrieve descriptions of sparkline groups in the worksheet.

• #get_worksheet_text_items(get_worksheet_text_items_request, opts = {}) ⇒ Object

  Retrieve text items in the worksheet.

• #get_worksheet_validation(get_worksheet_validation_request, opts = {}) ⇒ Object

  Retrieve a validation by its index in the worksheet.

• #get_worksheet_validations(get_worksheet_validations_request, opts = {}) ⇒ Object

  Retrieve descriptions of validations in the worksheet.

• #get_worksheet_with_format(get_worksheet_with_format_request, opts = {}) ⇒ Object

  Retrieve the worksheet in a specified format from the workbook.

• #get_worksheets(get_worksheets_request, opts = {}) ⇒ Object

  Retrieve the description of worksheets from a workbook.

• #import_data_into_spreadsheet(import_data_into_spreadsheet_request, opts = {}) ⇒ Object
• #initialize(client_id, client_secret, app_version = 'v3.0', app_host = 'api.aspose.cloud', api_client = ApiClient.default) ⇒ CellsApi constructor

  A new instance of CellsApi.

• #math_calculate(math_calculate_request, opts = {}) ⇒ Object

  The Math Calculate API enables you to perform a variety of mathematical operations on a selected range of cells.

• #merge_remote_spreadsheet(merge_remote_spreadsheet_request, opts = {}) ⇒ Object

  Merge a spreadsheet file into other spreadsheet in cloud storage, and output a specified format file.

• #merge_spreadsheets(merge_spreadsheets_request, opts = {}) ⇒ Object

  Merge local spreadsheet files into a specified format file.

• #merge_spreadsheets_in_remote_folder(merge_spreadsheets_in_remote_folder_request, opts = {}) ⇒ Object

  Merge spreadsheet files in folder of cloud storage into a specified format file.

• #move_file(move_file_request, opts = {}) ⇒ Object
• #move_folder(move_folder_request, opts = {}) ⇒ Object
• #move_worksheet_in_spreadsheet(move_worksheet_in_spreadsheet_request, opts = {}) ⇒ Object

  The Web API endpoint allows users to move a specified worksheet within a workbook.

• #object_exists(object_exists_request, opts = {}) ⇒ Object
• #post_access_token(post_access_token_request, opts = {}) ⇒ Object

  Get Access Token Result: The Cells Cloud Get Token API acts as a proxy service, forwarding user requests to the Aspose Cloud authentication server and returning the resulting access token to the client.

• #post_add_text_content(post_add_text_content_request, opts = {}) ⇒ Object

  Adds text content to a specified location within a document.

• #post_analyze_excel(post_analyze_excel_request, opts = {}) ⇒ Object

  Perform business analysis of data in Excel files.

• #post_assemble(post_assemble_request, opts = {}) ⇒ Object

  Assemble data files with template files to generate files in various formats.

• #post_autofit_workbook_columns(post_autofit_workbook_columns_request, opts = {}) ⇒ Object

  Autofit columns in the workbook.

• #post_autofit_workbook_rows(post_autofit_workbook_rows_request, opts = {}) ⇒ Object

  Autofit rows in the workbook.

• #post_autofit_worksheet_columns(post_autofit_worksheet_columns_request, opts = {}) ⇒ Object

  Autofit columns in the worksheet.

• #post_autofit_worksheet_row(post_autofit_worksheet_row_request, opts = {}) ⇒ Object

  Autofit a row in the worksheet.

• #post_autofit_worksheet_rows(post_autofit_worksheet_rows_request, opts = {}) ⇒ Object

  Autofit rows in the worksheet.

• #post_batch_convert(post_batch_convert_request, opts = {}) ⇒ Object

  Batch converting files that meet specific matching conditions.

• #post_batch_lock(post_batch_lock_request, opts = {}) ⇒ Object

  Batch locking files that meet specific matching conditions.

• #post_batch_protect(post_batch_protect_request, opts = {}) ⇒ Object

  Batch protecting files that meet specific matching conditions.

• #post_batch_split(post_batch_split_request, opts = {}) ⇒ Object

  Batch splitting files that meet specific matching conditions.

• #post_batch_unlock(post_batch_unlock_request, opts = {}) ⇒ Object

  Batch unlocking files that meet specific matching conditions.

• #post_cell_calculate(post_cell_calculate_request, opts = {}) ⇒ Object

  Calculate cell formula in the worksheet.

• #post_cell_characters(post_cell_characters_request, opts = {}) ⇒ Object

  Set cell characters in the worksheet.

• #post_character_count(post_character_count_request, opts = {}) ⇒ Object
• #post_chart_category_axis(post_chart_category_axis_request, opts = {}) ⇒ Object

  Update chart category axis in the chart.

• #post_chart_second_category_axis(post_chart_second_category_axis_request, opts = {}) ⇒ Object

  Update chart sencond category axis in the chart.

• #post_chart_second_value_axis(post_chart_second_value_axis_request, opts = {}) ⇒ Object

  Update chart sencond value axis in the chart.

• #post_chart_series_axis(post_chart_series_axis_request, opts = {}) ⇒ Object

  Update chart series axis in the chart.

• #post_chart_value_axis(post_chart_value_axis_request, opts = {}) ⇒ Object

  Update chart value axis in the chart.

• #post_clear_contents(post_clear_contents_request, opts = {}) ⇒ Object

  Clear cell area contents in the worksheet.

• #post_clear_formats(post_clear_formats_request, opts = {}) ⇒ Object

  Clear cell formats in the worksheet.

• #post_clear_objects(post_clear_objects_request, opts = {}) ⇒ Object

  Clear internal elements in Excel files and generate output files in various formats.

• #post_column_style(post_column_style_request, opts = {}) ⇒ Object

  Set column style in the worksheet.

• #post_compress(post_compress_request, opts = {}) ⇒ Object

  Compress files and generate target files in various formats, supported file formats are include Xls, Xlsx, Xlsm, Xlsb, Ods and more.

• #post_convert_text(post_convert_text_request, opts = {}) ⇒ Object

  Enhance Excel data through essential text conversions: convert text to numbers, replace characters and line breaks, and remove accents.

• #post_convert_workbook(post_convert_workbook_request, opts = {}) ⇒ Object
• #post_convert_workbook_to_csv(post_convert_workbook_to_csv_request, opts = {}) ⇒ Object

  Convert Excel file to Csv files.

• #post_convert_workbook_to_docx(post_convert_workbook_to_docx_request, opts = {}) ⇒ Object

  Convert Excel file to Docx files.

• #post_convert_workbook_to_html(post_convert_workbook_to_html_request, opts = {}) ⇒ Object

  Convert Excel file to HTML files.

• #post_convert_workbook_to_json(post_convert_workbook_to_json_request, opts = {}) ⇒ Object

  Convert Excel file to Json files.

• #post_convert_workbook_to_markdown(post_convert_workbook_to_markdown_request, opts = {}) ⇒ Object

  Convert Excel file to Markdown files.

• #post_convert_workbook_to_pdf(post_convert_workbook_to_pdf_request, opts = {}) ⇒ Object

  Convert Excel file to PDF files.

• #post_convert_workbook_to_png(post_convert_workbook_to_png_request, opts = {}) ⇒ Object

  Convert Excel file to PNG files.

• #post_convert_workbook_to_pptx(post_convert_workbook_to_pptx_request, opts = {}) ⇒ Object

  Convert Excel file to Pptx files.

• #post_convert_workbook_to_sql(post_convert_workbook_to_sql_request, opts = {}) ⇒ Object

  Convert Excel file to SQL Script files.

• #post_convert_worksheet_to_image(post_convert_worksheet_to_image_request, opts = {}) ⇒ Object
• #post_copy_cell_into_cell(post_copy_cell_into_cell_request, opts = {}) ⇒ Object

  Copy data from a source cell to a destination cell in the worksheet.

• #post_copy_worksheet(post_copy_worksheet_request, opts = {}) ⇒ Object

  Copy contents and formats from another worksheet.

• #post_copy_worksheet_columns(post_copy_worksheet_columns_request, opts = {}) ⇒ Object

  Copy data from source columns to destination columns in the worksheet.

• #post_copy_worksheet_rows(post_copy_worksheet_rows_request, opts = {}) ⇒ Object

  Copy data and formats from specific entire rows in the worksheet.

• #post_data_cleansing(post_data_cleansing_request, opts = {}) ⇒ Object

  Data cleansing of spreadsheet files is a data management process used to identify, correct, and remove errors, incompleteness, duplicates, or inaccuracies in tables and ranges.

• #post_data_deduplication(post_data_deduplication_request, opts = {}) ⇒ Object

  Data deduplication of spreadsheet files is mainly used to eliminate duplicate data in tables and ranges.

• #post_data_fill(post_data_fill_request, opts = {}) ⇒ Object

  Data filling for spreadsheet files is primarily used to fill empty data in tables and ranges.

• #post_data_transformation(post_data_transformation_request, opts = {}) ⇒ Object

  Transform spreadsheet data is mainly used to pivot columns, unpivot columns.

• #post_delete_incomplete_rows(post_delete_incomplete_rows_request, opts = {}) ⇒ Object

  Deleting incomplete rows of spreadsheet files is mainly used to eliminate incomplete rows in tables and ranges.

• #post_digital_signature(post_digital_signature_request, opts = {}) ⇒ Object

  Excel file digital signature.

• #post_encrypt_workbook(post_encrypt_workbook_request, opts = {}) ⇒ Object

  Excel Encryption.

• #post_export(post_export_request, opts = {}) ⇒ Object

  Export Excel internal elements or the workbook itself to various format files.

• #post_extract_text(post_extract_text_request, opts = {}) ⇒ Object

  Effortlessly extract text and numbers from Excel cells with precise options.

• #post_fit_tall_to_pages(post_fit_tall_to_pages_request, opts = {}) ⇒ Object

  Set the scale at which the page will fit tall when printed on the sheet.

• #post_fit_wide_to_pages(post_fit_wide_to_pages_request, opts = {}) ⇒ Object

  Set the scale at which the page will fit wide when printed on the sheet.

• #post_footer(post_footer_request, opts = {}) ⇒ Object

  Update page footer in the worksheet.

• #post_group_worksheet_columns(post_group_worksheet_columns_request, opts = {}) ⇒ Object

  Group worksheet columns in the worksheet.

• #post_group_worksheet_rows(post_group_worksheet_rows_request, opts = {}) ⇒ Object

  Group rows in the worksheet.

• #post_header(post_header_request, opts = {}) ⇒ Object

  Update page header in the worksheet.

• #post_hide_worksheet_columns(post_hide_worksheet_columns_request, opts = {}) ⇒ Object

  Hide worksheet columns in the worksheet.

• #post_hide_worksheet_rows(post_hide_worksheet_rows_request, opts = {}) ⇒ Object

  Hide rows in worksheet.

• #post_import(post_import_request, opts = {}) ⇒ Object

  Import data into an Excel file and generate output files in various formats.

• #post_import_data(post_import_data_request, opts = {}) ⇒ Object

  Import data into the Excel file.

• #post_lock(post_lock_request, opts = {}) ⇒ Object

  Lock Excel files.

• #post_merge(post_merge_request, opts = {}) ⇒ Object

  Merge cells in the worksheet.

• #post_metadata(post_metadata_request, opts = {}) ⇒ Object

  Update document properties in Excel file, and save them is various formats.

• #post_move_worksheet(post_move_worksheet_request, opts = {}) ⇒ Object

  Move worksheet in the workbook.

• #post_page_setup(post_page_setup_request, opts = {}) ⇒ Object

  Update page setup in the worksheet.

• #post_pivot_table_cell_style(post_pivot_table_cell_style_request, opts = {}) ⇒ Object

  Update cell style in the PivotTable.

• #post_pivot_table_field_hide_item(post_pivot_table_field_hide_item_request, opts = {}) ⇒ Object

  Hide a pivot field item in the PivotTable.

• #post_pivot_table_field_move_to(post_pivot_table_field_move_to_request, opts = {}) ⇒ Object

  Move a pivot field in the PivotTable.

• #post_pivot_table_style(post_pivot_table_style_request, opts = {}) ⇒ Object

  Update style in the PivotTable.

• #post_pivot_table_update_pivot_field(post_pivot_table_update_pivot_field_request, opts = {}) ⇒ Object

  Update pivot field in the PivotTable.

• #post_pivot_table_update_pivot_fields(post_pivot_table_update_pivot_fields_request, opts = {}) ⇒ Object

  Update pivot fields in the PivotTable.

• #post_protect(post_protect_request, opts = {}) ⇒ Object

  Excel files encryption.

• #post_protect_workbook(post_protect_workbook_request, opts = {}) ⇒ Object

  Excel protection.

• #post_remove_characters(post_remove_characters_request, opts = {}) ⇒ Object

  A comprehensive set of tools for cleaning text content within selected cells.

• #post_remove_duplicates(post_remove_duplicates_request, opts = {}) ⇒ Object

  Efficiently remove duplicate substrings from Excel cells.

• #post_rename_worksheet(post_rename_worksheet_request, opts = {}) ⇒ Object

  Rename worksheet in the workbook.

• #post_repair(post_repair_request, opts = {}) ⇒ Object

  Repair abnormal files and generate files in various formats.

• #post_replace(post_replace_request, opts = {}) ⇒ Object

  Replace specified text with new text in Excel files.

• #post_reverse(post_reverse_request, opts = {}) ⇒ Object

  Reverse rows or columns in Excel files and create output files in various formats.

• #post_rotate(post_rotate_request, opts = {}) ⇒ Object

  Rotate rows, columns, or other objects in Excel files and save them in various formats.

• #post_row_style(post_row_style_request, opts = {}) ⇒ Object

  Apply formats to an entire row in the worksheet.

• #post_run_task(post_run_task_request, opts = {}) ⇒ Object

  Run tasks.

• #post_search(post_search_request, opts = {}) ⇒ Object

  Search for specified text within Excel files.

• #post_set_cell_html_string(post_set_cell_html_string_request, opts = {}) ⇒ Object

  Set the HTML string containing data and specific formats in this cell.

• #post_set_cell_range_value(post_set_cell_range_value_request, opts = {}) ⇒ Object

  Set the value of the range in the worksheet.

• #post_set_worksheet_column_width(post_set_worksheet_column_width_request, opts = {}) ⇒ Object

  Set worksheet column width.

• #post_specify_words_count(post_specify_words_count_request, opts = {}) ⇒ Object
• #post_split(post_split_request, opts = {}) ⇒ Object

  Split Excel spreadsheet files based on worksheets and create output files in various formats.

• #post_split_text(post_split_text_request, opts = {}) ⇒ Object

  Efficiently divides Excel cell content into columns or rows based on specified delimiters or patterns.

• #post_trim_content(post_trim_content_request, opts = {}) ⇒ Object

  The PostTrimContent API is designed to process and trim content within a specified range in a spreadsheet.

• #post_ungroup_worksheet_columns(post_ungroup_worksheet_columns_request, opts = {}) ⇒ Object

  Ungroup worksheet columns.

• #post_ungroup_worksheet_rows(post_ungroup_worksheet_rows_request, opts = {}) ⇒ Object

  Ungroup rows in the worksheet.

• #post_unhide_worksheet_columns(post_unhide_worksheet_columns_request, opts = {}) ⇒ Object

  Unhide worksheet columns in the worksheet.

• #post_unhide_worksheet_rows(post_unhide_worksheet_rows_request, opts = {}) ⇒ Object

  Unhide rows in the worksheet.

• #post_unlock(post_unlock_request, opts = {}) ⇒ Object

  Unlock Excel files.

• #post_update_word_case(post_update_word_case_request, opts = {}) ⇒ Object

  Managing inconsistent text case in spreadsheets (Excel, Google Sheets, CSV) can be frustrating, especially with large datasets.

• #post_update_worksheet_cell_style(post_update_worksheet_cell_style_request, opts = {}) ⇒ Object

  Set cell style using cell name in the worksheet.

• #post_update_worksheet_ole_object(post_update_worksheet_ole_object_request, opts = {}) ⇒ Object

  Update an OLE object in worksheet.

• #post_update_worksheet_property(post_update_worksheet_property_request, opts = {}) ⇒ Object

  Update worksheet properties in the workbook.

• #post_update_worksheet_range_style(post_update_worksheet_range_style_request, opts = {}) ⇒ Object

  Update cell range styles in the worksheet.

• #post_update_worksheet_row(post_update_worksheet_row_request, opts = {}) ⇒ Object

  Update height of rows in the worksheet.

• #post_update_worksheet_zoom(post_update_worksheet_zoom_request, opts = {}) ⇒ Object

  Update the scaling percentage in the worksheet.

• #post_watermark(post_watermark_request, opts = {}) ⇒ Object

  Add Text Watermark to Excel files and generate output files in various formats.

• #post_words_count(post_words_count_request, opts = {}) ⇒ Object
• #post_workbook_calculate_formula(post_workbook_calculate_formula_request, opts = {}) ⇒ Object

  Calculate all formulas in the workbook.

• #post_workbook_data_cleansing(post_workbook_data_cleansing_request, opts = {}) ⇒ Object

  Data cleaning of spreadsheet files is a data management process used to identify, correct, and remove errors, incompleteness, duplicates, or inaccuracies in tables and ranges.

• #post_workbook_data_deduplication(post_workbook_data_deduplication_request, opts = {}) ⇒ Object

  Data deduplication of spreadsheet files is mainly used to eliminate duplicate data in tables and ranges.

• #post_workbook_data_fill(post_workbook_data_fill_request, opts = {}) ⇒ Object

  Data filling for spreadsheet files is primarily used to fill empty data in tables and ranges.

• #post_workbook_export_xml(post_workbook_export_xml_request, opts = {}) ⇒ Object

  Export XML data from an Excel file.

• #post_workbook_get_smart_marker_result(post_workbook_get_smart_marker_result_request, opts = {}) ⇒ Object

  Smart marker processing.

• #post_workbook_import_json(post_workbook_import_json_request, opts = {}) ⇒ Object

  Import a JSON data file into the workbook.

• #post_workbook_import_xml(post_workbook_import_xml_request, opts = {}) ⇒ Object

  Import an XML data file into an Excel file.

• #post_workbook_name(post_workbook_name_request, opts = {}) ⇒ Object

  Update a named range in the workbook.

• #post_workbook_save_as(post_workbook_save_as_request, opts = {}) ⇒ Object

  Save an Excel file in various formats.

• #post_workbook_settings(post_workbook_settings_request, opts = {}) ⇒ Object

  Update setting in the workbook.

• #post_workbook_split(post_workbook_split_request, opts = {}) ⇒ Object

  Split the workbook with a specific format.

• #post_workbook_text_replace(post_workbook_text_replace_request, opts = {}) ⇒ Object

  Replace text in the workbook.

• #post_workbooks_merge(post_workbooks_merge_request, opts = {}) ⇒ Object

  Merge a workbook into the existing workbook.

• #post_workbooks_text_search(post_workbooks_text_search_request, opts = {}) ⇒ Object

  Search for text in the workbook.

• #post_worksheet_auto_filter_refresh(post_worksheet_auto_filter_refresh_request, opts = {}) ⇒ Object

  Refresh auto filters in the worksheet.

• #post_worksheet_calculate_formula(post_worksheet_calculate_formula_request, opts = {}) ⇒ Object

  Calculate formula in the worksheet.

• #post_worksheet_cell_set_value(post_worksheet_cell_set_value_request, opts = {}) ⇒ Object

  Set cell value using cell name in the worksheet.

• #post_worksheet_cells_range_column_width(post_worksheet_cells_range_column_width_request, opts = {}) ⇒ Object

  Set the column width of the specified range.

• #post_worksheet_cells_range_merge(post_worksheet_cells_range_merge_request, opts = {}) ⇒ Object

  Merge a range of cells into a single cell.

• #post_worksheet_cells_range_move_to(post_worksheet_cells_range_move_to_request, opts = {}) ⇒ Object

  Move the current range to the destination range.

• #post_worksheet_cells_range_outline_border(post_worksheet_cells_range_outline_border_request, opts = {}) ⇒ Object

  Apply an outline border around a range of cells.

• #post_worksheet_cells_range_row_height(post_worksheet_cells_range_row_height_request, opts = {}) ⇒ Object

  Sets row height of range.

• #post_worksheet_cells_range_sort(post_worksheet_cells_range_sort_request, opts = {}) ⇒ Object

  Perform data sorting around a range of cells.

• #post_worksheet_cells_range_style(post_worksheet_cells_range_style_request, opts = {}) ⇒ Object

  Set the style for the specified range.

• #post_worksheet_cells_range_to_image(post_worksheet_cells_range_to_image_request, opts = {}) ⇒ Object
• #post_worksheet_cells_range_un_merge(post_worksheet_cells_range_un_merge_request, opts = {}) ⇒ Object

  Unmerge merged cells within this range.

• #post_worksheet_cells_range_value(post_worksheet_cells_range_value_request, opts = {}) ⇒ Object

  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.

• #post_worksheet_cells_ranges_copy(post_worksheet_cells_ranges_copy_request, opts = {}) ⇒ Object

  Copy content from the source range to the destination range in the worksheet.

• #post_worksheet_chart(post_worksheet_chart_request, opts = {}) ⇒ Object

  Update chart properties in the worksheet.

• #post_worksheet_chart_legend(post_worksheet_chart_legend_request, opts = {}) ⇒ Object

  Update chart legend in the worksheet.

• #post_worksheet_chart_title(post_worksheet_chart_title_request, opts = {}) ⇒ Object

  Update chart title in the worksheet.

• #post_worksheet_comment(post_worksheet_comment_request, opts = {}) ⇒ Object

  Update cell comment in the worksheet.

• #post_worksheet_group_shape(post_worksheet_group_shape_request, opts = {}) ⇒ Object

  Group shapes in the worksheet.

• #post_worksheet_hyperlink(post_worksheet_hyperlink_request, opts = {}) ⇒ Object

  Update hyperlink by index in the worksheet.

• #post_worksheet_list_column(post_worksheet_list_column_request, opts = {}) ⇒ Object

  Update list column in list object.

• #post_worksheet_list_columns_total(post_worksheet_list_columns_total_request, opts = {}) ⇒ Object

  Update total of list columns in the table.

• #post_worksheet_list_object(post_worksheet_list_object_request, opts = {}) ⇒ Object

  Update list object by index in the worksheet.

• #post_worksheet_list_object_convert_to_range(post_worksheet_list_object_convert_to_range_request, opts = {}) ⇒ Object

  Convert list object to range in the worksheet.

• #post_worksheet_list_object_insert_slicer(post_worksheet_list_object_insert_slicer_request, opts = {}) ⇒ Object

  Insert slicer for list object.

• #post_worksheet_list_object_remove_duplicates(post_worksheet_list_object_remove_duplicates_request, opts = {}) ⇒ Object

  Remove duplicates in list object.

• #post_worksheet_list_object_sort_table(post_worksheet_list_object_sort_table_request, opts = {}) ⇒ Object

  Sort list object in the worksheet.

• #post_worksheet_list_object_summarize_with_pivot_table(post_worksheet_list_object_summarize_with_pivot_table_request, opts = {}) ⇒ Object

  Create a pivot table with a list object in the worksheet.

• #post_worksheet_match_blanks(post_worksheet_match_blanks_request, opts = {}) ⇒ Object

  Match all blank cells in the list.

• #post_worksheet_match_non_blanks(post_worksheet_match_non_blanks_request, opts = {}) ⇒ Object

  Match all not blank cells in the list.

• #post_worksheet_merge(post_worksheet_merge_request, opts = {}) ⇒ Object

  Merge cells in the worksheet.

• #post_worksheet_picture(post_worksheet_picture_request, opts = {}) ⇒ Object

  Update a picture by index in the worksheet.

• #post_worksheet_pivot_table_calculate(post_worksheet_pivot_table_calculate_request, opts = {}) ⇒ Object

  Calculate pivottable’s data to cells.

• #post_worksheet_pivot_table_move(post_worksheet_pivot_table_move_request, opts = {}) ⇒ Object

  Move PivotTable in the worksheet.

• #post_worksheet_range_sort(post_worksheet_range_sort_request, opts = {}) ⇒ Object

  Sort a range in the worksheet.

• #post_worksheet_shape(post_worksheet_shape_request, opts = {}) ⇒ Object

  Update a shape in the worksheet.

• #post_worksheet_sparkline_group(post_worksheet_sparkline_group_request, opts = {}) ⇒ Object

  Update a sparkline group in the worksheet.

• #post_worksheet_text_replace(post_worksheet_text_replace_request, opts = {}) ⇒ Object

  Replace old text with new text in the worksheet.

• #post_worksheet_text_search(post_worksheet_text_search_request, opts = {}) ⇒ Object

  Search for text in the worksheet.

• #post_worksheet_ungroup_shape(post_worksheet_ungroup_shape_request, opts = {}) ⇒ Object

  Ungroup shapes in the worksheet.

• #post_worksheet_unmerge(post_worksheet_unmerge_request, opts = {}) ⇒ Object

  Unmerge cells in the worksheet.

• #post_worksheet_validation(post_worksheet_validation_request, opts = {}) ⇒ Object

  Update a validation by index in the worksheet.

• #protect_spreadsheet(protect_spreadsheet_request, opts = {}) ⇒ Object

  Applies dual-layer password protection to Excel spreadsheets, supporting both open and modify passwords with encryption.

• #put_active_worksheet(put_active_worksheet_request, opts = {}) ⇒ Object

  Set active worksheet index in the workbook.

• #put_add_new_worksheet(put_add_new_worksheet_request, opts = {}) ⇒ Object

  Add a new worksheet in the workbook.

• #put_change_visibility_worksheet(put_change_visibility_worksheet_request, opts = {}) ⇒ Object

  Change worksheet visibility in the workbook.

• #put_convert_workbook(put_convert_workbook_request, opts = {}) ⇒ Object

  Convert the workbook from the requested content into files in different formats.

• #put_document_property(put_document_property_request, opts = {}) ⇒ Object

  Set or add an Excel property.

• #put_document_protect_from_changes(put_document_protect_from_changes_request, opts = {}) ⇒ Object

  Excel file write protection.

• #put_horizontal_page_break(put_horizontal_page_break_request, opts = {}) ⇒ Object

  Add a horizontal page breaks in the worksheet.

• #put_insert_new_worksheet(put_insert_new_worksheet_request, opts = {}) ⇒ Object

  Insert a new worksheet in the workbook.

• #put_insert_worksheet_columns(put_insert_worksheet_columns_request, opts = {}) ⇒ Object

  Insert worksheet columns in the worksheet.

• #put_insert_worksheet_row(put_insert_worksheet_row_request, opts = {}) ⇒ Object

  Insert a new row in the worksheet.

• #put_insert_worksheet_rows(put_insert_worksheet_rows_request, opts = {}) ⇒ Object

  Insert several new rows in the worksheet.

• #put_pivot_table_field(put_pivot_table_field_request, opts = {}) ⇒ Object

  Add a pivot field in the PivotTable.

• #put_protect_worksheet(put_protect_worksheet_request, opts = {}) ⇒ Object

  Protect worksheet.

• #put_vertical_page_break(put_vertical_page_break_request, opts = {}) ⇒ Object

  Add a vertical page break in the worksheet.

• #put_workbook_background(put_workbook_background_request, opts = {}) ⇒ Object

  Set background in the workbook.

• #put_workbook_create(put_workbook_create_request, opts = {}) ⇒ Object

  Create a new workbook using different methods.

• #put_workbook_name(put_workbook_name_request, opts = {}) ⇒ Object

  Define a new name in the workbook.

• #put_workbook_water_marker(put_workbook_water_marker_request, opts = {}) ⇒ Object

  Set water marker in the workbook.

• #put_worksheet_add_picture(put_worksheet_add_picture_request, opts = {}) ⇒ Object

  Add a new picture in the worksheet.

• #put_worksheet_background(put_worksheet_background_request, opts = {}) ⇒ Object

  Set background image in the worksheet.

• #put_worksheet_cells_range(put_worksheet_cells_range_request, opts = {}) ⇒ Object

  Insert a range of cells and shift existing cells based on the specified shift option.

• #put_worksheet_chart(put_worksheet_chart_request, opts = {}) ⇒ Object

  Add a new chart in the worksheet.

• #put_worksheet_chart_legend(put_worksheet_chart_legend_request, opts = {}) ⇒ Object

  Show chart legend in the worksheet.

• #put_worksheet_chart_title(put_worksheet_chart_title_request, opts = {}) ⇒ Object

  Set chart title in the worksheet.

• #put_worksheet_color_filter(put_worksheet_color_filter_request, opts = {}) ⇒ Object

  Add a color filter in the worksheet.

• #put_worksheet_comment(put_worksheet_comment_request, opts = {}) ⇒ Object

  Add cell comment in the worksheet.

• #put_worksheet_conditional_formatting(put_worksheet_conditional_formatting_request, opts = {}) ⇒ Object

  Add conditional formatting in the worksheet.

• #put_worksheet_custom_filter(put_worksheet_custom_filter_request, opts = {}) ⇒ Object

  Filter a list with custom criteria in the worksheet.

• #put_worksheet_date_filter(put_worksheet_date_filter_request, opts = {}) ⇒ Object

  Apply a date filter in the worksheet.

• #put_worksheet_dynamic_filter(put_worksheet_dynamic_filter_request, opts = {}) ⇒ Object

  Add a dynamic filter in the worksheet.

• #put_worksheet_filter(put_worksheet_filter_request, opts = {}) ⇒ Object

  Add a filter for a column in the worksheet.

• #put_worksheet_filter_top10(put_worksheet_filter_top10_request, opts = {}) ⇒ Object

  Filter the top 10 items in the list in the worksheet.

• #put_worksheet_format_condition(put_worksheet_format_condition_request, opts = {}) ⇒ Object

  Add a format condition in the worksheet.

• #put_worksheet_format_condition_area(put_worksheet_format_condition_area_request, opts = {}) ⇒ Object

  Add a cell area for the format condition in the worksheet.

• #put_worksheet_format_condition_condition(put_worksheet_format_condition_condition_request, opts = {}) ⇒ Object

  Add a condition for the format condition in the worksheet.

• #put_worksheet_freeze_panes(put_worksheet_freeze_panes_request, opts = {}) ⇒ Object

  Set freeze panes in the worksheet.

• #put_worksheet_hyperlink(put_worksheet_hyperlink_request, opts = {}) ⇒ Object

  Add hyperlink in the worksheet.

• #put_worksheet_icon_filter(put_worksheet_icon_filter_request, opts = {}) ⇒ Object

  Add an icon filter in the worksheet.

• #put_worksheet_list_object(put_worksheet_list_object_request, opts = {}) ⇒ Object

  Add a ListObject in the worksheet.

• #put_worksheet_ole_object(put_worksheet_ole_object_request, opts = {}) ⇒ Object

  Add an OLE object in the worksheet.

• #put_worksheet_pivot_table(put_worksheet_pivot_table_request, opts = {}) ⇒ Object

  Add a PivotTable in the worksheet.

• #put_worksheet_pivot_table_filter(put_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object

  Add a pivot filter to the PivotTable.

• #put_worksheet_shape(put_worksheet_shape_request, opts = {}) ⇒ Object

  Add a shape in the worksheet.

• #put_worksheet_sparkline_group(put_worksheet_sparkline_group_request, opts = {}) ⇒ Object

  Add a sparkline group in the worksheet.

• #put_worksheet_validation(put_worksheet_validation_request, opts = {}) ⇒ Object

  Add a validation at index in the worksheet.

• #rename_worksheet_in_spreadsheet(rename_worksheet_in_spreadsheet_request, opts = {}) ⇒ Object

  The Web API endpoint allows users to rename a specified worksheet within a workbook.

• #replace_content_in_remote_range(replace_content_in_remote_range_request, opts = {}) ⇒ Object

  Replace text in the range of remoted spreadsheet.

• #replace_content_in_remote_spreadsheet(replace_content_in_remote_spreadsheet_request, opts = {}) ⇒ Object

  Replace text in the remoted spreadsheet.

• #replace_content_in_remote_worksheet(replace_content_in_remote_worksheet_request, opts = {}) ⇒ Object

  Replace text in the worksheet of remoted spreadsheet.

• #replace_spreadsheet_content(replace_spreadsheet_content_request, opts = {}) ⇒ Object

  Replace text in the local spreadsheet.

• #save_spreadsheet_as(save_spreadsheet_as_request, opts = {}) ⇒ Object

  Converts a spreadsheet in cloud storage to the specified format.

• #sawp_range(sawp_range_request, opts = {}) ⇒ Object

  The Swap Ranges for Excel API provides a powerful tool to move any two columns, rows, ranges, or individual cells within an Excel file.

• #search_broken_links_in_remote_range(search_broken_links_in_remote_range_request, opts = {}) ⇒ Object

  Search broken links in the range of remoted spreadsheet.

• #search_broken_links_in_remote_spreadsheet(search_broken_links_in_remote_spreadsheet_request, opts = {}) ⇒ Object

  Search broken links in the remoted spreadsheet.

• #search_broken_links_in_remote_worksheet(search_broken_links_in_remote_worksheet_request, opts = {}) ⇒ Object

  Search broken links in the worksheet of remoted spreadsheet.

• #search_content_in_remote_range(search_content_in_remote_range_request, opts = {}) ⇒ Object

  Search text in the range of remoted spreadsheet.

• #search_content_in_remote_spreadsheet(search_content_in_remote_spreadsheet_request, opts = {}) ⇒ Object

  Search text in the remoted spreadsheet.

• #search_content_in_remote_worksheet(search_content_in_remote_worksheet_request, opts = {}) ⇒ Object

  Search text in the worksheet of remoted spreadsheet.

• #search_spreadsheet_broken_links(search_spreadsheet_broken_links_request, opts = {}) ⇒ Object

  Search broken links in the local spreadsheet.

• #search_spreadsheet_content(search_spreadsheet_content_request, opts = {}) ⇒ Object

  Search text in the local spreadsheet.

• #spec(spec_request, opts = {}) ⇒ Object

  Get the specifications.

• #split_remote_spreadsheet(split_remote_spreadsheet_request, opts = {}) ⇒ Object

  Split a spreadsheet in cloud storage into the specified format, multi-file.

• #split_spreadsheet(split_spreadsheet_request, opts = {}) ⇒ Object

  Split a local spreadsheet into the specified format, multi-file.

• #storage_exists(storage_exists_request, opts = {}) ⇒ Object
• #unprotect_spreadsheet(unprotect_spreadsheet_request, opts = {}) ⇒ Object

  Removes dual-layer password protection from Excel spreadsheets, supporting both open and modify passwords with encryption.

• #upload_file(upload_file_request, opts = {}) ⇒ Object

Constructor Details

#initialize(client_id, client_secret, app_version = 'v3.0', app_host = 'api.aspose.cloud', api_client = ApiClient.default) ⇒ CellsApi

Returns a new instance of CellsApi.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 35

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

Instance Attribute Details

#api_client ⇒ Object

Returns the value of attribute api_client.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 33

def api_client
  @api_client
end

Instance Method Details

#add_picture_in_cell(add_picture_in_cell_request, opts = {}) ⇒ Object

add new picture in the cells.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2132

def add_picture_in_cell( add_picture_in_cell_request, opts = {})

   data, _status_code, _headers = add_picture_in_cell_request.create_http_request(@api_client,opts )
   return data
end

#add_worksheet_to_spreadsheet(add_worksheet_to_spreadsheet_request, opts = {}) ⇒ Object

The Web API enables users to add a new worksheet to a workbook, specifying the worksheet’s type, position, and name. This function provides flexibility in managing workbook structure by allowing detailed control over worksheet addition.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 317

def add_worksheet_to_spreadsheet( add_worksheet_to_spreadsheet_request, opts = {})

   data, _status_code, _headers = add_worksheet_to_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#aggregate_cells_by_color(aggregate_cells_by_color_request, opts = {}) ⇒ Object

The Aggregate by Color API provides a convenient way to perform calculations on cells that share the same fill or font color. This API supports a range of aggregate operations, including count, sum, maximum value, minimum value, and average value, enabling you to analyze and summarize data based on color distinctions.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 45

def aggregate_cells_by_color( aggregate_cells_by_color_request, opts = {})

   data, _status_code, _headers = aggregate_cells_by_color_request.create_http_request(@api_client,opts )
   return data
end

#check_cloud_service_health(check_cloud_service_health_request, opts = {}) ⇒ Object

Check the Health Status of Aspose.Cells Cloud Service.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 78

def check_cloud_service_health( check_cloud_service_health_request, opts = {})

   data, _status_code, _headers = check_cloud_service_health_request.create_http_request(@api_client,opts )
   return data
end

#check_workbook_formula_errors(check_workbook_formula_errors_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1523

def check_workbook_formula_errors( check_workbook_formula_errors_request, opts = {})

   data, _status_code, _headers = check_workbook_formula_errors_request.create_http_request(@api_client,opts )
   return data
end

#check_wrokbook_external_reference(check_wrokbook_external_reference_request, opts = {}) ⇒ Object

Export Excel internal elements or the workbook itself to various format files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1516

def check_wrokbook_external_reference( check_wrokbook_external_reference_request, opts = {})

   data, _status_code, _headers = check_wrokbook_external_reference_request.create_http_request(@api_client,opts )
   return data
end

#codegen_spec(codegen_spec_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 476

def codegen_spec( codegen_spec_request, opts = {})

   data, _status_code, _headers = codegen_spec_request.create_http_request(@api_client,opts )
   return data
end

#compress_spreadsheet(compress_spreadsheet_request, opts = {}) ⇒ Object

The Web API endpoint allows users to compress a spreadsheet to reduce its file size. This function provides a straightforward way to optimize the storage and performance of spreadsheets by applying a specified compression level.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 349

def compress_spreadsheet( compress_spreadsheet_request, opts = {})

   data, _status_code, _headers = compress_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#convert_chart_to_image(convert_chart_to_image_request, opts = {}) ⇒ Object

Converts a chart of spreadsheet on a local drive to image.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 230

def convert_chart_to_image( convert_chart_to_image_request, opts = {})

   data, _status_code, _headers = convert_chart_to_image_request.create_http_request(@api_client,opts )
   return data
end

#convert_chart_to_pdf(convert_chart_to_pdf_request, opts = {}) ⇒ Object

Converts a chart of spreadsheet on a local drive to pdf.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 238

def convert_chart_to_pdf( convert_chart_to_pdf_request, opts = {})

   data, _status_code, _headers = convert_chart_to_pdf_request.create_http_request(@api_client,opts )
   return data
end

#convert_range_to_csv(convert_range_to_csv_request, opts = {}) ⇒ Object

Converts a range of spreadsheet on a local drive to the csv file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 206

def convert_range_to_csv( convert_range_to_csv_request, opts = {})

   data, _status_code, _headers = convert_range_to_csv_request.create_http_request(@api_client,opts )
   return data
end

#convert_range_to_html(convert_range_to_html_request, opts = {}) ⇒ Object

Converts a range of spreadsheet on a local drive to the html file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 214

def convert_range_to_html( convert_range_to_html_request, opts = {})

   data, _status_code, _headers = convert_range_to_html_request.create_http_request(@api_client,opts )
   return data
end

#convert_range_to_image(convert_range_to_image_request, opts = {}) ⇒ Object

Converts a range of spreadsheet on a local drive to the image file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 190

def convert_range_to_image( convert_range_to_image_request, opts = {})

   data, _status_code, _headers = convert_range_to_image_request.create_http_request(@api_client,opts )
   return data
end

#convert_range_to_json(convert_range_to_json_request, opts = {}) ⇒ Object

Converts a range of spreadsheet on a local drive to the json file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 222

def convert_range_to_json( convert_range_to_json_request, opts = {})

   data, _status_code, _headers = convert_range_to_json_request.create_http_request(@api_client,opts )
   return data
end

#convert_range_to_pdf(convert_range_to_pdf_request, opts = {}) ⇒ Object

Converts a range of spreadsheet on a local drive to the pdf file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 198

def convert_range_to_pdf( convert_range_to_pdf_request, opts = {})

   data, _status_code, _headers = convert_range_to_pdf_request.create_http_request(@api_client,opts )
   return data
end

#convert_spreadsheet(convert_spreadsheet_request, opts = {}) ⇒ Object

Converts a spreadsheet on a local drive to the specified format.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 126

def convert_spreadsheet( convert_spreadsheet_request, opts = {})

   data, _status_code, _headers = convert_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#convert_table_to_csv(convert_table_to_csv_request, opts = {}) ⇒ Object

Converts a table of spreadsheet on a local drive to the csv file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 166

def convert_table_to_csv( convert_table_to_csv_request, opts = {})

   data, _status_code, _headers = convert_table_to_csv_request.create_http_request(@api_client,opts )
   return data
end

#convert_table_to_html(convert_table_to_html_request, opts = {}) ⇒ Object

Converts a table of spreadsheet on a local drive to the html file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 174

def convert_table_to_html( convert_table_to_html_request, opts = {})

   data, _status_code, _headers = convert_table_to_html_request.create_http_request(@api_client,opts )
   return data
end

#convert_table_to_image(convert_table_to_image_request, opts = {}) ⇒ Object

Converts a table of spreadsheet on a local drive to the image file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 150

def convert_table_to_image( convert_table_to_image_request, opts = {})

   data, _status_code, _headers = convert_table_to_image_request.create_http_request(@api_client,opts )
   return data
end

#convert_table_to_json(convert_table_to_json_request, opts = {}) ⇒ Object

Converts a table of spreadsheet on a local drive to the json file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 182

def convert_table_to_json( convert_table_to_json_request, opts = {})

   data, _status_code, _headers = convert_table_to_json_request.create_http_request(@api_client,opts )
   return data
end

#convert_table_to_pdf(convert_table_to_pdf_request, opts = {}) ⇒ Object

Converts a table of spreadsheet on a local drive to the pdf file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 158

def convert_table_to_pdf( convert_table_to_pdf_request, opts = {})

   data, _status_code, _headers = convert_table_to_pdf_request.create_http_request(@api_client,opts )
   return data
end

#convert_worksheet_to_image(convert_worksheet_to_image_request, opts = {}) ⇒ Object

Converts a worksheet of spreadsheet on a local drive to the image format.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 134

def convert_worksheet_to_image( convert_worksheet_to_image_request, opts = {})

   data, _status_code, _headers = convert_worksheet_to_image_request.create_http_request(@api_client,opts )
   return data
end

#convert_worksheet_to_pdf(convert_worksheet_to_pdf_request, opts = {}) ⇒ Object

Converts a worksheet of spreadsheet on a local drive to the pdf file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 142

def convert_worksheet_to_pdf( convert_worksheet_to_pdf_request, opts = {})

   data, _status_code, _headers = convert_worksheet_to_pdf_request.create_http_request(@api_client,opts )
   return data
end

#copy_file(copy_file_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 529

def copy_file( copy_file_request, opts = {})

   data, _status_code, _headers = copy_file_request.create_http_request(@api_client,opts )
   return data
end

#copy_folder(copy_folder_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 564

def copy_folder( copy_folder_request, opts = {})

   data, _status_code, _headers = copy_folder_request.create_http_request(@api_client,opts )
   return data
end

#create_folder(create_folder_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 557

def create_folder( create_folder_request, opts = {})

   data, _status_code, _headers = create_folder_request.create_http_request(@api_client,opts )
   return data
end

#create_spreadsheet(create_spreadsheet_request, opts = {}) ⇒ Object

The Web API allows users to create a new spreadsheet with a specified name. Optionally, a template can be provided to initialize the spreadsheet with predefined content or formatting.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 309

def create_spreadsheet( create_spreadsheet_request, opts = {})

   data, _status_code, _headers = create_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#delete_decrypt_workbook(delete_decrypt_workbook_request, opts = {}) ⇒ Object

Excel files decryption.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2388

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

#delete_document_properties(delete_document_properties_request, opts = {}) ⇒ Object

Delete all custom document properties and reset built-in ones.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2364

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

#delete_document_property(delete_document_property_request, opts = {}) ⇒ Object

Delete an Excel property.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2356

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_document_un_protect_from_changes(delete_document_un_protect_from_changes_request, opts = {}) ⇒ Object

Excel file cancel write protection.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2420

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

#delete_file(delete_file_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 543

def delete_file( delete_file_request, opts = {})

   data, _status_code, _headers = delete_file_request.create_http_request(@api_client,opts )
   return data
end

#delete_folder(delete_folder_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 578

def delete_folder( delete_folder_request, opts = {})

   data, _status_code, _headers = delete_folder_request.create_http_request(@api_client,opts )
   return data
end

#delete_header_footer(delete_header_footer_request, opts = {}) ⇒ Object

Clear header and footer in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2052

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

#delete_horizontal_page_break(delete_horizontal_page_break_request, opts = {}) ⇒ Object

Delete a horizontal page break in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2028

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

#delete_horizontal_page_breaks(delete_horizontal_page_breaks_request, opts = {}) ⇒ Object

Delete horizontal page breaks in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2012

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_metadata(delete_metadata_request, opts = {}) ⇒ Object

Delete cells document properties in Excel file, and save them is various formats.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1796

def delete_metadata( delete_metadata_request, opts = {})

   data, _status_code, _headers = delete_metadata_request.create_http_request(@api_client,opts )
   return data
end

#delete_pivot_table_field(delete_pivot_table_field_request, opts = {}) ⇒ Object

Delete a pivot field in the PivotTable.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2308

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_spreadsheet_blank_columns(delete_spreadsheet_blank_columns_request, opts = {}) ⇒ Object

Delete all blank columns which do not contain any data.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 492

def delete_spreadsheet_blank_columns( delete_spreadsheet_blank_columns_request, opts = {})

   data, _status_code, _headers = delete_spreadsheet_blank_columns_request.create_http_request(@api_client,opts )
   return data
end

#delete_spreadsheet_blank_rows(delete_spreadsheet_blank_rows_request, opts = {}) ⇒ Object

Delete all blank rows which do not contain any data or other object.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 484

def delete_spreadsheet_blank_rows( delete_spreadsheet_blank_rows_request, opts = {})

   data, _status_code, _headers = delete_spreadsheet_blank_rows_request.create_http_request(@api_client,opts )
   return data
end

#delete_spreadsheet_blank_worksheets(delete_spreadsheet_blank_worksheets_request, opts = {}) ⇒ Object

Delete all blank worksheets which do not contain any data or other object.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 500

def delete_spreadsheet_blank_worksheets( delete_spreadsheet_blank_worksheets_request, opts = {})

   data, _status_code, _headers = delete_spreadsheet_blank_worksheets_request.create_http_request(@api_client,opts )
   return data
end

#delete_un_protect_workbook(delete_un_protect_workbook_request, opts = {}) ⇒ Object

Excel unprotection.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2404

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

#delete_unprotect_worksheet(delete_unprotect_worksheet_request, opts = {}) ⇒ Object

Unprotect worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3048

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

#delete_vertical_page_break(delete_vertical_page_break_request, opts = {}) ⇒ Object

Delete a vertical page break in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2020

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_vertical_page_breaks(delete_vertical_page_breaks_request, opts = {}) ⇒ Object

Delete vertical page breaks in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2004

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_workbook_background(delete_workbook_background_request, opts = {}) ⇒ Object

Delete background in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2936

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

#delete_workbook_name(delete_workbook_name_request, opts = {}) ⇒ Object

Delete a named range in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2832

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

#delete_workbook_names(delete_workbook_names_request, opts = {}) ⇒ Object

Delete all named ranges in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2824

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_worksheet(delete_worksheet_request, opts = {}) ⇒ Object

Delete a worksheet in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3016

def delete_worksheet( delete_worksheet_request, opts = {})

   data, _status_code, _headers = delete_worksheet_request.create_http_request(@api_client,opts )
   return data
end

#delete_worksheet_background(delete_worksheet_background_request, opts = {}) ⇒ Object

Delete background image in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3200

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

#delete_worksheet_cells_range(delete_worksheet_cells_range_request, opts = {}) ⇒ Object

Delete a range of cells and shift existing cells based on the specified shift option.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2555

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

#delete_worksheet_chart(delete_worksheet_chart_request, opts = {}) ⇒ Object

Delete a chart by index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1166

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

#delete_worksheet_chart_legend(delete_worksheet_chart_legend_request, opts = {}) ⇒ Object

Hides chart legend in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1206

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

#delete_worksheet_chart_title(delete_worksheet_chart_title_request, opts = {}) ⇒ Object

Hide chart title in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1246

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

#delete_worksheet_charts(delete_worksheet_charts_request, opts = {}) ⇒ Object

Clear the charts in the worksheets.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1214

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

#delete_worksheet_columns(delete_worksheet_columns_request, opts = {}) ⇒ Object

Delete worksheet columns in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 942

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

#delete_worksheet_comment(delete_worksheet_comment_request, opts = {}) ⇒ Object

Delete cell comment in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3096

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_worksheet_comments(delete_worksheet_comments_request, opts = {}) ⇒ Object

Delete all comments in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3104

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

#delete_worksheet_conditional_formatting(delete_worksheet_conditional_formatting_request, opts = {}) ⇒ Object

Remove a conditional formatting.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1390

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

#delete_worksheet_conditional_formatting_area(delete_worksheet_conditional_formatting_area_request, opts = {}) ⇒ Object

Remove cell area from conditional formatting.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1398

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

#delete_worksheet_conditional_formattings(delete_worksheet_conditional_formattings_request, opts = {}) ⇒ Object

Clear all conditional formattings in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1382

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

#delete_worksheet_date_filter(delete_worksheet_date_filter_request, opts = {}) ⇒ Object

Remove a date filter in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 710

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_worksheet_filter(delete_worksheet_filter_request, opts = {}) ⇒ Object

Delete a filter for a column in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 718

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

#delete_worksheet_freeze_panes(delete_worksheet_freeze_panes_request, opts = {}) ⇒ Object

Unfreeze panes in worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3216

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

#delete_worksheet_from_spreadsheet(delete_worksheet_from_spreadsheet_request, opts = {}) ⇒ Object

The Web API endpoint allows users to delete a specified worksheet from a workbook. This function provides a straightforward way to manage workbook structure by removing unnecessary or redundant worksheets.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 325

def delete_worksheet_from_spreadsheet( delete_worksheet_from_spreadsheet_request, opts = {})

   data, _status_code, _headers = delete_worksheet_from_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#delete_worksheet_hyperlink(delete_worksheet_hyperlink_request, opts = {}) ⇒ Object

Delete hyperlink by index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1652

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

#delete_worksheet_hyperlinks(delete_worksheet_hyperlinks_request, opts = {}) ⇒ Object

Delete all hyperlinks in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1676

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

#delete_worksheet_list_object(delete_worksheet_list_object_request, opts = {}) ⇒ Object

Delete list object by index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1836

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

#delete_worksheet_list_objects(delete_worksheet_list_objects_request, opts = {}) ⇒ Object

Delete ListObjects in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1828

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_worksheet_ole_object(delete_worksheet_ole_object_request, opts = {}) ⇒ Object

Delete an OLE object in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1932

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

#delete_worksheet_ole_objects(delete_worksheet_ole_objects_request, opts = {}) ⇒ Object

Delete all OLE objects in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1924

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_worksheet_picture(delete_worksheet_picture_request, opts = {}) ⇒ Object

Delete a picture object by index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2148

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_worksheet_pictures(delete_worksheet_pictures_request, opts = {}) ⇒ Object

Delete all pictures in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2156

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

#delete_worksheet_pivot_table(delete_worksheet_pivot_table_request, opts = {}) ⇒ Object

Delete PivotTable by index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2300

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_worksheet_pivot_table_filter(delete_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object

Delete a pivot filter in the PivotTable.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2324

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

#delete_worksheet_pivot_table_filters(delete_worksheet_pivot_table_filters_request, opts = {}) ⇒ Object

Delete all pivot filters in the PivotTable.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2316

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_worksheet_pivot_tables(delete_worksheet_pivot_tables_request, opts = {}) ⇒ Object

Delete PivotTables in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2292

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_worksheet_row(delete_worksheet_row_request, opts = {}) ⇒ Object

Delete a row in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1014

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_worksheet_rows(delete_worksheet_rows_request, opts = {}) ⇒ Object

Delete several rows in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1022

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

#delete_worksheet_shape(delete_worksheet_shape_request, opts = {}) ⇒ Object

Delete a shape in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2595

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

#delete_worksheet_shapes(delete_worksheet_shapes_request, opts = {}) ⇒ Object

Delete all shapes in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2587

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_worksheet_sparkline_group(delete_worksheet_sparkline_group_request, opts = {}) ⇒ Object

Delete a sparkline group in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2651

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

#delete_worksheet_sparkline_groups(delete_worksheet_sparkline_groups_request, opts = {}) ⇒ Object

Delete sparkline groups in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2643

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_validation(delete_worksheet_validation_request, opts = {}) ⇒ Object

Delete a validation by index in worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3312

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_worksheet_validations(delete_worksheet_validations_request, opts = {}) ⇒ Object

Delete all validations in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3320

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

#delete_worksheets(delete_worksheets_request, opts = {}) ⇒ Object

Delete matched worksheets in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3024

def delete_worksheets( delete_worksheets_request, opts = {})

   data, _status_code, _headers = delete_worksheets_request.create_http_request(@api_client,opts )
   return data
end

#download_file(download_file_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 515

def download_file( download_file_request, opts = {})

   data, _status_code, _headers = download_file_request.create_http_request(@api_client,opts )
   return data
end

#export_chart_as_format(export_chart_as_format_request, opts = {}) ⇒ Object

Converts a chart of spreadsheet in cloud storage to the specified format.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 102

def export_chart_as_format( export_chart_as_format_request, opts = {})

   data, _status_code, _headers = export_chart_as_format_request.create_http_request(@api_client,opts )
   return data
end

#export_range_as_format(export_range_as_format_request, opts = {}) ⇒ Object

Converts the range of spreadsheet in cloud storage to the specified format.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 118

def export_range_as_format( export_range_as_format_request, opts = {})

   data, _status_code, _headers = export_range_as_format_request.create_http_request(@api_client,opts )
   return data
end

#export_spreadsheet_as_format(export_spreadsheet_as_format_request, opts = {}) ⇒ Object

Converts a spreadsheet in cloud storage to the specified format.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 86

def export_spreadsheet_as_format( export_spreadsheet_as_format_request, opts = {})

   data, _status_code, _headers = export_spreadsheet_as_format_request.create_http_request(@api_client,opts )
   return data
end

#export_table_as_format(export_table_as_format_request, opts = {}) ⇒ Object

Converts a table of spreadsheet in cloud storage to the specified format.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 110

def export_table_as_format( export_table_as_format_request, opts = {})

   data, _status_code, _headers = export_table_as_format_request.create_http_request(@api_client,opts )
   return data
end

#export_worksheet_as_format(export_worksheet_as_format_request, opts = {}) ⇒ Object

Converts a worksheet of spreadsheet in cloud storage to the specified format.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 94

def export_worksheet_as_format( export_worksheet_as_format_request, opts = {})

   data, _status_code, _headers = export_worksheet_as_format_request.create_http_request(@api_client,opts )
   return data
end

#get_all_styles(get_all_styles_request, opts = {}) ⇒ Object

Get all style in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2960

def get_all_styles( get_all_styles_request, opts = {})

   data, _status_code, _headers = get_all_styles_request.create_http_request(@api_client,opts )
   return data
end

#get_aspose_cells_cloud_status(get_aspose_cells_cloud_status_request, opts = {}) ⇒ Object

Check the Health Status of Aspose.Cells Cloud Service.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 70

def get_aspose_cells_cloud_status( get_aspose_cells_cloud_status_request, opts = {})

   data, _status_code, _headers = get_aspose_cells_cloud_status_request.create_http_request(@api_client,opts )
   return data
end

#get_cell_html_string(get_cell_html_string_request, opts = {}) ⇒ Object

Retrieve the HTML string containing data and specific formats in this cell.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 878

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

#get_cells_cloud_service_status(get_cells_cloud_service_status_request, opts = {}) ⇒ Object

Aspose.Cells Cloud service health status check.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1110

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

#get_cells_cloud_services_health_check(get_cells_cloud_services_health_check_request, opts = {}) ⇒ Object

Retrieve cell descriptions in a specified format.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1102

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

#get_chart_area(get_chart_area_request, opts = {}) ⇒ Object

Retrieve chart area description in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1118

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

#get_chart_area_border(get_chart_area_border_request, opts = {}) ⇒ Object

Retrieve chart area border description.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1134

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

#get_chart_area_fill_format(get_chart_area_fill_format_request, opts = {}) ⇒ Object

Retrieve chart area fill format description in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1126

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

#get_chart_category_axis(get_chart_category_axis_request, opts = {}) ⇒ Object

Retrieve descriptions of chart series axis in the chart.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1262

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

#get_chart_second_category_axis(get_chart_second_category_axis_request, opts = {}) ⇒ Object

Retrieve chart second category axis in the chart

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1278

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

#get_chart_second_value_axis(get_chart_second_value_axis_request, opts = {}) ⇒ Object

Retrieve chart second value axis in the chart.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1286

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

#get_chart_series_axis(get_chart_series_axis_request, opts = {}) ⇒ Object

Retrieve descriptions of chart seriesaxis in the chart.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1254

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

#get_chart_value_axis(get_chart_value_axis_request, opts = {}) ⇒ Object

Retrieve chart value axis in the chart.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1270

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

#get_disc_usage(get_disc_usage_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 599

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

#get_document_properties(get_document_properties_request, opts = {}) ⇒ Object

Retrieve descriptions of Excel file properties.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2332

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

#get_document_property(get_document_property_request, opts = {}) ⇒ Object

Get Excel property by name.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2348

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

#get_file_versions(get_file_versions_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 606

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

#get_files_list(get_files_list_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 550

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

#get_footer(get_footer_request, opts = {}) ⇒ Object

Retrieve page footer description in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2076

def get_footer( get_footer_request, opts = {})

   data, _status_code, _headers = get_footer_request.create_http_request(@api_client,opts )
   return data
end

#get_header(get_header_request, opts = {}) ⇒ Object

Retrieve page header description in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2060

def get_header( get_header_request, opts = {})

   data, _status_code, _headers = get_header_request.create_http_request(@api_client,opts )
   return data
end

#get_horizontal_page_break(get_horizontal_page_break_request, opts = {}) ⇒ Object

Retrieve a horizontal page break descripton in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1980

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

#get_horizontal_page_breaks(get_horizontal_page_breaks_request, opts = {}) ⇒ Object

Retrieve descriptions of horizontal page breaks in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1964

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

#get_metadata(get_metadata_request, opts = {}) ⇒ Object

Get cells document properties.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1788

def get_metadata( get_metadata_request, opts = {})

   data, _status_code, _headers = get_metadata_request.create_http_request(@api_client,opts )
   return data
end

#get_named_range_value(get_named_range_value_request, opts = {}) ⇒ Object

Retrieve values in range.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3256

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

#get_named_ranges(get_named_ranges_request, opts = {}) ⇒ Object

Retrieve descriptions of ranges in the worksheets.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3248

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_page_count(get_page_count_request, opts = {}) ⇒ Object

Get page count in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2952

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_page_setup(get_page_setup_request, opts = {}) ⇒ Object

Retrieve page setup description in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2036

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

#get_pivot_table_field(get_pivot_table_field_request, opts = {}) ⇒ Object

Retrieve descriptions of pivot fields in the PivotTable.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2180

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

#get_public_key(get_public_key_request, opts = {}) ⇒ Object

Get an asymmetric public key.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 301

def get_public_key( get_public_key_request, opts = {})

   data, _status_code, _headers = get_public_key_request.create_http_request(@api_client,opts )
   return data
end

#get_vertical_page_break(get_vertical_page_break_request, opts = {}) ⇒ Object

Retrieve a vertical page break description in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1972

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

#get_vertical_page_breaks(get_vertical_page_breaks_request, opts = {}) ⇒ Object

Retrieve descriptions of vertical page breaks in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1956

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_workbook(get_workbook_request, opts = {}) ⇒ Object

Retrieve workbooks in various formats.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1406

def get_workbook( get_workbook_request, opts = {})

   data, _status_code, _headers = get_workbook_request.create_http_request(@api_client,opts )
   return data
end

#get_workbook_default_style(get_workbook_default_style_request, opts = {}) ⇒ Object

Retrieve the description of the default style for the workbook .

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2768

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_name(get_workbook_name_request, opts = {}) ⇒ Object

Retrieve description of a named range in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2800

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

#get_workbook_name_value(get_workbook_name_value_request, opts = {}) ⇒ Object

Retrieve the value of a named range in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2816

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

#get_workbook_names(get_workbook_names_request, opts = {}) ⇒ Object

Retrieve named ranges in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2784

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

#get_workbook_settings(get_workbook_settings_request, opts = {}) ⇒ Object

Retrieve descriptions of workbook settings.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2912

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

#get_workbook_text_items(get_workbook_text_items_request, opts = {}) ⇒ Object

Retrieve text items in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2776

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_worksheet_auto_filter(get_worksheet_auto_filter_request, opts = {}) ⇒ Object

Retrieve the description of auto filters from a worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 622

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

#get_worksheet_autoshape_with_format(get_worksheet_autoshape_with_format_request, opts = {}) ⇒ Object

Get autoshape description in some format.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 734

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

#get_worksheet_autoshapes(get_worksheet_autoshapes_request, opts = {}) ⇒ Object

Get autoshapes description in worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 726

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_worksheet_calculate_formula(get_worksheet_calculate_formula_request, opts = {}) ⇒ Object

Calculate formula in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3128

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

#get_worksheet_cell(get_worksheet_cell_request, opts = {}) ⇒ Object

Retrieve cell data using either cell reference or method name in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 830

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

#get_worksheet_cell_style(get_worksheet_cell_style_request, opts = {}) ⇒ Object

Retrieve cell style descriptions in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 838

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

#get_worksheet_cells(get_worksheet_cells_request, opts = {}) ⇒ Object

Retrieve cell descriptions in a specified format.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 822

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

#get_worksheet_cells_range_value(get_worksheet_cells_range_value_request, opts = {}) ⇒ Object

Retrieve the values of cells within the specified range.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2484

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

#get_worksheet_chart(get_worksheet_chart_request, opts = {}) ⇒ Object

Retrieve the chart in a specified format.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1150

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

#get_worksheet_chart_legend(get_worksheet_chart_legend_request, opts = {}) ⇒ Object

Retrieve chart legend description in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1182

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

#get_worksheet_chart_title(get_worksheet_chart_title_request, opts = {}) ⇒ Object

Retrieve chart title description in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1222

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

#get_worksheet_charts(get_worksheet_charts_request, opts = {}) ⇒ Object

Retrieve descriptions of charts in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1142

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

#get_worksheet_column(get_worksheet_column_request, opts = {}) ⇒ Object

Retrieve worksheet column data by column index.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 926

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

#get_worksheet_columns(get_worksheet_columns_request, opts = {}) ⇒ Object

Retrieve descriptions of worksheet columns.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 910

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

#get_worksheet_comment(get_worksheet_comment_request, opts = {}) ⇒ Object

Retrieve the description of comment in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3072

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

#get_worksheet_comments(get_worksheet_comments_request, opts = {}) ⇒ Object

Retrieve the description of comments in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3064

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

#get_worksheet_conditional_formatting(get_worksheet_conditional_formatting_request, opts = {}) ⇒ Object

Retrieve conditional formatting descriptions in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1342

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

#get_worksheet_conditional_formattings(get_worksheet_conditional_formattings_request, opts = {}) ⇒ Object

Retrieve descriptions of conditional formattings in a worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1334

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

#get_worksheet_hyperlink(get_worksheet_hyperlink_request, opts = {}) ⇒ Object

Retrieve hyperlink description by index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1644

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

#get_worksheet_hyperlinks(get_worksheet_hyperlinks_request, opts = {}) ⇒ Object

Retrieve descriptions of hyperlinks in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1636

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

#get_worksheet_list_object(get_worksheet_list_object_request, opts = {}) ⇒ Object

Retrieve list object description by index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1812

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

#get_worksheet_list_objects(get_worksheet_list_objects_request, opts = {}) ⇒ Object

Retrieve descriptions of ListObjects in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1804

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

#get_worksheet_merged_cell(get_worksheet_merged_cell_request, opts = {}) ⇒ Object

Retrieve description of a merged cell by its index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3120

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

#get_worksheet_merged_cells(get_worksheet_merged_cells_request, opts = {}) ⇒ Object

Get worksheet merged cells.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3112

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

#get_worksheet_ole_object(get_worksheet_ole_object_request, opts = {}) ⇒ Object

Retrieve the OLE object in a specified format in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1916

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

#get_worksheet_ole_objects(get_worksheet_ole_objects_request, opts = {}) ⇒ Object

Retrieve descriptions of OLE objects in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1908

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

#get_worksheet_page_count(get_worksheet_page_count_request, opts = {}) ⇒ Object

Get page count in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3272

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_worksheet_picture_with_format(get_worksheet_picture_with_format_request, opts = {}) ⇒ Object

Retrieve a picture by number in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2116

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

#get_worksheet_pictures(get_worksheet_pictures_request, opts = {}) ⇒ Object

Retrieve descriptions of pictures in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2108

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

#get_worksheet_pivot_table(get_worksheet_pivot_table_request, opts = {}) ⇒ Object

Retrieve PivotTable information by index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2172

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

#get_worksheet_pivot_table_filter(get_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object

Retrieve PivotTable filters in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2196

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

#get_worksheet_pivot_table_filters(get_worksheet_pivot_table_filters_request, opts = {}) ⇒ Object

Gets PivotTable filters in worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2188

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

#get_worksheet_pivot_tables(get_worksheet_pivot_tables_request, opts = {}) ⇒ Object

Retrieve descriptions of pivottables in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2164

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

#get_worksheet_row(get_worksheet_row_request, opts = {}) ⇒ Object

Retrieve row data by the row’s index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1006

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

#get_worksheet_rows(get_worksheet_rows_request, opts = {}) ⇒ Object

Retrieve descriptions of rows in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 998

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

#get_worksheet_shape(get_worksheet_shape_request, opts = {}) ⇒ Object

Retrieve description of shape in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2571

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

#get_worksheet_shapes(get_worksheet_shapes_request, opts = {}) ⇒ Object

Retrieve descriptions of shapes in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2563

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

#get_worksheet_sparkline_group(get_worksheet_sparkline_group_request, opts = {}) ⇒ Object

Retrieve description of a sparkline group in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2635

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

#get_worksheet_sparkline_groups(get_worksheet_sparkline_groups_request, opts = {}) ⇒ Object

Retrieve descriptions of sparkline groups in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2627

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_text_items(get_worksheet_text_items_request, opts = {}) ⇒ Object

Retrieve text items in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3056

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_worksheet_validation(get_worksheet_validation_request, opts = {}) ⇒ Object

Retrieve a validation by its index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3288

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

#get_worksheet_validations(get_worksheet_validations_request, opts = {}) ⇒ Object

Retrieve descriptions of validations in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3280

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

#get_worksheet_with_format(get_worksheet_with_format_request, opts = {}) ⇒ Object

Retrieve the worksheet in a specified format from the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2976

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

#get_worksheets(get_worksheets_request, opts = {}) ⇒ Object

Retrieve the description of worksheets from a workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2968

def get_worksheets( get_worksheets_request, opts = {})

   data, _status_code, _headers = get_worksheets_request.create_http_request(@api_client,opts )
   return data
end

#import_data_into_spreadsheet(import_data_into_spreadsheet_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 293

def import_data_into_spreadsheet( import_data_into_spreadsheet_request, opts = {})

   data, _status_code, _headers = import_data_into_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#math_calculate(math_calculate_request, opts = {}) ⇒ Object

The Math Calculate API enables you to perform a variety of mathematical operations on a selected range of cells. You can add or subtract a specific number from all selected cells, as well as multiply or divide individual cells and entire columns. This API simplifies complex calculations and enhances data manipulation capabilities.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 53

def math_calculate( math_calculate_request, opts = {})

   data, _status_code, _headers = math_calculate_request.create_http_request(@api_client,opts )
   return data
end

#merge_remote_spreadsheet(merge_remote_spreadsheet_request, opts = {}) ⇒ Object

Merge a spreadsheet file into other spreadsheet in cloud storage, and output a specified format file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 270

def merge_remote_spreadsheet( merge_remote_spreadsheet_request, opts = {})

   data, _status_code, _headers = merge_remote_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#merge_spreadsheets(merge_spreadsheets_request, opts = {}) ⇒ Object

Merge local spreadsheet files into a specified format file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 254

def merge_spreadsheets( merge_spreadsheets_request, opts = {})

   data, _status_code, _headers = merge_spreadsheets_request.create_http_request(@api_client,opts )
   return data
end

#merge_spreadsheets_in_remote_folder(merge_spreadsheets_in_remote_folder_request, opts = {}) ⇒ Object

Merge spreadsheet files in folder of cloud storage into a specified format file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 262

def merge_spreadsheets_in_remote_folder( merge_spreadsheets_in_remote_folder_request, opts = {})

   data, _status_code, _headers = merge_spreadsheets_in_remote_folder_request.create_http_request(@api_client,opts )
   return data
end

#move_file(move_file_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 536

def move_file( move_file_request, opts = {})

   data, _status_code, _headers = move_file_request.create_http_request(@api_client,opts )
   return data
end

#move_folder(move_folder_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 571

def move_folder( move_folder_request, opts = {})

   data, _status_code, _headers = move_folder_request.create_http_request(@api_client,opts )
   return data
end

#move_worksheet_in_spreadsheet(move_worksheet_in_spreadsheet_request, opts = {}) ⇒ Object

The Web API endpoint allows users to move a specified worksheet within a workbook. This function provides a straightforward way to move a worksheet, enhancing workbook organization.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 341

def move_worksheet_in_spreadsheet( move_worksheet_in_spreadsheet_request, opts = {})

   data, _status_code, _headers = move_worksheet_in_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#object_exists(object_exists_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 592

def object_exists( object_exists_request, opts = {})

   data, _status_code, _headers = object_exists_request.create_http_request(@api_client,opts )
   return data
end

#post_access_token(post_access_token_request, opts = {}) ⇒ Object

Get Access Token Result: The Cells Cloud Get Token API acts as a proxy service, forwarding user requests to the Aspose Cloud authentication server and returning the resulting access token to the client.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 62

def post_access_token( post_access_token_request, opts = {})

   data, _status_code, _headers = post_access_token_request.create_http_request(@api_client,opts )
   return data
end

#post_add_text_content(post_add_text_content_request, opts = {}) ⇒ Object

Adds text content to a specified location within a document. It requires an object that defines the text to be added and the insertion location.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2704

def post_add_text_content( post_add_text_content_request, opts = {})

   data, _status_code, _headers = post_add_text_content_request.create_http_request(@api_client,opts )
   return data
end

#post_analyze_excel(post_analyze_excel_request, opts = {}) ⇒ Object

Perform business analysis of data in Excel files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 614

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

#post_assemble(post_assemble_request, opts = {}) ⇒ Object

Assemble data files with template files to generate files in various formats.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1684

def post_assemble( post_assemble_request, opts = {})

   data, _status_code, _headers = post_assemble_request.create_http_request(@api_client,opts )
   return data
end

#post_autofit_workbook_columns(post_autofit_workbook_columns_request, opts = {}) ⇒ Object

Autofit columns in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2904

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

#post_autofit_workbook_rows(post_autofit_workbook_rows_request, opts = {}) ⇒ Object

Autofit rows in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2896

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

#post_autofit_worksheet_columns(post_autofit_worksheet_columns_request, opts = {}) ⇒ Object

Autofit columns in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3184

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

#post_autofit_worksheet_row(post_autofit_worksheet_row_request, opts = {}) ⇒ Object

Autofit a row in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3168

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

#post_autofit_worksheet_rows(post_autofit_worksheet_rows_request, opts = {}) ⇒ Object

Autofit rows in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3176

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

#post_batch_convert(post_batch_convert_request, opts = {}) ⇒ Object

Batch converting files that meet specific matching conditions.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 742

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

#post_batch_lock(post_batch_lock_request, opts = {}) ⇒ Object

Batch locking files that meet specific matching conditions.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 758

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

#post_batch_protect(post_batch_protect_request, opts = {}) ⇒ Object

Batch protecting files that meet specific matching conditions.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 750

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

#post_batch_split(post_batch_split_request, opts = {}) ⇒ Object

Batch splitting files that meet specific matching conditions.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 774

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

#post_batch_unlock(post_batch_unlock_request, opts = {}) ⇒ Object

Batch unlocking files that meet specific matching conditions.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 766

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

#post_cell_calculate(post_cell_calculate_request, opts = {}) ⇒ Object

Calculate cell formula in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 894

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

#post_cell_characters(post_cell_characters_request, opts = {}) ⇒ Object

Set cell characters in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 902

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

#post_character_count(post_character_count_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2674

def post_character_count( post_character_count_request, opts = {})

   data, _status_code, _headers = post_character_count_request.create_http_request(@api_client,opts )
   return data
end

#post_chart_category_axis(post_chart_category_axis_request, opts = {}) ⇒ Object

Update chart category axis in the chart.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1302

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

#post_chart_second_category_axis(post_chart_second_category_axis_request, opts = {}) ⇒ Object

Update chart sencond category axis in the chart.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1318

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

#post_chart_second_value_axis(post_chart_second_value_axis_request, opts = {}) ⇒ Object

Update chart sencond value axis in the chart.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1326

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

#post_chart_series_axis(post_chart_series_axis_request, opts = {}) ⇒ Object

Update chart series axis in the chart.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1294

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

#post_chart_value_axis(post_chart_value_axis_request, opts = {}) ⇒ Object

Update chart value axis in the chart.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1310

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

#post_clear_contents(post_clear_contents_request, opts = {}) ⇒ Object

Clear cell area contents in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 782

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

#post_clear_formats(post_clear_formats_request, opts = {}) ⇒ Object

Clear cell formats in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 790

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

#post_clear_objects(post_clear_objects_request, opts = {}) ⇒ Object

Clear internal elements in Excel files and generate output files in various formats.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1748

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

#post_column_style(post_column_style_request, opts = {}) ⇒ Object

Set column style in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 990

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

#post_compress(post_compress_request, opts = {}) ⇒ Object

Compress files and generate target files in various formats, supported file formats are include Xls, Xlsx, Xlsm, Xlsb, Ods and more.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1692

def post_compress( post_compress_request, opts = {})

   data, _status_code, _headers = post_compress_request.create_http_request(@api_client,opts )
   return data
end

#post_convert_text(post_convert_text_request, opts = {}) ⇒ Object

Enhance Excel data through essential text conversions: convert text to numbers, replace characters and line breaks, and remove accents.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2736

def post_convert_text( post_convert_text_request, opts = {})

   data, _status_code, _headers = post_convert_text_request.create_http_request(@api_client,opts )
   return data
end

#post_convert_workbook(post_convert_workbook_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1508

def post_convert_workbook( post_convert_workbook_request, opts = {})

   data, _status_code, _headers = post_convert_workbook_request.create_http_request(@api_client,opts )
   return data
end

#post_convert_workbook_to_csv(post_convert_workbook_to_csv_request, opts = {}) ⇒ Object

Convert Excel file to Csv files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1494

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

#post_convert_workbook_to_docx(post_convert_workbook_to_docx_request, opts = {}) ⇒ Object

Convert Excel file to Docx files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1446

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

#post_convert_workbook_to_html(post_convert_workbook_to_html_request, opts = {}) ⇒ Object

Convert Excel file to HTML files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1462

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

#post_convert_workbook_to_json(post_convert_workbook_to_json_request, opts = {}) ⇒ Object

Convert Excel file to Json files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1478

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

#post_convert_workbook_to_markdown(post_convert_workbook_to_markdown_request, opts = {}) ⇒ Object

Convert Excel file to Markdown files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1470

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

#post_convert_workbook_to_pdf(post_convert_workbook_to_pdf_request, opts = {}) ⇒ Object

Convert Excel file to PDF files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1430

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

#post_convert_workbook_to_png(post_convert_workbook_to_png_request, opts = {}) ⇒ Object

Convert Excel file to PNG files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1438

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

#post_convert_workbook_to_pptx(post_convert_workbook_to_pptx_request, opts = {}) ⇒ Object

Convert Excel file to Pptx files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1454

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

#post_convert_workbook_to_sql(post_convert_workbook_to_sql_request, opts = {}) ⇒ Object

Convert Excel file to SQL Script files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1486

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

#post_convert_worksheet_to_image(post_convert_worksheet_to_image_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1501

def post_convert_worksheet_to_image( post_convert_worksheet_to_image_request, opts = {})

   data, _status_code, _headers = post_convert_worksheet_to_image_request.create_http_request(@api_client,opts )
   return data
end

#post_copy_cell_into_cell(post_copy_cell_into_cell_request, opts = {}) ⇒ Object

Copy data from a source cell to a destination cell in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 870

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

#post_copy_worksheet(post_copy_worksheet_request, opts = {}) ⇒ Object

Copy contents and formats from another worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3224

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

#post_copy_worksheet_columns(post_copy_worksheet_columns_request, opts = {}) ⇒ Object

Copy data from source columns to destination columns in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 982

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

#post_copy_worksheet_rows(post_copy_worksheet_rows_request, opts = {}) ⇒ Object

Copy data and formats from specific entire rows in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1086

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

#post_data_cleansing(post_data_cleansing_request, opts = {}) ⇒ Object

Data cleansing of spreadsheet files is a data management process used to identify, correct, and remove errors, incompleteness, duplicates, or inaccuracies in tables and ranges.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1580

def post_data_cleansing( post_data_cleansing_request, opts = {})

   data, _status_code, _headers = post_data_cleansing_request.create_http_request(@api_client,opts )
   return data
end

#post_data_deduplication(post_data_deduplication_request, opts = {}) ⇒ Object

Data deduplication of spreadsheet files is mainly used to eliminate duplicate data in tables and ranges.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1596

def post_data_deduplication( post_data_deduplication_request, opts = {})

   data, _status_code, _headers = post_data_deduplication_request.create_http_request(@api_client,opts )
   return data
end

#post_data_fill(post_data_fill_request, opts = {}) ⇒ Object

Data filling for spreadsheet files is primarily used to fill empty data in tables and ranges.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1612

def post_data_fill( post_data_fill_request, opts = {})

   data, _status_code, _headers = post_data_fill_request.create_http_request(@api_client,opts )
   return data
end

#post_data_transformation(post_data_transformation_request, opts = {}) ⇒ Object

Transform spreadsheet data is mainly used to pivot columns, unpivot columns.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1628

def post_data_transformation( post_data_transformation_request, opts = {})

   data, _status_code, _headers = post_data_transformation_request.create_http_request(@api_client,opts )
   return data
end

#post_delete_incomplete_rows(post_delete_incomplete_rows_request, opts = {}) ⇒ Object

Deleting incomplete rows of spreadsheet files is mainly used to eliminate incomplete rows in tables and ranges.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1620

def post_delete_incomplete_rows( post_delete_incomplete_rows_request, opts = {})

   data, _status_code, _headers = post_delete_incomplete_rows_request.create_http_request(@api_client,opts )
   return data
end

#post_digital_signature(post_digital_signature_request, opts = {}) ⇒ Object

Excel file digital signature.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2372

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

#post_encrypt_workbook(post_encrypt_workbook_request, opts = {}) ⇒ Object

Excel Encryption.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2380

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

#post_export(post_export_request, opts = {}) ⇒ Object

Export Excel internal elements or the workbook itself to various format files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1531

def post_export( post_export_request, opts = {})

   data, _status_code, _headers = post_export_request.create_http_request(@api_client,opts )
   return data
end

#post_extract_text(post_extract_text_request, opts = {}) ⇒ Object

Effortlessly extract text and numbers from Excel cells with precise options. This API allows extraction of first/last characters, text between delimiters, and numbers from strings, with output as static values or formulas.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2752

def post_extract_text( post_extract_text_request, opts = {})

   data, _status_code, _headers = post_extract_text_request.create_http_request(@api_client,opts )
   return data
end

#post_fit_tall_to_pages(post_fit_tall_to_pages_request, opts = {}) ⇒ Object

Set the scale at which the page will fit tall when printed on the sheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2100

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

#post_fit_wide_to_pages(post_fit_wide_to_pages_request, opts = {}) ⇒ Object

Set the scale at which the page will fit wide when printed on the sheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2092

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

#post_footer(post_footer_request, opts = {}) ⇒ Object

Update page footer in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2084

def post_footer( post_footer_request, opts = {})

   data, _status_code, _headers = post_footer_request.create_http_request(@api_client,opts )
   return data
end

#post_group_worksheet_columns(post_group_worksheet_columns_request, opts = {}) ⇒ Object

Group worksheet columns in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 966

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

#post_group_worksheet_rows(post_group_worksheet_rows_request, opts = {}) ⇒ Object

Group rows in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1070

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

#post_header(post_header_request, opts = {}) ⇒ Object

Update page header in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2068

def post_header( post_header_request, opts = {})

   data, _status_code, _headers = post_header_request.create_http_request(@api_client,opts )
   return data
end

#post_hide_worksheet_columns(post_hide_worksheet_columns_request, opts = {}) ⇒ Object

Hide worksheet columns in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 950

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

#post_hide_worksheet_rows(post_hide_worksheet_rows_request, opts = {}) ⇒ Object

Hide rows in worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1054

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

#post_import(post_import_request, opts = {}) ⇒ Object

Import data into an Excel file and generate output files in various formats.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1732

def post_import( post_import_request, opts = {})

   data, _status_code, _headers = post_import_request.create_http_request(@api_client,opts )
   return data
end

#post_import_data(post_import_data_request, opts = {}) ⇒ Object

Import data into the Excel file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1564

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

#post_lock(post_lock_request, opts = {}) ⇒ Object

Lock Excel files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2436

def post_lock( post_lock_request, opts = {})

   data, _status_code, _headers = post_lock_request.create_http_request(@api_client,opts )
   return data
end

#post_merge(post_merge_request, opts = {}) ⇒ Object

Merge cells in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1700

def post_merge( post_merge_request, opts = {})

   data, _status_code, _headers = post_merge_request.create_http_request(@api_client,opts )
   return data
end

#post_metadata(post_metadata_request, opts = {}) ⇒ Object

Update document properties in Excel file, and save them is various formats.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1780

def post_metadata( post_metadata_request, opts = {})

   data, _status_code, _headers = post_metadata_request.create_http_request(@api_client,opts )
   return data
end

#post_move_worksheet(post_move_worksheet_request, opts = {}) ⇒ Object

Move worksheet in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3032

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

#post_page_setup(post_page_setup_request, opts = {}) ⇒ Object

Update page setup in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2044

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

#post_pivot_table_cell_style(post_pivot_table_cell_style_request, opts = {}) ⇒ Object

Update cell style in the PivotTable.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2244

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

#post_pivot_table_field_hide_item(post_pivot_table_field_hide_item_request, opts = {}) ⇒ Object

Hide a pivot field item in the PivotTable.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2228

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

#post_pivot_table_field_move_to(post_pivot_table_field_move_to_request, opts = {}) ⇒ Object

Move a pivot field in the PivotTable.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2236

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

#post_pivot_table_style(post_pivot_table_style_request, opts = {}) ⇒ Object

Update style in the PivotTable.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2252

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

#post_pivot_table_update_pivot_field(post_pivot_table_update_pivot_field_request, opts = {}) ⇒ Object

Update pivot field in the PivotTable.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2268

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

#post_pivot_table_update_pivot_fields(post_pivot_table_update_pivot_fields_request, opts = {}) ⇒ Object

Update pivot fields in the PivotTable.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2260

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

#post_protect(post_protect_request, opts = {}) ⇒ Object

Excel files encryption.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2444

def post_protect( post_protect_request, opts = {})

   data, _status_code, _headers = post_protect_request.create_http_request(@api_client,opts )
   return data
end

#post_protect_workbook(post_protect_workbook_request, opts = {}) ⇒ Object

Excel protection.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2396

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

#post_remove_characters(post_remove_characters_request, opts = {}) ⇒ Object

A comprehensive set of tools for cleaning text content within selected cells. It allows users to remove specific characters, character sets, and substrings, ensuring that the text is standardized and free from unwanted symbols or sequences.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2728

def post_remove_characters( post_remove_characters_request, opts = {})

   data, _status_code, _headers = post_remove_characters_request.create_http_request(@api_client,opts )
   return data
end

#post_remove_duplicates(post_remove_duplicates_request, opts = {}) ⇒ Object

Efficiently remove duplicate substrings from Excel cells. Select a range, specify delimiters, and apply options to eliminate repeated text segments.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2744

def post_remove_duplicates( post_remove_duplicates_request, opts = {})

   data, _status_code, _headers = post_remove_duplicates_request.create_http_request(@api_client,opts )
   return data
end

#post_rename_worksheet(post_rename_worksheet_request, opts = {}) ⇒ Object

Rename worksheet in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3232

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

#post_repair(post_repair_request, opts = {}) ⇒ Object

Repair abnormal files and generate files in various formats.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1764

def post_repair( post_repair_request, opts = {})

   data, _status_code, _headers = post_repair_request.create_http_request(@api_client,opts )
   return data
end

#post_replace(post_replace_request, opts = {}) ⇒ Object

Replace specified text with new text in Excel files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1724

def post_replace( post_replace_request, opts = {})

   data, _status_code, _headers = post_replace_request.create_http_request(@api_client,opts )
   return data
end

#post_reverse(post_reverse_request, opts = {}) ⇒ Object

Reverse rows or columns in Excel files and create output files in various formats.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1756

def post_reverse( post_reverse_request, opts = {})

   data, _status_code, _headers = post_reverse_request.create_http_request(@api_client,opts )
   return data
end

#post_rotate(post_rotate_request, opts = {}) ⇒ Object

Rotate rows, columns, or other objects in Excel files and save them in various formats.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1772

def post_rotate( post_rotate_request, opts = {})

   data, _status_code, _headers = post_rotate_request.create_http_request(@api_client,opts )
   return data
end

#post_row_style(post_row_style_request, opts = {}) ⇒ Object

Apply formats to an entire row in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1094

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

#post_run_task(post_run_task_request, opts = {}) ⇒ Object

Run tasks.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2696

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

#post_search(post_search_request, opts = {}) ⇒ Object

Search for specified text within Excel files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1716

def post_search( post_search_request, opts = {})

   data, _status_code, _headers = post_search_request.create_http_request(@api_client,opts )
   return data
end

#post_set_cell_html_string(post_set_cell_html_string_request, opts = {}) ⇒ Object

Set the HTML string containing data and specific formats in this cell.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 886

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

#post_set_cell_range_value(post_set_cell_range_value_request, opts = {}) ⇒ Object

Set the value of the range in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 862

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

#post_set_worksheet_column_width(post_set_worksheet_column_width_request, opts = {}) ⇒ Object

Set worksheet column width.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 918

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

#post_specify_words_count(post_specify_words_count_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2688

def post_specify_words_count( post_specify_words_count_request, opts = {})

   data, _status_code, _headers = post_specify_words_count_request.create_http_request(@api_client,opts )
   return data
end

#post_split(post_split_request, opts = {}) ⇒ Object

Split Excel spreadsheet files based on worksheets and create output files in various formats.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1708

def post_split( post_split_request, opts = {})

   data, _status_code, _headers = post_split_request.create_http_request(@api_client,opts )
   return data
end

#post_split_text(post_split_text_request, opts = {}) ⇒ Object

Efficiently divides Excel cell content into columns or rows based on specified delimiters or patterns. Supports Character-based splitting, Custom string splitting, Mask and wildcard splitting for pattern-based division, Line break division, Column or row splitting, Delimiter removal or retention.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2760

def post_split_text( post_split_text_request, opts = {})

   data, _status_code, _headers = post_split_text_request.create_http_request(@api_client,opts )
   return data
end

#post_trim_content(post_trim_content_request, opts = {}) ⇒ Object

The PostTrimContent API is designed to process and trim content within a specified range in a spreadsheet. This API allows users to remove extra spaces, line breaks, or other unnecessary characters from the content of selected cells. It is particularly useful for cleaning up data entries and ensuring consistency in spreadsheet formatting

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2712

def post_trim_content( post_trim_content_request, opts = {})

   data, _status_code, _headers = post_trim_content_request.create_http_request(@api_client,opts )
   return data
end

#post_ungroup_worksheet_columns(post_ungroup_worksheet_columns_request, opts = {}) ⇒ Object

Ungroup worksheet columns.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 974

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

#post_ungroup_worksheet_rows(post_ungroup_worksheet_rows_request, opts = {}) ⇒ Object

Ungroup rows in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1078

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

#post_unhide_worksheet_columns(post_unhide_worksheet_columns_request, opts = {}) ⇒ Object

Unhide worksheet columns in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 958

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

#post_unhide_worksheet_rows(post_unhide_worksheet_rows_request, opts = {}) ⇒ Object

Unhide rows in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1062

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

#post_unlock(post_unlock_request, opts = {}) ⇒ Object

Unlock Excel files.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2428

def post_unlock( post_unlock_request, opts = {})

   data, _status_code, _headers = post_unlock_request.create_http_request(@api_client,opts )
   return data
end

#post_update_word_case(post_update_word_case_request, opts = {}) ⇒ Object

Managing inconsistent text case in spreadsheets (Excel, Google Sheets, CSV) can be frustrating, especially with large datasets. The PostUpdateWordCase WEB API solves this by automating text case conversions, ensuring clean and standardized data.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2720

def post_update_word_case( post_update_word_case_request, opts = {})

   data, _status_code, _headers = post_update_word_case_request.create_http_request(@api_client,opts )
   return data
end

#post_update_worksheet_cell_style(post_update_worksheet_cell_style_request, opts = {}) ⇒ Object

Set cell style using cell name in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 854

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

#post_update_worksheet_ole_object(post_update_worksheet_ole_object_request, opts = {}) ⇒ Object

Update an OLE object in worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1940

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

#post_update_worksheet_property(post_update_worksheet_property_request, opts = {}) ⇒ Object

Update worksheet properties in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3240

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

#post_update_worksheet_range_style(post_update_worksheet_range_style_request, opts = {}) ⇒ Object

Update cell range styles in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 798

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

#post_update_worksheet_row(post_update_worksheet_row_request, opts = {}) ⇒ Object

Update height of rows in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1046

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

#post_update_worksheet_zoom(post_update_worksheet_zoom_request, opts = {}) ⇒ Object

Update the scaling percentage in the worksheet. It should be between 10 and 400.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3264

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

#post_watermark(post_watermark_request, opts = {}) ⇒ Object

Add Text Watermark to Excel files and generate output files in various formats.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1740

def post_watermark( post_watermark_request, opts = {})

   data, _status_code, _headers = post_watermark_request.create_http_request(@api_client,opts )
   return data
end

#post_words_count(post_words_count_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2681

def post_words_count( post_words_count_request, opts = {})

   data, _status_code, _headers = post_words_count_request.create_http_request(@api_client,opts )
   return data
end

#post_workbook_calculate_formula(post_workbook_calculate_formula_request, opts = {}) ⇒ Object

Calculate all formulas in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2888

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

#post_workbook_data_cleansing(post_workbook_data_cleansing_request, opts = {}) ⇒ Object

Data cleaning of spreadsheet files is a data management process used to identify, correct, and remove errors, incompleteness, duplicates, or inaccuracies in tables and ranges.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1572

def post_workbook_data_cleansing( post_workbook_data_cleansing_request, opts = {})

   data, _status_code, _headers = post_workbook_data_cleansing_request.create_http_request(@api_client,opts )
   return data
end

#post_workbook_data_deduplication(post_workbook_data_deduplication_request, opts = {}) ⇒ Object

Data deduplication of spreadsheet files is mainly used to eliminate duplicate data in tables and ranges.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1588

def post_workbook_data_deduplication( post_workbook_data_deduplication_request, opts = {})

   data, _status_code, _headers = post_workbook_data_deduplication_request.create_http_request(@api_client,opts )
   return data
end

#post_workbook_data_fill(post_workbook_data_fill_request, opts = {}) ⇒ Object

Data filling for spreadsheet files is primarily used to fill empty data in tables and ranges.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1604

def post_workbook_data_fill( post_workbook_data_fill_request, opts = {})

   data, _status_code, _headers = post_workbook_data_fill_request.create_http_request(@api_client,opts )
   return data
end

#post_workbook_export_xml(post_workbook_export_xml_request, opts = {}) ⇒ Object

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.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1540

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

#post_workbook_get_smart_marker_result(post_workbook_get_smart_marker_result_request, opts = {}) ⇒ Object

Smart marker processing.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2864

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

#post_workbook_import_json(post_workbook_import_json_request, opts = {}) ⇒ Object

Import a JSON data file into the workbook. The JSON data file can either be a cloud file or data from an HTTP URI.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1548

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

#post_workbook_import_xml(post_workbook_import_xml_request, opts = {}) ⇒ Object

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.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1556

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

#post_workbook_name(post_workbook_name_request, opts = {}) ⇒ Object

Update a named range in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2808

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

#post_workbook_save_as(post_workbook_save_as_request, opts = {}) ⇒ Object

Save an Excel file in various formats.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1422

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

#post_workbook_settings(post_workbook_settings_request, opts = {}) ⇒ Object

Update setting in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2920

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

#post_workbook_split(post_workbook_split_request, opts = {}) ⇒ Object

Split the workbook with a specific format.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2880

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

#post_workbook_text_replace(post_workbook_text_replace_request, opts = {}) ⇒ Object

Replace text in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2856

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

#post_workbooks_merge(post_workbooks_merge_request, opts = {}) ⇒ Object

Merge a workbook into the existing workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2840

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

#post_workbooks_text_search(post_workbooks_text_search_request, opts = {}) ⇒ Object

Search for text in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2848

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

#post_worksheet_auto_filter_refresh(post_worksheet_auto_filter_refresh_request, opts = {}) ⇒ Object

Refresh auto filters in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 702

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

#post_worksheet_calculate_formula(post_worksheet_calculate_formula_request, opts = {}) ⇒ Object

Calculate formula in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3136

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

#post_worksheet_cell_set_value(post_worksheet_cell_set_value_request, opts = {}) ⇒ Object

Set cell value using cell name in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 846

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

#post_worksheet_cells_range_column_width(post_worksheet_cells_range_column_width_request, opts = {}) ⇒ Object

Set the column width of the specified range.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2524

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

#post_worksheet_cells_range_merge(post_worksheet_cells_range_merge_request, opts = {}) ⇒ Object

Merge a range of cells into a single cell.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2460

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

#post_worksheet_cells_range_move_to(post_worksheet_cells_range_move_to_request, opts = {}) ⇒ Object

Move the current range to the destination range.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2500

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

#post_worksheet_cells_range_outline_border(post_worksheet_cells_range_outline_border_request, opts = {}) ⇒ Object

Apply an outline border around a range of cells.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2516

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

#post_worksheet_cells_range_row_height(post_worksheet_cells_range_row_height_request, opts = {}) ⇒ Object

Sets row height of range.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2532

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

#post_worksheet_cells_range_sort(post_worksheet_cells_range_sort_request, opts = {}) ⇒ Object

Perform data sorting around a range of cells.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2508

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

#post_worksheet_cells_range_style(post_worksheet_cells_range_style_request, opts = {}) ⇒ Object

Set the style for the specified range.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2476

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

#post_worksheet_cells_range_to_image(post_worksheet_cells_range_to_image_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2539

def post_worksheet_cells_range_to_image( post_worksheet_cells_range_to_image_request, opts = {})

   data, _status_code, _headers = post_worksheet_cells_range_to_image_request.create_http_request(@api_client,opts )
   return data
end

#post_worksheet_cells_range_un_merge(post_worksheet_cells_range_un_merge_request, opts = {}) ⇒ Object

Unmerge merged cells within this range.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2468

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

#post_worksheet_cells_range_value(post_worksheet_cells_range_value_request, opts = {}) ⇒ Object

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.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2492

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

#post_worksheet_cells_ranges_copy(post_worksheet_cells_ranges_copy_request, opts = {}) ⇒ Object

Copy content from the source range to the destination range in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2452

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

#post_worksheet_chart(post_worksheet_chart_request, opts = {}) ⇒ Object

Update chart properties in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1174

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

#post_worksheet_chart_legend(post_worksheet_chart_legend_request, opts = {}) ⇒ Object

Update chart legend in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1190

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

#post_worksheet_chart_title(post_worksheet_chart_title_request, opts = {}) ⇒ Object

Update chart title in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1230

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

#post_worksheet_comment(post_worksheet_comment_request, opts = {}) ⇒ Object

Update cell comment in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3088

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

#post_worksheet_group_shape(post_worksheet_group_shape_request, opts = {}) ⇒ Object

Group shapes in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2611

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

#post_worksheet_hyperlink(post_worksheet_hyperlink_request, opts = {}) ⇒ Object

Update hyperlink by index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1660

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

#post_worksheet_list_column(post_worksheet_list_column_request, opts = {}) ⇒ Object

Update list column in list object.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1892

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

#post_worksheet_list_columns_total(post_worksheet_list_columns_total_request, opts = {}) ⇒ Object

Update total of list columns in the table.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1900

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

#post_worksheet_list_object(post_worksheet_list_object_request, opts = {}) ⇒ Object

Update list object by index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1844

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

#post_worksheet_list_object_convert_to_range(post_worksheet_list_object_convert_to_range_request, opts = {}) ⇒ Object

Convert list object to range in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1852

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

#post_worksheet_list_object_insert_slicer(post_worksheet_list_object_insert_slicer_request, opts = {}) ⇒ Object

Insert slicer for list object.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1884

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

#post_worksheet_list_object_remove_duplicates(post_worksheet_list_object_remove_duplicates_request, opts = {}) ⇒ Object

Remove duplicates in list object.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1876

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

#post_worksheet_list_object_sort_table(post_worksheet_list_object_sort_table_request, opts = {}) ⇒ Object

Sort list object in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1868

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

#post_worksheet_list_object_summarize_with_pivot_table(post_worksheet_list_object_summarize_with_pivot_table_request, opts = {}) ⇒ Object

Create a pivot table with a list object in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1860

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

#post_worksheet_match_blanks(post_worksheet_match_blanks_request, opts = {}) ⇒ Object

Match all blank cells in the list.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 686

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

#post_worksheet_match_non_blanks(post_worksheet_match_non_blanks_request, opts = {}) ⇒ Object

Match all not blank cells in the list.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 694

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

#post_worksheet_merge(post_worksheet_merge_request, opts = {}) ⇒ Object

Merge cells in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 806

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

#post_worksheet_picture(post_worksheet_picture_request, opts = {}) ⇒ Object

Update a picture by index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2140

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

#post_worksheet_pivot_table_calculate(post_worksheet_pivot_table_calculate_request, opts = {}) ⇒ Object

Calculate pivottable’s data to cells.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2276

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

#post_worksheet_pivot_table_move(post_worksheet_pivot_table_move_request, opts = {}) ⇒ Object

Move PivotTable in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2284

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

#post_worksheet_range_sort(post_worksheet_range_sort_request, opts = {}) ⇒ Object

Sort a range in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3160

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

#post_worksheet_shape(post_worksheet_shape_request, opts = {}) ⇒ Object

Update a shape in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2603

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

#post_worksheet_sparkline_group(post_worksheet_sparkline_group_request, opts = {}) ⇒ Object

Update a sparkline group in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2667

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

#post_worksheet_text_replace(post_worksheet_text_replace_request, opts = {}) ⇒ Object

Replace old text with new text in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3152

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

#post_worksheet_text_search(post_worksheet_text_search_request, opts = {}) ⇒ Object

Search for text in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3144

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

#post_worksheet_ungroup_shape(post_worksheet_ungroup_shape_request, opts = {}) ⇒ Object

Ungroup shapes in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2619

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

#post_worksheet_unmerge(post_worksheet_unmerge_request, opts = {}) ⇒ Object

Unmerge cells in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 814

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

#post_worksheet_validation(post_worksheet_validation_request, opts = {}) ⇒ Object

Update a validation by index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3304

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

#protect_spreadsheet(protect_spreadsheet_request, opts = {}) ⇒ Object

Applies dual-layer password protection to Excel spreadsheets, supporting both open and modify passwords with encryption.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 357

def protect_spreadsheet( protect_spreadsheet_request, opts = {})

   data, _status_code, _headers = protect_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#put_active_worksheet(put_active_worksheet_request, opts = {}) ⇒ Object

Set active worksheet index in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2992

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

#put_add_new_worksheet(put_add_new_worksheet_request, opts = {}) ⇒ Object

Add a new worksheet in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3008

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

#put_change_visibility_worksheet(put_change_visibility_worksheet_request, opts = {}) ⇒ Object

Change worksheet visibility in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2984

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

#put_convert_workbook(put_convert_workbook_request, opts = {}) ⇒ Object

Convert the workbook from the requested content into files in different formats.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1414

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

#put_document_property(put_document_property_request, opts = {}) ⇒ Object

Set or add an Excel property.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2340

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

#put_document_protect_from_changes(put_document_protect_from_changes_request, opts = {}) ⇒ Object

Excel file write protection.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2412

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

#put_horizontal_page_break(put_horizontal_page_break_request, opts = {}) ⇒ Object

Add a horizontal page breaks in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1996

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

#put_insert_new_worksheet(put_insert_new_worksheet_request, opts = {}) ⇒ Object

Insert a new worksheet in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3000

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

#put_insert_worksheet_columns(put_insert_worksheet_columns_request, opts = {}) ⇒ Object

Insert worksheet columns in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 934

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

#put_insert_worksheet_row(put_insert_worksheet_row_request, opts = {}) ⇒ Object

Insert a new row in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1038

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

#put_insert_worksheet_rows(put_insert_worksheet_rows_request, opts = {}) ⇒ Object

Insert several new rows in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1030

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

#put_pivot_table_field(put_pivot_table_field_request, opts = {}) ⇒ Object

Add a pivot field in the PivotTable.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2212

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

#put_protect_worksheet(put_protect_worksheet_request, opts = {}) ⇒ Object

Protect worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3040

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

#put_vertical_page_break(put_vertical_page_break_request, opts = {}) ⇒ Object

Add a vertical page break in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1988

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

#put_workbook_background(put_workbook_background_request, opts = {}) ⇒ Object

Set background in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2928

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

#put_workbook_create(put_workbook_create_request, opts = {}) ⇒ Object

Create a new workbook using different methods.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2872

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

#put_workbook_name(put_workbook_name_request, opts = {}) ⇒ Object

Define a new name in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2792

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

#put_workbook_water_marker(put_workbook_water_marker_request, opts = {}) ⇒ Object

Set water marker in the workbook.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2944

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

#put_worksheet_add_picture(put_worksheet_add_picture_request, opts = {}) ⇒ Object

Add a new picture in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2124

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

#put_worksheet_background(put_worksheet_background_request, opts = {}) ⇒ Object

Set background image in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3192

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

#put_worksheet_cells_range(put_worksheet_cells_range_request, opts = {}) ⇒ Object

Insert a range of cells and shift existing cells based on the specified shift option.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2547

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

#put_worksheet_chart(put_worksheet_chart_request, opts = {}) ⇒ Object

Add a new chart in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1158

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

#put_worksheet_chart_legend(put_worksheet_chart_legend_request, opts = {}) ⇒ Object

Show chart legend in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1198

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

#put_worksheet_chart_title(put_worksheet_chart_title_request, opts = {}) ⇒ Object

Set chart title in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1238

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

#put_worksheet_color_filter(put_worksheet_color_filter_request, opts = {}) ⇒ Object

Add a color filter in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 678

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

#put_worksheet_comment(put_worksheet_comment_request, opts = {}) ⇒ Object

Add cell comment in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3080

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

#put_worksheet_conditional_formatting(put_worksheet_conditional_formatting_request, opts = {}) ⇒ Object

Add conditional formatting in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1350

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

#put_worksheet_custom_filter(put_worksheet_custom_filter_request, opts = {}) ⇒ Object

Filter a list with custom criteria in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 654

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

#put_worksheet_date_filter(put_worksheet_date_filter_request, opts = {}) ⇒ Object

Apply a date filter in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 630

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

#put_worksheet_dynamic_filter(put_worksheet_dynamic_filter_request, opts = {}) ⇒ Object

Add a dynamic filter in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 662

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

#put_worksheet_filter(put_worksheet_filter_request, opts = {}) ⇒ Object

Add a filter for a column in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 638

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

#put_worksheet_filter_top10(put_worksheet_filter_top10_request, opts = {}) ⇒ Object

Filter the top 10 items in the list in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 670

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

#put_worksheet_format_condition(put_worksheet_format_condition_request, opts = {}) ⇒ Object

Add a format condition in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1358

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

#put_worksheet_format_condition_area(put_worksheet_format_condition_area_request, opts = {}) ⇒ Object

Add a cell area for the format condition in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1366

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

#put_worksheet_format_condition_condition(put_worksheet_format_condition_condition_request, opts = {}) ⇒ Object

Add a condition for the format condition in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1374

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

#put_worksheet_freeze_panes(put_worksheet_freeze_panes_request, opts = {}) ⇒ Object

Set freeze panes in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3208

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

#put_worksheet_hyperlink(put_worksheet_hyperlink_request, opts = {}) ⇒ Object

Add hyperlink in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1668

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

#put_worksheet_icon_filter(put_worksheet_icon_filter_request, opts = {}) ⇒ Object

Add an icon filter in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 646

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

#put_worksheet_list_object(put_worksheet_list_object_request, opts = {}) ⇒ Object

Add a ListObject in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1820

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

#put_worksheet_ole_object(put_worksheet_ole_object_request, opts = {}) ⇒ Object

Add an OLE object in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1948

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

#put_worksheet_pivot_table(put_worksheet_pivot_table_request, opts = {}) ⇒ Object

Add a PivotTable in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2204

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

#put_worksheet_pivot_table_filter(put_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object

Add a pivot filter to the PivotTable.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2220

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

#put_worksheet_shape(put_worksheet_shape_request, opts = {}) ⇒ Object

Add a shape in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2579

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

#put_worksheet_sparkline_group(put_worksheet_sparkline_group_request, opts = {}) ⇒ Object

Add a sparkline group in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2659

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

#put_worksheet_validation(put_worksheet_validation_request, opts = {}) ⇒ Object

Add a validation at index in the worksheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 3296

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

#rename_worksheet_in_spreadsheet(rename_worksheet_in_spreadsheet_request, opts = {}) ⇒ Object

The Web API endpoint allows users to rename a specified worksheet within a workbook. This function provides a straightforward way to update worksheet names, enhancing workbook organization and readability.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 333

def rename_worksheet_in_spreadsheet( rename_worksheet_in_spreadsheet_request, opts = {})

   data, _status_code, _headers = rename_worksheet_in_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#replace_content_in_remote_range(replace_content_in_remote_range_request, opts = {}) ⇒ Object

Replace text in the range of remoted spreadsheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 429

def replace_content_in_remote_range( replace_content_in_remote_range_request, opts = {})

   data, _status_code, _headers = replace_content_in_remote_range_request.create_http_request(@api_client,opts )
   return data
end

#replace_content_in_remote_spreadsheet(replace_content_in_remote_spreadsheet_request, opts = {}) ⇒ Object

Replace text in the remoted spreadsheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 413

def replace_content_in_remote_spreadsheet( replace_content_in_remote_spreadsheet_request, opts = {})

   data, _status_code, _headers = replace_content_in_remote_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#replace_content_in_remote_worksheet(replace_content_in_remote_worksheet_request, opts = {}) ⇒ Object

Replace text in the worksheet of remoted spreadsheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 421

def replace_content_in_remote_worksheet( replace_content_in_remote_worksheet_request, opts = {})

   data, _status_code, _headers = replace_content_in_remote_worksheet_request.create_http_request(@api_client,opts )
   return data
end

#replace_spreadsheet_content(replace_spreadsheet_content_request, opts = {}) ⇒ Object

Replace text in the local spreadsheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 405

def replace_spreadsheet_content( replace_spreadsheet_content_request, opts = {})

   data, _status_code, _headers = replace_spreadsheet_content_request.create_http_request(@api_client,opts )
   return data
end

#save_spreadsheet_as(save_spreadsheet_as_request, opts = {}) ⇒ Object

Converts a spreadsheet in cloud storage to the specified format.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 246

def save_spreadsheet_as( save_spreadsheet_as_request, opts = {})

   data, _status_code, _headers = save_spreadsheet_as_request.create_http_request(@api_client,opts )
   return data
end

#sawp_range(sawp_range_request, opts = {}) ⇒ Object

The Swap Ranges for Excel API provides a powerful tool to move any two columns, rows, ranges, or individual cells within an Excel file. This API allows users to re-arrange their tables quickly and efficiently, ensuring that the original data formatting is preserved and all existing formulas continue to function correctly. By leveraging this API, users can streamline their data manipulation tasks and maintain the integrity of their spreadsheets.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 508

def sawp_range( sawp_range_request, opts = {})

   data, _status_code, _headers = sawp_range_request.create_http_request(@api_client,opts )
   return data
end

#search_broken_links_in_remote_range(search_broken_links_in_remote_range_request, opts = {}) ⇒ Object

Search broken links in the range of remoted spreadsheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 461

def search_broken_links_in_remote_range( search_broken_links_in_remote_range_request, opts = {})

   data, _status_code, _headers = search_broken_links_in_remote_range_request.create_http_request(@api_client,opts )
   return data
end

#search_broken_links_in_remote_spreadsheet(search_broken_links_in_remote_spreadsheet_request, opts = {}) ⇒ Object

Search broken links in the remoted spreadsheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 445

def search_broken_links_in_remote_spreadsheet( search_broken_links_in_remote_spreadsheet_request, opts = {})

   data, _status_code, _headers = search_broken_links_in_remote_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#search_broken_links_in_remote_worksheet(search_broken_links_in_remote_worksheet_request, opts = {}) ⇒ Object

Search broken links in the worksheet of remoted spreadsheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 453

def search_broken_links_in_remote_worksheet( search_broken_links_in_remote_worksheet_request, opts = {})

   data, _status_code, _headers = search_broken_links_in_remote_worksheet_request.create_http_request(@api_client,opts )
   return data
end

#search_content_in_remote_range(search_content_in_remote_range_request, opts = {}) ⇒ Object

Search text in the range of remoted spreadsheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 397

def search_content_in_remote_range( search_content_in_remote_range_request, opts = {})

   data, _status_code, _headers = search_content_in_remote_range_request.create_http_request(@api_client,opts )
   return data
end

#search_content_in_remote_spreadsheet(search_content_in_remote_spreadsheet_request, opts = {}) ⇒ Object

Search text in the remoted spreadsheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 381

def search_content_in_remote_spreadsheet( search_content_in_remote_spreadsheet_request, opts = {})

   data, _status_code, _headers = search_content_in_remote_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#search_content_in_remote_worksheet(search_content_in_remote_worksheet_request, opts = {}) ⇒ Object

Search text in the worksheet of remoted spreadsheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 389

def search_content_in_remote_worksheet( search_content_in_remote_worksheet_request, opts = {})

   data, _status_code, _headers = search_content_in_remote_worksheet_request.create_http_request(@api_client,opts )
   return data
end

#search_spreadsheet_broken_links(search_spreadsheet_broken_links_request, opts = {}) ⇒ Object

Search broken links in the local spreadsheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 437

def search_spreadsheet_broken_links( search_spreadsheet_broken_links_request, opts = {})

   data, _status_code, _headers = search_spreadsheet_broken_links_request.create_http_request(@api_client,opts )
   return data
end

#search_spreadsheet_content(search_spreadsheet_content_request, opts = {}) ⇒ Object

Search text in the local spreadsheet.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 373

def search_spreadsheet_content( search_spreadsheet_content_request, opts = {})

   data, _status_code, _headers = search_spreadsheet_content_request.create_http_request(@api_client,opts )
   return data
end

#spec(spec_request, opts = {}) ⇒ Object

Get the specifications

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 469

def spec( spec_request, opts = {})

   data, _status_code, _headers = spec_request.create_http_request(@api_client,opts )
   return data
end

#split_remote_spreadsheet(split_remote_spreadsheet_request, opts = {}) ⇒ Object

Split a spreadsheet in cloud storage into the specified format, multi-file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 286

def split_remote_spreadsheet( split_remote_spreadsheet_request, opts = {})

   data, _status_code, _headers = split_remote_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#split_spreadsheet(split_spreadsheet_request, opts = {}) ⇒ Object

Split a local spreadsheet into the specified format, multi-file.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 278

def split_spreadsheet( split_spreadsheet_request, opts = {})

   data, _status_code, _headers = split_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#storage_exists(storage_exists_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 585

def storage_exists( storage_exists_request, opts = {})

   data, _status_code, _headers = storage_exists_request.create_http_request(@api_client,opts )
   return data
end

#unprotect_spreadsheet(unprotect_spreadsheet_request, opts = {}) ⇒ Object

Removes dual-layer password protection from Excel spreadsheets, supporting both open and modify passwords with encryption.

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 365

def unprotect_spreadsheet( unprotect_spreadsheet_request, opts = {})

   data, _status_code, _headers = unprotect_spreadsheet_request.create_http_request(@api_client,opts )
   return data
end

#upload_file(upload_file_request, opts = {}) ⇒ Object

# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 522

def upload_file( upload_file_request, opts = {})

   data, _status_code, _headers = upload_file_request.create_http_request(@api_client,opts )
   return data
end