Class: AsposeCellsCloud::CellsApi

Inherits:

Object

• Object
• AsposeCellsCloud::CellsApi

Defined in:

lib/aspose_cells_cloud/api/cells_api.rb

Instance Attribute Summary

• #api_client ⇒ Object

  Returns the value of attribute api_client.

Instance Method Summary

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

  add new picture in the cells.

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

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

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

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

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

Constructor Details

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

Returns a new instance of CellsApi.

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

def initialize(client_id,client_secret, app_version = 'v3.0', app_host = 'api.aspose.cloud',  api_client = ApiClient.default)
  @api_client = api_client
  @api_client.config.client_secret = client_secret
  @api_client.config.client_id = client_id
  @api_client.config.api_version = app_version
  @api_client.config.host = app_host
end

Instance Attribute Details

#api_client ⇒ Object

Returns the value of attribute api_client.

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

def api_client
  @api_client
end

Instance Method Details

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

add new picture in the cells.

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

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 691

def add_text( add_text_request, opts = {})

   data, _status_code, _headers = add_text_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 437

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 69

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 101

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 1778

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 1771

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 643

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 469

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 309

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 317

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 285

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 293

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 269

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 301

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 277

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 149

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 173

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 165

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 157

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 245

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 253

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 229

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 261

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 237

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 699

def convert_text( convert_text_request, opts = {})

   data, _status_code, _headers = convert_text_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 205

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 213

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 221

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 181

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 197

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 189

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 784

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 819

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 812

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 421

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 2643

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 2619

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 2611

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 2675

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 798

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 833

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 2307

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 2283

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 2267

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 2051

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 2563

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 2659

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 3303

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 2275

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 2259

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 3191

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 3087

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 3079

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 3271

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 3455

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 2810

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 1421

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 1461

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 1501

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 1469

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 1197

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 3351

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 3359

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 1645

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 1653

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 1637

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 965

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 973

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 3471

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 445

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 1907

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 1931

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 2091

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 2083

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 2187

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 2179

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 2403

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 2411

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 2555

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 2579

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 2571

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 2547

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 1269

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 1277

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 2850

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 2842

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 2906

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 2898

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 3567

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 3575

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 3279

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 770

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 125

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 141

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 109

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 133

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 117

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 707

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 763

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 3215

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 93

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 1133

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 1365

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 1357

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 1373

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 1389

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 1381

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 1517

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 1533

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 1541

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 1509

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 1525

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 854

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 2587

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 2603

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 861

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 805

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 2331

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 2315

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 2235

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 2219

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 485

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 493

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 2043

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 3511

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 3503

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 3207

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 2291

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 2435

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 413

def get_public_key( get_public_key_request, opts = {})

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

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

Retrieve a vertical page break description in the worksheet.

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

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 2211

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 1661

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 3023

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 3055

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 3071

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 3039

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 3167

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 3031

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 877

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 989

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 981

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 3383

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 1085

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 1093

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 1077

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 2739

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 1405

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 1437

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 1477

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 1397

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 1181

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 1165

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 3327

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 3319

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 1597

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 1589

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 1899

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 1891

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 2067

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 2059

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 3375

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 3367

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 2171

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 2163

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 3527

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 2371

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 2363

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 2427

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 2451

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 2443

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 2419

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 1261

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 1253

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 2826

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 2818

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 2890

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 2882

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 3311

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 3543

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 3535

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 3231

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 3223

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 429

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 405

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 381

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 389

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 397

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 76

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 349

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 333

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 341

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 791

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 826

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 461

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 847

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 85

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 2959

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 869

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 1939

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 3159

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 3151

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 3439

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 3423

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 3431

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 997

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 1013

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 1005

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 1029

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 1021

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 1149

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 1157

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 2929

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 1557

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 1573

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 1581

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 1549

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 1565

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 1037

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 1045

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 2003

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 1245

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 1947

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 2991

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 1763

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 1749

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 1701

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 1717

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 1733

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 1725

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 1685

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 1693

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 1709

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 1741

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 1756

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 1125

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 3479

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 1237

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 1341

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 1835

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 1851

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 1867

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 1883

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 1875

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 2627

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 2635

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 1786

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 3007

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 2355

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 2347

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 2339

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 1221

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 1325

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 2323

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 1205

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 1309

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 1987

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 1819

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 2691

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 1955

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 2035

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 3287

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 2299

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 2499

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 2483

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 2491

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 2507

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 2523

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 2515

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 2699

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 2651

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 2983

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 2999

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 3487

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 2019

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 1979

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 2011

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 2027

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 1349

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 2951

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 1971

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 1141

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 1117

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 1173

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 2943

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 1963

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 3015

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 2967

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 1229

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 1333

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 1213

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 1317

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 2683

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 2975

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 1109

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 2195

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 3495

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 1053

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 1301

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 3519

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 1995

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 2936

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 3143

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 1827

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 1843

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 1859

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 1795

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 3119

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 1803

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 1811

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 3063

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 1677

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 3175

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 3135

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 3111

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 3095

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 3103

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 957

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 3391

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 1101

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 2779

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 2715

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 2755

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 2771

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 2787

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 2763

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 2731

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 2794

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 2723

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 2747

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 2707

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 1429

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 1445

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 1485

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 3343

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 2866

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 1915

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 2147

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 2155

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 2099

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 2107

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 2139

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 2131

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 2123

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 2115

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 941

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 949

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 1061

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 2395

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 2531

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 2539

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 3415

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 2858

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 2922

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 3407

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 3399

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 2874

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 1069

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 3559

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 501

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 3247

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 3263

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 3239

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 1669

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 2595

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 2667

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 2251

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 3255

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 1189

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 1293

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 1285

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 2467

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 3295

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 2243

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 3183

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 3127

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 3047

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 3199

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 2379

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 3447

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 2802

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 1413

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 1453

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 1493

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 933

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 3335

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 1605

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 909

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 885

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 917

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 893

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 925

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 1613

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 1621

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 1629

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 3463

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 1923

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 901

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 2075

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 2203

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 2459

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 2475

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 2834

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 2914

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 3551

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 667

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 675

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_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 683

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

Removes duplicate values in the worksheet/range/table.

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

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 731

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 723

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 739

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 453

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 477

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 596

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 580

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 588

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 572

def replace_spreadsheet_content( replace_spreadsheet_content_request, opts = {})

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

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

Converts a spreadsheet in cloud storage to the specified format.

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

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 524

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 628

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 612

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 620

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 564

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 548

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 556

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 532

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 604

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 540

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 636

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 373

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 357

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 365

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 715

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 516

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 840

def storage_exists( storage_exists_request, opts = {})

   data, _status_code, _headers = storage_exists_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 755

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

#trim_character(trim_character_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 651

def trim_character( trim_character_request, opts = {})

   data, _status_code, _headers = trim_character_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 509

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 659

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

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

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

def upload_file( upload_file_request, opts = {})

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