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

• #accept_all_revisions(accept_all_revisions_request, opts = {}) ⇒ Object
• #accept_all_revisions_in_remote_spreadsheet(accept_all_revisions_in_remote_spreadsheet_request, opts = {}) ⇒ Object
• #add_picture_in_cell(add_picture_in_cell_request, opts = {}) ⇒ Object

  add new picture in the cells.

• #add_text(add_text_request, opts = {}) ⇒ Object

  Specify appending text to multiple cells at once, allowing you to add prefixes, suffixes, labels, or any specific characters.

• #add_text_in_remote_spreadsheet(add_text_in_remote_spreadsheet_request, opts = {}) ⇒ Object

  Specify appending text to multiple cells at once, allowing you to add prefixes, suffixes, labels, or any specific characters.

• #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_spreadsheet_to_csv(convert_spreadsheet_to_csv_request, opts = {}) ⇒ Object

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

• #convert_spreadsheet_to_json(convert_spreadsheet_to_json_request, opts = {}) ⇒ Object

  Converts a spreadsheet on a local drive to the JSON file.

• #convert_spreadsheet_to_pdf(convert_spreadsheet_to_pdf_request, opts = {}) ⇒ Object

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

• #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_text(convert_text_request, opts = {}) ⇒ Object

  Indicates converting the numbers stored as text into the correct number format, replacing unwanted characters and line breaks with the desired characters, and converting accented characters to their equivalent characters without accents.

• #convert_text_in_remote_spreadsheet(convert_text_in_remote_spreadsheet_request, opts = {}) ⇒ Object

  Indicates converting the numbers stored as text into the correct number format, replacing unwanted characters and line breaks with the desired characters, and converting accented characters to their equivalent characters without accents.

• #convert_worksheet_to_csv(convert_worksheet_to_csv_request, opts = {}) ⇒ Object

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

• #convert_worksheet_to_html(convert_worksheet_to_html_request, opts = {}) ⇒ Object

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

• #convert_worksheet_to_html_table(convert_worksheet_to_html_table_request, opts = {}) ⇒ Object

  Converts a worksheet of spreadsheet on a local drive to the HTML table 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_json(convert_worksheet_to_json_request, opts = {}) ⇒ Object

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

• #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.

• #decompose_user_task(decompose_user_task_request, opts = {}) ⇒ Object

  AI task decomposition: Convert user objectives to sequential action plans with formatted file export.

• #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_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.

• #extract_text(extract_text_request, opts = {}) ⇒ Object

  Indicates extracting substrings, text characters, and numbers from a spreadsheet cell into another cell without having to use complex FIND, MIN, LEFT, or RIGHT formulas.

• #flip_data(flip_data_request, opts = {}) ⇒ Object

  Transposes a specified data range (rows become columns, columns become rows).

• #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_merged_cells_in_remoted_worksheet(get_merged_cells_in_remoted_worksheet_request, opts = {}) ⇒ Object

  Get all merged cell area form a remote spreadsheet worksheet.

• #get_merged_cells_in_worksheet(get_merged_cells_in_worksheet_request, opts = {}) ⇒ Object

  Get all merged cell area form a local spreadsheet 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_spreadsheet_structure(get_spreadsheet_structure_request, opts = {}) ⇒ Object

  Structurally convert the core metadata, worksheets, tables, pivot tables, charts, shapes, and other information of an Excel workbook into a JObject type JSON object, for scenarios such as data export, API responses, and log recording.

• #get_structure_in_remote_spreadsheet(get_structure_in_remote_spreadsheet_request, opts = {}) ⇒ Object

  Structurally convert the core metadata, worksheets, tables, pivot tables, charts, shapes, and other information of an Excel workbook into a JObject type JSON object, for scenarios such as data export, API responses, and log recording.

• #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.

• #get_worksheets_with_local_spreadsheet(get_worksheets_with_local_spreadsheet_request, opts = {}) ⇒ Object

  Fetches a complete list of worksheets from the currently active local spreadsheet.

• #import_csv_data_into_spreadsheet(import_csv_data_into_spreadsheet_request, opts = {}) ⇒ Object

  Import CSV data file into the local spreadsheet.

• #import_data_into_spreadsheet(import_data_into_spreadsheet_request, opts = {}) ⇒ Object

  Import data into a spreadsheet from a supported data file format.

• #import_json_data_into_spreadsheet(import_json_data_into_spreadsheet_request, opts = {}) ⇒ Object

  Import JSON data file into the local spreadsheet.

• #import_xml_data_into_spreadsheet(import_xml_data_into_spreadsheet_request, opts = {}) ⇒ Object

  Import XML data file into the local spreadsheet.

• #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
• #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.

• #remove_characters(remove_characters_request, opts = {}) ⇒ Object

  Deletes user-defined characters, predefined symbol sets, or any substring from every cell in the chosen range while preserving formulas, formatting and data-validation.

• #remove_characters_by_position(remove_characters_by_position_request, opts = {}) ⇒ Object

  Deletes characters from every cell in the target range by position (first/last N, before/after a substring, or between two delimiters) while preserving formulas, formatting and data-validation.

• #remove_characters_by_position_in_remote_spreadsheet(remove_characters_by_position_in_remote_spreadsheet_request, opts = {}) ⇒ Object

  Deletes characters from every cell in the target range by position (first/last N, before/after a substring, or between two delimiters) while preserving formulas, formatting and data-validation.

• #remove_characters_in_remote_spreadsheet(remove_characters_in_remote_spreadsheet_request, opts = {}) ⇒ Object

  Deletes user-defined characters, predefined symbol sets, or any substring from every cell in the chosen range while preserving formulas, formatting and data-validation for a remote spreadsheet.

• #remove_duplicate_substrings(remove_duplicate_substrings_request, opts = {}) ⇒ Object

  Finds and removes repeated substrings inside every cell of the chosen range, using user-defined or preset delimiters, while preserving formulas, formatting and data-validation.

• #remove_duplicate_substrings_in_remote_spreadsheet(remove_duplicate_substrings_in_remote_spreadsheet_request, opts = {}) ⇒ Object

  Finds and removes repeated substrings inside every cell of the chosen range, using user-defined or preset delimiters, while preserving formulas, formatting and data-validation.

• #remove_duplicates(remove_duplicates_request, opts = {}) ⇒ Object

  Removes duplicate values in the worksheet/range/table.

• #remove_spreadsheet_blank_columns(remove_spreadsheet_blank_columns_request, opts = {}) ⇒ Object

  Delete all blank rows that do not contain any data or other objects.

• #remove_spreadsheet_blank_rows(remove_spreadsheet_blank_rows_request, opts = {}) ⇒ Object

  Delete all blank rows that do not contain any data or other objects.

• #remove_spreadsheet_blank_worksheets(remove_spreadsheet_blank_worksheets_request, opts = {}) ⇒ Object

  Delete all blank rows that do not contain any data or other objects.

• #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.

• #repair_spreadsheet(repair_spreadsheet_request, opts = {}) ⇒ Object

  The Web API endpoint allows users to repair a spreadsheet.

• #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.

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

  Converts a spreadsheet in cloud storage to the specified format.

• #search_all_text_items_in_remote_spreadsheet(search_all_text_items_in_remote_spreadsheet_request, opts = {}) ⇒ Object

  Get all text items in the remote spreadsheet.

• #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_all_text_items(search_spreadsheet_all_text_items_request, opts = {}) ⇒ Object

  Get all text items in the remote 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.

• #split_table(split_table_request, opts = {}) ⇒ Object

  Split an Excel worksheet tale into multiple sheets by column value.

• #split_text(split_text_request, opts = {}) ⇒ Object

  Indicates performing text segmentation on the specified area according to the segmentation method, and outputting to the designated interval.

• #spreadsheet_digitalsignature(spreadsheet_digitalsignature_request, opts = {}) ⇒ Object
• #storage_exists(storage_exists_request, opts = {}) ⇒ Object
• #summarize_spreadsheet(summarize_spreadsheet_request, opts = {}) ⇒ Object

  Summarizes spreadsheet content using AI and returns the summary as a downloadable text file.

• #swap_range(swap_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.

• #translate_spreadsheet(translate_spreadsheet_request, opts = {}) ⇒ Object

  Translates the entire spreadsheet to the specified target language.

• #translate_text_file(translate_text_file_request, opts = {}) ⇒ Object

  Translates text file content to the specified target language.

• #transpose_data(transpose_data_request, opts = {}) ⇒ Object

  Switch rows and columns in the spreadsheet.

• #trim_character(trim_character_request, opts = {}) ⇒ Object

  The TrimSpreadsheetContent API is designed to process and trim content within a remote spreadsheet.

• #trim_character_in_remote_spreadsheet(trim_character_in_remote_spreadsheet_request, opts = {}) ⇒ Object

  The TrimSpreadsheetContent API is designed to process and trim content within a spreadsheet.

• #unpivot_range(unpivot_range_request, opts = {}) ⇒ Object

  Switch rows and columns in the spreadsheet.

• #unpivot_table(unpivot_table_request, opts = {}) ⇒ Object

  Switch rows and columns in the spreadsheet.

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

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

• #update_word_case(update_word_case_request, opts = {}) ⇒ Object

  Specify changing the text case in a spreadsheet to switch between uppercase, lowercase, capitalizing the first letter of each word, or capitalizing the first letter of a sentence, and adjust the text according to specific needs.

• #update_word_case_in_remote_spreadsheet(update_word_case_in_remote_spreadsheet_request, opts = {}) ⇒ Object

  Specify changing the text case in a remote spreadsheet to switch between uppercase, lowercase, capitalizing the first letter of each word, or capitalizing the first letter of a sentence, and adjust the text according to specific needs.

• #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

#accept_all_revisions(accept_all_revisions_request, opts = {}) ⇒ Object

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

def accept_all_revisions( accept_all_revisions_request, opts = {})

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

#accept_all_revisions_in_remote_spreadsheet(accept_all_revisions_in_remote_spreadsheet_request, opts = {}) ⇒ Object

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

def accept_all_revisions_in_remote_spreadsheet( accept_all_revisions_in_remote_spreadsheet_request, opts = {})

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

#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 2512

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

Specify appending text to multiple cells at once, allowing you to add prefixes, suffixes, labels, or any specific characters. You can choose the exact position of the text—in the beginning, at the end, or before or after certain characters in the cell.

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

def add_text( add_text_request, opts = {})

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

#add_text_in_remote_spreadsheet(add_text_in_remote_spreadsheet_request, opts = {}) ⇒ Object

Specify appending text to multiple cells at once, allowing you to add prefixes, suffixes, labels, or any specific characters. You can choose the exact position of the text—in the beginning, at the end, or before or after certain characters in the cell.

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

def add_text_in_remote_spreadsheet( add_text_in_remote_spreadsheet_request, opts = {})

   data, _status_code, _headers = add_text_in_remote_spreadsheet_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 452

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 84

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 116

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 1903

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 1896

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 688

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 484

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 324

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 332

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 300

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 308

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 284

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 316

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 292

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 164

def convert_spreadsheet( convert_spreadsheet_request, opts = {})

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

#convert_spreadsheet_to_csv(convert_spreadsheet_to_csv_request, opts = {}) ⇒ Object

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

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

def convert_spreadsheet_to_csv( convert_spreadsheet_to_csv_request, opts = {})

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

#convert_spreadsheet_to_json(convert_spreadsheet_to_json_request, opts = {}) ⇒ Object

Converts a spreadsheet on a local drive to the JSON file.

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

def convert_spreadsheet_to_json( convert_spreadsheet_to_json_request, opts = {})

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

#convert_spreadsheet_to_pdf(convert_spreadsheet_to_pdf_request, opts = {}) ⇒ Object

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

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

def convert_spreadsheet_to_pdf( convert_spreadsheet_to_pdf_request, opts = {})

   data, _status_code, _headers = convert_spreadsheet_to_pdf_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 260

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 268

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 244

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 276

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 252

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

Indicates converting the numbers stored as text into the correct number format, replacing unwanted characters and line breaks with the desired characters, and converting accented characters to their equivalent characters without accents.

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

def convert_text( convert_text_request, opts = {})

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

#convert_text_in_remote_spreadsheet(convert_text_in_remote_spreadsheet_request, opts = {}) ⇒ Object

Indicates converting the numbers stored as text into the correct number format, replacing unwanted characters and line breaks with the desired characters, and converting accented characters to their equivalent characters without accents.

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

def convert_text_in_remote_spreadsheet( convert_text_in_remote_spreadsheet_request, opts = {})

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

#convert_worksheet_to_csv(convert_worksheet_to_csv_request, opts = {}) ⇒ Object

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

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

def convert_worksheet_to_csv( convert_worksheet_to_csv_request, opts = {})

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

#convert_worksheet_to_html(convert_worksheet_to_html_request, opts = {}) ⇒ Object

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

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

def convert_worksheet_to_html( convert_worksheet_to_html_request, opts = {})

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

#convert_worksheet_to_html_table(convert_worksheet_to_html_table_request, opts = {}) ⇒ Object

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

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

def convert_worksheet_to_html_table( convert_worksheet_to_html_table_request, opts = {})

   data, _status_code, _headers = convert_worksheet_to_html_table_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 196

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

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

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

def convert_worksheet_to_json( convert_worksheet_to_json_request, opts = {})

   data, _status_code, _headers = convert_worksheet_to_json_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 204

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 909

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 944

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 937

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 436

def create_spreadsheet( create_spreadsheet_request, opts = {})

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

#decompose_user_task(decompose_user_task_request, opts = {}) ⇒ Object

AI task decomposition: Convert user objectives to sequential action plans with formatted file export.

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

def decompose_user_task( decompose_user_task_request, opts = {})

   data, _status_code, _headers = decompose_user_task_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 2768

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 2744

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 2736

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 2800

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 923

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 958

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 2432

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 2408

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 2392

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 2176

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 2688

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

Excel unprotection.

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

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 3428

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 2400

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 2384

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 3316

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 3212

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 3204

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 3396

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 3580

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 2935

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 1546

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 1586

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 1626

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 1594

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 1322

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 3476

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 3484

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 1770

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 1778

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 1762

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 1090

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 1098

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 3596

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 460

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 2032

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 2056

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 2216

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 2208

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 2312

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 2304

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 2528

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 2536

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 2680

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 2704

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 2696

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 2672

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 1394

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 1402

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 2975

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 2967

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 3031

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 3023

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 3692

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 3700

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 3404

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 895

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 140

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 156

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 124

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 148

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 132

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

#extract_text(extract_text_request, opts = {}) ⇒ Object

Indicates extracting substrings, text characters, and numbers from a spreadsheet cell into another cell without having to use complex FIND, MIN, LEFT, or RIGHT formulas.

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

def extract_text( extract_text_request, opts = {})

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

#flip_data(flip_data_request, opts = {}) ⇒ Object

Transposes a specified data range (rows become columns, columns become rows).

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

def flip_data( flip_data_request, opts = {})

   data, _status_code, _headers = flip_data_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 3340

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 108

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 1258

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 1490

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 1482

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 1498

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 1514

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 1506

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 1642

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 1658

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 1666

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 1634

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 1650

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 979

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 2712

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 2728

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 986

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 930

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 2456

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 2440

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 2360

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 2344

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

Get all merged cell area form a remote spreadsheet worksheet.

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

def get_merged_cells_in_remoted_worksheet( get_merged_cells_in_remoted_worksheet_request, opts = {})

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

#get_merged_cells_in_worksheet(get_merged_cells_in_worksheet_request, opts = {}) ⇒ Object

Get all merged cell area form a local spreadsheet worksheet.

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

def get_merged_cells_in_worksheet( get_merged_cells_in_worksheet_request, opts = {})

   data, _status_code, _headers = get_merged_cells_in_worksheet_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 2168

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 3636

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 3628

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 3332

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 2416

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 2560

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 428

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

Structurally convert the core metadata, worksheets, tables, pivot tables, charts, shapes, and other information of an Excel workbook into a JObject type JSON object, for scenarios such as data export, API responses, and log recording.

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

def get_spreadsheet_structure( get_spreadsheet_structure_request, opts = {})

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

#get_structure_in_remote_spreadsheet(get_structure_in_remote_spreadsheet_request, opts = {}) ⇒ Object

Structurally convert the core metadata, worksheets, tables, pivot tables, charts, shapes, and other information of an Excel workbook into a JObject type JSON object, for scenarios such as data export, API responses, and log recording.

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

def get_structure_in_remote_spreadsheet( get_structure_in_remote_spreadsheet_request, opts = {})

   data, _status_code, _headers = get_structure_in_remote_spreadsheet_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 2352

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 2336

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 1786

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 3148

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 3180

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 3196

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 3164

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 3292

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 3156

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 1002

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 1114

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 1106

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 3508

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 1210

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 1218

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 1202

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 2864

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 1530

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 1562

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 1602

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 1522

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 1306

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 1290

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 3452

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 3444

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 1722

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 1714

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 2024

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 2016

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 2192

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 2184

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 3500

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 3492

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 2296

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 2288

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 3652

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 2496

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 2488

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 2552

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 2576

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 2568

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 2544

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 1386

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 1378

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 2951

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 2943

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 3015

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 3007

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 3436

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 3668

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 3660

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 3356

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 3348

def get_worksheets( get_worksheets_request, opts = {})

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

#get_worksheets_with_local_spreadsheet(get_worksheets_with_local_spreadsheet_request, opts = {}) ⇒ Object

Fetches a complete list of worksheets from the currently active local spreadsheet.

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

def get_worksheets_with_local_spreadsheet( get_worksheets_with_local_spreadsheet_request, opts = {})

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

#import_csv_data_into_spreadsheet(import_csv_data_into_spreadsheet_request, opts = {}) ⇒ Object

Import CSV data file into the local spreadsheet.

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

def import_csv_data_into_spreadsheet( import_csv_data_into_spreadsheet_request, opts = {})

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

#import_data_into_spreadsheet(import_data_into_spreadsheet_request, opts = {}) ⇒ Object

Import data into a spreadsheet from a supported data file format.

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

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

#import_json_data_into_spreadsheet(import_json_data_into_spreadsheet_request, opts = {}) ⇒ Object

Import JSON data file into the local spreadsheet.

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

def import_json_data_into_spreadsheet( import_json_data_into_spreadsheet_request, opts = {})

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

#import_xml_data_into_spreadsheet(import_xml_data_into_spreadsheet_request, opts = {}) ⇒ Object

Import XML data file into the local spreadsheet.

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

def import_xml_data_into_spreadsheet( import_xml_data_into_spreadsheet_request, opts = {})

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

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

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

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 364

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 348

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 356

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 916

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 951

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 476

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 972

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 100

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 3084

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 994

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 2064

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 3284

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 3276

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 3564

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 3548

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 3556

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 1122

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 1138

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 1130

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 1154

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 1146

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 1274

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 1282

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 3054

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 1682

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 1698

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 1706

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 1674

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 1690

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 1162

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 1170

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 2128

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 1370

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 2072

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 3116

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 1888

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 1874

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 1826

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 1842

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 1858

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 1850

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 1810

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 1818

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 1834

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 1866

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 1881

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 1250

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 3604

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 1362

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 1466

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 1960

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 1976

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 1992

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 2008

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 2000

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 2752

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 2760

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 1911

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 3132

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 2480

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 2472

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 2464

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 1346

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 1450

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 2448

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 1330

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 1434

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 2112

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 1944

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 2816

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 2080

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 2160

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 3412

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 2424

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 2624

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 2608

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 2616

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 2632

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 2648

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 2640

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 2824

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 2776

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 3108

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 3124

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 3612

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 2144

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 2104

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 2136

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 2152

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 1474

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 3076

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 2096

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 1266

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 1242

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 1298

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 3068

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 2088

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 3140

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 3092

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 1354

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 1458

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 1338

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 1442

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 2808

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 3100

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 1234

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 2320

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 3620

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 1178

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 1426

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 3644

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 2120

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 3061

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 3268

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 1952

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 1968

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 1984

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 1920

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 3244

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 1928

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 1936

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 3188

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 1802

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 3300

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 3260

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 3236

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 3220

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 3228

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 1082

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 3516

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 1226

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 2904

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 2840

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 2880

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 2896

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 2912

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 2888

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 2856

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 2919

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 2848

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 2872

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 2832

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 1554

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 1570

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 1610

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 3468

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 2991

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 2040

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 2272

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 2280

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 2224

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 2232

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 2264

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 2256

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 2248

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 2240

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 1066

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 1074

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 1186

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 2520

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 2656

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 2664

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 3540

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 2983

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 3047

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 3532

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 3524

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 2999

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 1194

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 3684

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 546

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 3372

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 3388

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 3364

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 1794

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 2720

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 2792

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 2376

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 3380

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 1314

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 1418

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 1410

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 2592

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 3420

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 2368

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 3308

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 3252

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 3172

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 3324

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 2504

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 3572

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 2927

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 1538

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 1578

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 1618

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 1058

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 3460

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 1730

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 1034

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 1010

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 1042

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 1018

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 1050

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 1738

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 1746

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 1754

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 3588

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 2048

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 1026

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 2200

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 2328

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 2584

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 2600

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 2959

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 3039

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 3676

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

#remove_characters(remove_characters_request, opts = {}) ⇒ Object

Deletes user-defined characters, predefined symbol sets, or any substring from every cell in the chosen range while preserving formulas, formatting and data-validation.

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

def remove_characters( remove_characters_request, opts = {})

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

#remove_characters_by_position(remove_characters_by_position_request, opts = {}) ⇒ Object

Deletes characters from every cell in the target range by position (first/last N, before/after a substring, or between two delimiters) while preserving formulas, formatting and data-validation.

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

def remove_characters_by_position( remove_characters_by_position_request, opts = {})

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

#remove_characters_by_position_in_remote_spreadsheet(remove_characters_by_position_in_remote_spreadsheet_request, opts = {}) ⇒ Object

Deletes characters from every cell in the target range by position (first/last N, before/after a substring, or between two delimiters) while preserving formulas, formatting and data-validation.

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

def remove_characters_by_position_in_remote_spreadsheet( remove_characters_by_position_in_remote_spreadsheet_request, opts = {})

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

#remove_characters_in_remote_spreadsheet(remove_characters_in_remote_spreadsheet_request, opts = {}) ⇒ Object

Deletes user-defined characters, predefined symbol sets, or any substring from every cell in the chosen range while preserving formulas, formatting and data-validation for a remote spreadsheet.

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

def remove_characters_in_remote_spreadsheet( remove_characters_in_remote_spreadsheet_request, opts = {})

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

#remove_duplicate_substrings(remove_duplicate_substrings_request, opts = {}) ⇒ Object

Finds and removes repeated substrings inside every cell of the chosen range, using user-defined or preset delimiters, while preserving formulas, formatting and data-validation.

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

def remove_duplicate_substrings( remove_duplicate_substrings_request, opts = {})

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

#remove_duplicate_substrings_in_remote_spreadsheet(remove_duplicate_substrings_in_remote_spreadsheet_request, opts = {}) ⇒ Object

Finds and removes repeated substrings inside every cell of the chosen range, using user-defined or preset delimiters, while preserving formulas, formatting and data-validation.

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

def remove_duplicate_substrings_in_remote_spreadsheet( remove_duplicate_substrings_in_remote_spreadsheet_request, opts = {})

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

#remove_duplicates(remove_duplicates_request, opts = {}) ⇒ Object

Removes duplicate values in the worksheet/range/table.

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

def remove_duplicates( remove_duplicates_request, opts = {})

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

#remove_spreadsheet_blank_columns(remove_spreadsheet_blank_columns_request, opts = {}) ⇒ Object

Delete all blank rows that do not contain any data or other objects.

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

def remove_spreadsheet_blank_columns( remove_spreadsheet_blank_columns_request, opts = {})

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

#remove_spreadsheet_blank_rows(remove_spreadsheet_blank_rows_request, opts = {}) ⇒ Object

Delete all blank rows that do not contain any data or other objects.

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

def remove_spreadsheet_blank_rows( remove_spreadsheet_blank_rows_request, opts = {})

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

#remove_spreadsheet_blank_worksheets(remove_spreadsheet_blank_worksheets_request, opts = {}) ⇒ Object

Delete all blank rows that do not contain any data or other objects.

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

def remove_spreadsheet_blank_worksheets( remove_spreadsheet_blank_worksheets_request, opts = {})

   data, _status_code, _headers = remove_spreadsheet_blank_worksheets_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 468

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

#repair_spreadsheet(repair_spreadsheet_request, opts = {}) ⇒ Object

The Web API endpoint allows users to repair a spreadsheet.

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

def repair_spreadsheet( repair_spreadsheet_request, opts = {})

   data, _status_code, _headers = repair_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 641

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 625

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 633

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 617

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

#report_ai_analysis(report_ai_analysis_request, opts = {}) ⇒ Object

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

def report_ai_analysis( report_ai_analysis_request, opts = {})

   data, _status_code, _headers = report_ai_analysis_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 340

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

#search_all_text_items_in_remote_spreadsheet(search_all_text_items_in_remote_spreadsheet_request, opts = {}) ⇒ Object

Get all text items in the remote spreadsheet.

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

def search_all_text_items_in_remote_spreadsheet( search_all_text_items_in_remote_spreadsheet_request, opts = {})

   data, _status_code, _headers = search_all_text_items_in_remote_spreadsheet_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 673

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 657

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 665

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 609

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 593

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 601

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

Get all text items in the remote spreadsheet.

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

def search_spreadsheet_all_text_items( search_spreadsheet_all_text_items_request, opts = {})

   data, _status_code, _headers = search_spreadsheet_all_text_items_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 649

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 585

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 681

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 388

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 372

def split_spreadsheet( split_spreadsheet_request, opts = {})

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

#split_table(split_table_request, opts = {}) ⇒ Object

Split an Excel worksheet tale into multiple sheets by column value.

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

def split_table( split_table_request, opts = {})

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

#split_text(split_text_request, opts = {}) ⇒ Object

Indicates performing text segmentation on the specified area according to the segmentation method, and outputting to the designated interval.

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

def split_text( split_text_request, opts = {})

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

#spreadsheet_digitalsignature(spreadsheet_digitalsignature_request, opts = {}) ⇒ Object

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

def spreadsheet_digitalsignature( spreadsheet_digitalsignature_request, opts = {})

   data, _status_code, _headers = spreadsheet_digitalsignature_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 965

def storage_exists( storage_exists_request, opts = {})

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

#summarize_spreadsheet(summarize_spreadsheet_request, opts = {}) ⇒ Object

Summarizes spreadsheet content using AI and returns the summary as a downloadable text file.

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

def summarize_spreadsheet( summarize_spreadsheet_request, opts = {})

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

#swap_range(swap_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 856

def swap_range( swap_range_request, opts = {})

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

#translate_spreadsheet(translate_spreadsheet_request, opts = {}) ⇒ Object

Translates the entire spreadsheet to the specified target language.

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

def translate_spreadsheet( translate_spreadsheet_request, opts = {})

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

#translate_text_file(translate_text_file_request, opts = {}) ⇒ Object

Translates text file content to the specified target language.

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

def translate_text_file( translate_text_file_request, opts = {})

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

#transpose_data(transpose_data_request, opts = {}) ⇒ Object

Switch rows and columns in the spreadsheet.

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

def transpose_data( transpose_data_request, opts = {})

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

#trim_character(trim_character_request, opts = {}) ⇒ Object

The TrimSpreadsheetContent API is designed to process and trim content within a remote 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 704

def trim_character( trim_character_request, opts = {})

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

#trim_character_in_remote_spreadsheet(trim_character_in_remote_spreadsheet_request, opts = {}) ⇒ Object

The TrimSpreadsheetContent API is designed to process and trim content within 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 696

def trim_character_in_remote_spreadsheet( trim_character_in_remote_spreadsheet_request, opts = {})

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

#unpivot_range(unpivot_range_request, opts = {}) ⇒ Object

Switch rows and columns in the spreadsheet.

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

def unpivot_range( unpivot_range_request, opts = {})

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

#unpivot_table(unpivot_table_request, opts = {}) ⇒ Object

Switch rows and columns in the spreadsheet.

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

def unpivot_table( unpivot_table_request, opts = {})

   data, _status_code, _headers = unpivot_table_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 554

def unprotect_spreadsheet( unprotect_spreadsheet_request, opts = {})

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

#update_word_case(update_word_case_request, opts = {}) ⇒ Object

Specify changing the text case in a spreadsheet to switch between uppercase, lowercase, capitalizing the first letter of each word, or capitalizing the first letter of a sentence, and adjust the text according to specific needs.

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

def update_word_case( update_word_case_request, opts = {})

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

#update_word_case_in_remote_spreadsheet(update_word_case_in_remote_spreadsheet_request, opts = {}) ⇒ Object

Specify changing the text case in a remote spreadsheet to switch between uppercase, lowercase, capitalizing the first letter of each word, or capitalizing the first letter of a sentence, and adjust the text according to specific needs.

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

def update_word_case_in_remote_spreadsheet( update_word_case_in_remote_spreadsheet_request, opts = {})

   data, _status_code, _headers = update_word_case_in_remote_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 902

def upload_file( upload_file_request, opts = {})

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