Class: AsposeCellsCloud::CellsApi

Inherits:

Object

• Object
• AsposeCellsCloud::CellsApi

Defined in:

lib/aspose_cells_cloud/api/cells_api.rb

Instance Attribute Summary

• #api_client ⇒ Object

  Returns the value of attribute api_client.

Instance Method Summary

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

  add new picture in the cells.

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

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

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

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

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

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

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

  Check the Health Status of Aspose.Cells Cloud Service.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

• #convert_spreadsheet_to_json(convert_spreadsheet_to_json_request, opts = {}) ⇒ Object
• #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_image(convert_worksheet_to_image_request, opts = {}) ⇒ Object

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

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

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

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

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

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

  Excel files decryption.

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

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

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

  Delete an Excel property.

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

  Excel file cancel write protection.

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

  Clear header and footer in the worksheet.

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

  Delete a horizontal page break in the worksheet.

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

  Delete horizontal page breaks in the worksheet.

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

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

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

  Delete a pivot field in the PivotTable.

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

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

  Get all style in the workbook.

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

  Check the Health Status of Aspose.Cells Cloud Service.

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

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

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

  Aspose.Cells Cloud service health status check.

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

  Retrieve cell descriptions in a specified format.

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

  Retrieve chart area description in the worksheet.

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

  Retrieve chart area border description.

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

  Retrieve chart area fill format description in the worksheet.

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

  Retrieve descriptions of chart series axis in the chart.

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

  Retrieve chart second category axis in the chart.

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

  Retrieve chart second value axis in the chart.

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

  Retrieve descriptions of chart seriesaxis in the chart.

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

  Retrieve chart value axis in the chart.

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

  Retrieve descriptions of Excel file properties.

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

  Get Excel property by name.

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

  Retrieve page footer description in the worksheet.

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

  Retrieve page header description in the worksheet.

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

  Retrieve a horizontal page break descripton in the worksheet.

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

  Retrieve descriptions of horizontal page breaks in the worksheet.

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

  Get cells document properties.

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

  Retrieve values in range.

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

  Retrieve descriptions of ranges in the worksheets.

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

  Get page count in the workbook.

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

  Retrieve page setup description in the worksheet.

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

  Retrieve descriptions of pivot fields in the PivotTable.

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

  Get an asymmetric public key.

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

  Retrieve a vertical page break description in the worksheet.

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

  Retrieve descriptions of vertical page breaks in the worksheet.

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

  Retrieve workbooks in various formats.

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

  Retrieve the description of the default style for the workbook .

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

  Retrieve description of a named range in the workbook.

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

  Retrieve the value of a named range in the workbook.

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

  Retrieve named ranges in the workbook.

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

  Retrieve descriptions of workbook settings.

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

  Retrieve text items in the workbook.

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

  Retrieve the description of auto filters from a worksheet.

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

  Get autoshape description in some format.

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

  Get autoshapes description in worksheet.

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

  Calculate formula in the worksheet.

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

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

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

  Retrieve cell style descriptions in the worksheet.

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

  Retrieve cell descriptions in a specified format.

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

  Retrieve the values of cells within the specified range.

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

  Retrieve the chart in a specified format.

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

  Retrieve chart legend description in the worksheet.

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

  Retrieve chart title description in the worksheet.

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

  Retrieve descriptions of charts in the worksheet.

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

  Retrieve worksheet column data by column index.

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

  Retrieve descriptions of worksheet columns.

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

  Retrieve the description of comment in the worksheet.

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

  Retrieve the description of comments in the worksheet.

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

  Retrieve conditional formatting descriptions in the worksheet.

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

  Retrieve descriptions of conditional formattings in a worksheet.

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

  Retrieve hyperlink description by index in the worksheet.

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

  Retrieve descriptions of hyperlinks in the worksheet.

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

  Retrieve list object description by index in the worksheet.

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

  Retrieve descriptions of ListObjects in the worksheet.

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

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

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

  Get worksheet merged cells.

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

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

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

  Retrieve descriptions of OLE objects in the worksheet.

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

  Get page count in the worksheet.

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

  Retrieve a picture by number in the worksheet.

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

  Retrieve descriptions of pictures in the worksheet.

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

  Retrieve PivotTable information by index in the worksheet.

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

  Retrieve PivotTable filters in the worksheet.

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

  Gets PivotTable filters in worksheet.

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

  Retrieve descriptions of pivottables in the worksheet.

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

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

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

  Retrieve descriptions of rows in the worksheet.

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

  Retrieve description of shape in the worksheet.

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

  Retrieve descriptions of shapes in the worksheet.

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

  Retrieve description of a sparkline group in the worksheet.

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

  Retrieve descriptions of sparkline groups in the worksheet.

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

  Retrieve text items in the worksheet.

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

  Retrieve a validation by its index in the worksheet.

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

  Retrieve descriptions of validations in the worksheet.

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

  Retrieve the worksheet in a specified format from the workbook.

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

  Retrieve the description of worksheets from a workbook.

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

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

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

  Search broken links in the range of remoted spreadsheet.

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

  Search broken links in the remoted spreadsheet.

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

  Search broken links in the worksheet of remoted spreadsheet.

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

  Search text in the range of remoted spreadsheet.

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

  Search text in the remoted spreadsheet.

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

  Search text in the worksheet of remoted spreadsheet.

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

  Search broken links in the local spreadsheet.

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

  Search text in the local spreadsheet.

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

  Get the specifications.

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

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

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

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

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

  Split an Excel worksheet 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_text_file(translate_text_file_request, opts = {}) ⇒ Object
• #translation_spreadsheet(translation_spreadsheet_request, opts = {}) ⇒ Object

  Translates the entire spreadsheet to the specified target language.

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

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

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

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

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

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

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

Constructor Details

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

Returns a new instance of CellsApi.

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

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

Instance Attribute Details

#api_client ⇒ Object

Returns the value of attribute api_client.

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

def api_client
  @api_client
end

Instance Method Details

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

add new picture in the cells.

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

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 584

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 363

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 60

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 92

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 1662

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 1655

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 536

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 395

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 267

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 275

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 243

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 251

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 227

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 259

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 235

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 140

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 163

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

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

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 148

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 203

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 211

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 187

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 219

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 195

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 592

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

def convert_worksheet_to_image( convert_worksheet_to_image_request, opts = {})

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

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

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

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

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 668

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 703

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 696

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 355

def create_spreadsheet( create_spreadsheet_request, opts = {})

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

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

Excel files decryption.

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

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 2503

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 2495

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 2559

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 682

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 717

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 2191

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 2167

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 2151

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 1935

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 2447

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 2543

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 3187

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 2159

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 2143

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 3075

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 2971

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 2963

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 3155

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 3339

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 2694

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 1305

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 1345

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 1385

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 1353

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 1081

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 3235

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 3243

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 1529

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 1537

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 1521

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 849

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 857

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 3355

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 371

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 1791

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 1815

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 1975

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 1967

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 2071

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 2063

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 2287

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 2295

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 2439

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 2463

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 2455

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 2431

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 1153

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 1161

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 2734

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 2726

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 2790

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 2782

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 3451

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 3459

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 3163

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 654

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 116

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 132

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 100

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 124

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 108

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 600

def extract_text( extract_text_request, opts = {})

   data, _status_code, _headers = extract_text_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 3099

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 84

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 1017

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 1249

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 1241

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 1257

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 1273

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 1265

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 1401

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 1417

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 1425

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 1393

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 1409

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 738

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 2471

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 2487

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 745

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 689

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 2215

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 2199

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 2119

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 2103

def get_horizontal_page_breaks( get_horizontal_page_breaks_request, opts = {})

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

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

Get cells document properties.

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

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 3395

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 3387

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 3091

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 2175

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 2319

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 347

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 2111

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 2095

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 1545

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 2907

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 2939

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 2955

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 2923

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 3051

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 2915

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 761

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 873

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 865

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 3267

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 969

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 977

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 961

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 2623

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 1289

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 1321

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 1361

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 1281

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 1065

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 1049

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 3211

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 3203

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 1481

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 1473

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 1783

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 1775

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 1951

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 1943

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 3259

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 3251

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 2055

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 2047

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 3411

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 2255

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 2247

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 2311

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 2335

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 2327

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 2303

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 1145

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 1137

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 2710

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 2702

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 2774

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 2766

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 3195

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 3427

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 3419

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 3115

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 3107

def get_worksheets( get_worksheets_request, opts = {})

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

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

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

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

def import_data_into_spreadsheet( import_data_into_spreadsheet_request, opts = {})

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

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

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

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 307

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 291

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 299

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 675

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 710

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 387

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 731

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 76

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 2843

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 753

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 1823

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 3043

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 3035

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 3323

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 3307

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 3315

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 881

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 897

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 889

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 913

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 905

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 1033

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 1041

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 2813

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 1441

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 1457

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 1465

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 1433

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 1449

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 921

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 929

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 1887

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 1129

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 1831

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 2875

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 1647

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 1633

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 1585

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 1601

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 1617

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 1609

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 1569

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 1577

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 1593

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 1625

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 1640

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 1009

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 3363

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 1121

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 1225

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 1719

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 1735

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 1751

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 1767

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 1759

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 2511

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 2519

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 1670

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 2891

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 2239

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 2231

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 2223

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 1105

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 1209

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 2207

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 1089

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 1193

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 1871

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 1703

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 2575

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 1839

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 1919

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 3171

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 2183

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 2383

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 2367

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 2375

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 2391

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 2407

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 2399

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 2583

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 2535

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 2867

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 2883

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 3371

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 1903

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 1863

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 1895

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 1911

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 1233

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 2835

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 1855

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 1025

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 1001

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 1057

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 2827

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 1847

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 2899

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 2851

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 1113

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 1217

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 1097

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 1201

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 2567

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 2859

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 993

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 2079

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 3379

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 937

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 1185

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 3403

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 1879

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 2820

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 3027

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 1711

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 1727

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 1743

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 1679

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 3003

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 1687

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 1695

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 2947

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 1561

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 3059

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 3019

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 2995

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 2979

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 2987

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 841

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 3275

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 985

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 2663

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 2599

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 2639

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 2655

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 2671

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 2647

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 2615

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 2678

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 2607

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 2631

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 2591

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 1313

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 1329

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 1369

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 3227

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 2750

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 1799

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 2031

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 2039

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 1983

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 1991

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 2023

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 2015

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 2007

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 1999

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 825

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 833

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 945

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 2279

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 2415

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 2423

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 3299

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 2742

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 2806

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 3291

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 3283

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 2758

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 953

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 3443

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 410

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 3131

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 3147

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 3123

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 1553

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 2479

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 2551

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 2135

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 3139

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 1073

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 1177

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 1169

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 2351

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 3179

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 2127

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 3067

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 3011

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 2931

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 3083

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 2263

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 3331

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 2686

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 1297

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 1337

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 1377

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 817

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 3219

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 1489

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 793

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 769

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 801

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 777

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 809

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 1497

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 1505

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 1513

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 3347

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 1807

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 785

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 1959

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 2087

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 2343

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 2359

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 2718

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 2798

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 3435

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 560

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 568

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 576

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

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

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 624

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 616

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 632

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 379

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

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

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 489

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 473

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 481

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 465

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 283

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

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 505

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 513

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 457

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 441

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 449

def search_content_in_remote_worksheet( search_content_in_remote_worksheet_request, opts = {})

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

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

Search broken links in the local spreadsheet.

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

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 433

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 529

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 331

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 315

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 into multiple sheets by column value.

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

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 608

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 425

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 724

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 647

def swap_range( swap_range_request, opts = {})

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

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

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

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

#translation_spreadsheet(translation_spreadsheet_request, opts = {}) ⇒ Object

Translates the entire spreadsheet to the specified target language.

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

def translation_spreadsheet( translation_spreadsheet_request, opts = {})

   data, _status_code, _headers = translation_spreadsheet_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 544

def trim_character( trim_character_request, opts = {})

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

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

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

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

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 552

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 661

def upload_file( upload_file_request, opts = {})

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