Class: AsposeCellsCloud::CellsApi

Inherits:

Object

• Object
• AsposeCellsCloud::CellsApi

Defined in:

lib/aspose_cells_cloud/api/cells_api.rb

Instance Attribute Summary

• #api_client ⇒ Object

  Returns the value of attribute api_client.

Instance Method Summary

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

  add new picture in the cells.

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

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

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

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

  Switch rows and columns in the spreadsheet.

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

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

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

  Switch rows and columns in the spreadsheet.

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

  Switch rows and columns in the spreadsheet.

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

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

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

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

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

Constructor Details

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

Returns a new instance of CellsApi.

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

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

Instance Attribute Details

#api_client ⇒ Object

Returns the value of attribute api_client.

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

def api_client
  @api_client
end

Instance Method Details

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

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

def accept_all_revisions( accept_all_revisions_request, opts = {})

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

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

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

def accept_all_revisions_in_remote_spreadsheet( accept_all_revisions_in_remote_spreadsheet_request, opts = {})

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

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

add new picture in the cells.

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

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 705

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 1816

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 1809

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 657

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 713

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 822

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 857

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 850

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 2681

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 2657

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 2649

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 2713

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 836

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 871

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 2345

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 2321

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 2305

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 2089

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 2601

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 2697

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 3341

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 2313

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 2297

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 3229

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 3125

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 3117

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 3309

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 3493

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 2848

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 1459

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 1499

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 1539

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 1507

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 1235

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 3389

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 3397

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 1683

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 1691

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 1675

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 1003

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 1011

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 3509

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 1945

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 1969

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 2129

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 2121

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 2225

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 2217

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 2441

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 2449

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 2593

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 2617

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 2609

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 2585

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 1307

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 1315

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 2888

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 2880

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 2944

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 2936

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 3605

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 3613

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 3317

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 808

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 721

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 777

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 3253

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 1171

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 1403

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 1395

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 1411

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 1427

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 1419

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 1555

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 1571

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 1579

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 1547

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 1563

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 892

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 2625

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 2641

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 899

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 843

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 2369

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 2353

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 2273

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 2257

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 2081

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 3549

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 3541

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 3245

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 2329

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 2473

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 2265

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 2249

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 1699

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 3061

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 3093

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 3109

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 3077

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 3205

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 3069

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 915

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 1027

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 1019

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 3421

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 1123

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 1131

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 1115

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 2777

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 1443

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 1475

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 1515

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 1435

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 1219

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 1203

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 3365

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 3357

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 1635

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 1627

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 1937

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 1929

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 2105

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 2097

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 3413

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 3405

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 2209

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 2201

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 3565

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 2409

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 2401

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 2465

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 2489

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 2481

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 2457

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 1299

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 1291

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 2864

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 2856

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 2928

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 2920

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 3349

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 3581

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 3573

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 3269

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 3261

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 829

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 864

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 885

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 2997

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 907

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 1977

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 3197

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 3189

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 3477

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 3461

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 3469

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 1035

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 1051

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 1043

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 1067

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 1059

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 1187

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 1195

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 2967

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 1595

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 1611

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 1619

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 1587

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 1603

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 1075

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 1083

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 2041

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 1283

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 1985

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 3029

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 1801

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 1787

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 1739

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 1755

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 1771

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 1763

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 1723

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 1731

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 1747

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 1779

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 1794

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 1163

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 3517

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 1275

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 1379

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 1873

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 1889

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 1905

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 1921

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 1913

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 2665

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 2673

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 1824

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 3045

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 2393

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 2385

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 2377

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 1259

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 1363

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 2361

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 1243

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 1347

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 2025

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 1857

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 2729

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 1993

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 2073

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 3325

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 2337

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 2537

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 2521

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 2529

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 2545

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 2561

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 2553

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 2737

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 2689

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 3021

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 3037

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 3525

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 2057

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 2017

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 2049

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 2065

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 1387

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 2989

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 2009

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 1179

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 1155

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 1211

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 2981

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 2001

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 3053

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 3005

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 1267

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 1371

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 1251

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 1355

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 2721

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 3013

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 1147

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 2233

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 3533

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 1091

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 1339

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 3557

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 2033

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 2974

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 3181

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 1865

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 1881

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 1897

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 1833

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 3157

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 1841

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 1849

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 3101

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 1715

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 3213

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 3173

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 3149

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 3133

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 3141

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 995

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 3429

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 1139

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 2817

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 2753

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 2793

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 2809

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 2825

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 2801

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 2769

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 2832

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 2761

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 2785

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 2745

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 1467

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 1483

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 1523

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 3381

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 2904

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 1953

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 2185

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 2193

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 2137

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 2145

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 2177

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 2169

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 2161

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 2153

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 979

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 987

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 1099

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 2433

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 2569

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 2577

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 3453

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 2896

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 2960

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 3445

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 3437

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 2912

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 1107

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 3597

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 515

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 3285

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 3301

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 3277

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 1707

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 2633

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 2705

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 2289

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 3293

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 1227

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 1331

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 1323

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 2505

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 3333

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 2281

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 3221

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 3165

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 3085

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 3237

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 2417

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 3485

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 2840

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 1451

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 1491

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 1531

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 971

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 3373

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 1643

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 947

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 923

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 955

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 931

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 963

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 1651

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 1659

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 1667

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 3501

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 1961

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 939

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 2113

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 2241

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 2497

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 2513

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 2872

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 2952

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 3589

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 681

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 689

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 697

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 761

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 745

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 737

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 753

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 610

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 594

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 602

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 586

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 538

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 642

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 626

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 634

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 578

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 562

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 570

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 546

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 618

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 554

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 650

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 729

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 530

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 878

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 769

def swap_range( swap_range_request, opts = {})

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

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

Translates the entire spreadsheet to the specified target language.

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

def translate_spreadsheet( translate_spreadsheet_request, opts = {})

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

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

Translates text file content to the specified target language.

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

def translate_text_file( translate_text_file_request, opts = {})

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

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

Switch rows and columns in the spreadsheet.

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

def transpose_data( transpose_data_request, opts = {})

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

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

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

def trim_character( trim_character_request, opts = {})

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

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

Switch rows and columns in the spreadsheet.

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

def unpivot_range( unpivot_range_request, opts = {})

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

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

Switch rows and columns in the spreadsheet.

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

def unpivot_table( unpivot_table_request, opts = {})

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

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

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

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

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 673

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 815

def upload_file( upload_file_request, opts = {})

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