Class: AsposeCellsCloud::CellsApi
- Inherits:
-
Object
- Object
- AsposeCellsCloud::CellsApi
- Defined in:
- lib/aspose_cells_cloud/api/cells_api.rb
Instance Attribute Summary collapse
-
#api_client ⇒ Object
Returns the value of attribute api_client.
Instance Method Summary collapse
- #copy_file(copy_file_request, opts = {}) ⇒ Object
- #copy_folder(copy_folder_request, opts = {}) ⇒ Object
- #create_folder(create_folder_request, opts = {}) ⇒ Object
-
#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_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
-
#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
-
#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
-
#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
-
#get_pivot_table_field(get_pivot_table_field_request, opts = {}) ⇒ Object
Retrieve descriptions of pivot fields in the PivotTable.
-
#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
- #get_workbook(get_workbook_request, opts = {}) ⇒ Object
- #get_workbook_default_style(get_workbook_default_style_request, opts = {}) ⇒ Object
-
#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
-
#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_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
-
#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
-
#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
-
#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
-
#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
-
#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
-
#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
-
#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
-
#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
-
#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
-
#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
-
#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
-
#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
-
#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.
- #move_file(move_file_request, opts = {}) ⇒ Object
- #move_folder(move_folder_request, opts = {}) ⇒ Object
- #object_exists(object_exists_request, opts = {}) ⇒ Object
-
#post_access_token(post_access_token_request, opts = {}) ⇒ Object
Get Access Token Result.
-
#post_add_text_content(post_add_text_content_request, opts = {}) ⇒ Object
Adds text content to a workbook at specified positions within cells based on provided options using ASP.NET Core Web API.
- #post_analyze_excel(post_analyze_excel_request, opts = {}) ⇒ Object
- #post_assemble(post_assemble_request, opts = {}) ⇒ Object
-
#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
-
#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
-
#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
-
#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
-
#post_encrypt_workbook(post_encrypt_workbook_request, opts = {}) ⇒ Object
Excel Encryption.
- #post_export(post_export_request, opts = {}) ⇒ Object
- #post_extract_text(post_extract_text_request, opts = {}) ⇒ Object
-
#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
- #post_remove_duplicates(post_remove_duplicates_request, opts = {}) ⇒ Object
-
#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
- #post_trim_content(post_trim_content_request, opts = {}) ⇒ Object
-
#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
-
#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
-
#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.
-
#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.
- #storage_exists(storage_exists_request, opts = {}) ⇒ Object
- #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.
35 36 37 38 39 40 41 |
# 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.
33 34 35 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 33 def api_client @api_client end |
Instance Method Details
#copy_file(copy_file_request, opts = {}) ⇒ Object
2707 2708 2709 2710 2711 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2707 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
2742 2743 2744 2745 2746 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2742 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
2735 2736 2737 2738 2739 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2735 def create_folder( create_folder_request, opts = {}) data, _status_code, _headers = create_folder_request.create_http_request(@api_client,opts ) return data end |
#delete_decrypt_workbook(delete_decrypt_workbook_request, opts = {}) ⇒ Object
Excel files decryption.
1775 1776 1777 1778 1779 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1775 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.
1752 1753 1754 1755 1756 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1752 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.
1744 1745 1746 1747 1748 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1744 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.
1807 1808 1809 1810 1811 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1807 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
2721 2722 2723 2724 2725 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2721 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
2756 2757 2758 2759 2760 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2756 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.
1451 1452 1453 1454 1455 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1451 def ( , opts = {}) data, _status_code, _headers = .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.
1428 1429 1430 1431 1432 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1428 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.
1412 1413 1414 1415 1416 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1412 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.
1199 1200 1201 1202 1203 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1199 def ( , opts = {}) data, _status_code, _headers = .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.
1697 1698 1699 1700 1701 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1697 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.
1791 1792 1793 1794 1795 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1791 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.
2415 2416 2417 2418 2419 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2415 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.
1420 1421 1422 1423 1424 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1420 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.
1404 1405 1406 1407 1408 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1404 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.
2312 2313 2314 2315 2316 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2312 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.
2208 2209 2210 2211 2212 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2208 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.
2200 2201 2202 2203 2204 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2200 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.
2383 2384 2385 2386 2387 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2383 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.
2567 2568 2569 2570 2571 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2567 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.
1941 1942 1943 1944 1945 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1941 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.
596 597 598 599 600 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 596 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.
636 637 638 639 640 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 636 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.
676 677 678 679 680 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 676 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.
644 645 646 647 648 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 644 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.
375 376 377 378 379 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 375 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.
2463 2464 2465 2466 2467 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2463 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.
2471 2472 2473 2474 2475 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2471 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.
819 820 821 822 823 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 819 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.
827 828 829 830 831 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 827 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.
811 812 813 814 815 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 811 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.
139 140 141 142 143 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 139 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.
147 148 149 150 151 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 147 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.
2583 2584 2585 2586 2587 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2583 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_hyperlink(delete_worksheet_hyperlink_request, opts = {}) ⇒ Object
Delete hyperlink by index in the worksheet.
1056 1057 1058 1059 1060 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1056 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.
1080 1081 1082 1083 1084 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1080 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.
1238 1239 1240 1241 1242 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1238 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.
1230 1231 1232 1233 1234 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1230 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.
1333 1334 1335 1336 1337 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1333 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.
1325 1326 1327 1328 1329 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1325 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.
1538 1539 1540 1541 1542 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1538 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.
1546 1547 1548 1549 1550 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1546 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.
1689 1690 1691 1692 1693 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1689 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.
1713 1714 1715 1716 1717 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1713 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.
1705 1706 1707 1708 1709 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1705 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.
1681 1682 1683 1684 1685 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1681 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.
446 447 448 449 450 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 446 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.
454 455 456 457 458 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 454 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.
1980 1981 1982 1983 1984 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1980 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.
1972 1973 1974 1975 1976 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1972 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.
2035 2036 2037 2038 2039 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2035 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.
2027 2028 2029 2030 2031 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2027 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.
2678 2679 2680 2681 2682 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2678 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.
2686 2687 2688 2689 2690 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2686 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.
2391 2392 2393 2394 2395 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2391 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
2693 2694 2695 2696 2697 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2693 def download_file( download_file_request, opts = {}) data, _status_code, _headers = download_file_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.
312 313 314 315 316 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 312 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.
542 543 544 545 546 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 542 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.
534 535 536 537 538 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 534 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
549 550 551 552 553 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 549 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.
565 566 567 568 569 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 565 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.
557 558 559 560 561 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 557 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.
692 693 694 695 696 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 692 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
708 709 710 711 712 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 708 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.
716 717 718 719 720 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 716 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.
684 685 686 687 688 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 684 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.
700 701 702 703 704 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 700 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
2777 2778 2779 2780 2781 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2777 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
1720 1721 1722 1723 1724 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1720 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.
1736 1737 1738 1739 1740 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1736 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
2784 2785 2786 2787 2788 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2784 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
2728 2729 2730 2731 2732 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2728 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.
1475 1476 1477 1478 1479 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1475 def ( , opts = {}) data, _status_code, _headers = .create_http_request(@api_client,opts ) return data end |
#get_header(get_header_request, opts = {}) ⇒ Object
Retrieve page header description in the worksheet.
1459 1460 1461 1462 1463 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1459 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.
1380 1381 1382 1383 1384 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1380 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.
1364 1365 1366 1367 1368 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1364 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.
1191 1192 1193 1194 1195 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1191 def ( , opts = {}) data, _status_code, _headers = .create_http_request(@api_client,opts ) return data end |
#get_named_range_value(get_named_range_value_request, opts = {}) ⇒ Object
Retrieve values in range.
2623 2624 2625 2626 2627 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2623 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.
2615 2616 2617 2618 2619 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2615 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.
2328 2329 2330 2331 2332 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2328 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
1435 1436 1437 1438 1439 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1435 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.
1569 1570 1571 1572 1573 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1569 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_vertical_page_break(get_vertical_page_break_request, opts = {}) ⇒ Object
Retrieve a vertical page break description in the worksheet.
1372 1373 1374 1375 1376 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1372 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
1356 1357 1358 1359 1360 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1356 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
834 835 836 837 838 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 834 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
2144 2145 2146 2147 2148 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2144 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.
2176 2177 2178 2179 2180 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2176 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.
2192 2193 2194 2195 2196 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2192 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.
2160 2161 2162 2163 2164 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2160 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.
2288 2289 2290 2291 2292 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2288 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.
2152 2153 2154 2155 2156 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2152 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
51 52 53 54 55 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 51 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.
162 163 164 165 166 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 162 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
154 155 156 157 158 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 154 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.
2495 2496 2497 2498 2499 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2495 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.
264 265 266 267 268 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 264 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.
272 273 274 275 276 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 272 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.
256 257 258 259 260 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 256 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.
1870 1871 1872 1873 1874 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1870 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.
580 581 582 583 584 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 580 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.
612 613 614 615 616 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 612 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.
652 653 654 655 656 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 652 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
572 573 574 575 576 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 572 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.
359 360 361 362 363 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 359 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
343 344 345 346 347 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 343 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.
2439 2440 2441 2442 2443 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2439 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.
2431 2432 2433 2434 2435 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2431 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.
771 772 773 774 775 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 771 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
763 764 765 766 767 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 763 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.
1048 1049 1050 1051 1052 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1048 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
1040 1041 1042 1043 1044 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1040 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.
1214 1215 1216 1217 1218 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1214 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
1206 1207 1208 1209 1210 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1206 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.
2487 2488 2489 2490 2491 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2487 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.
2479 2480 2481 2482 2483 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2479 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.
1317 1318 1319 1320 1321 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1317 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
1309 1310 1311 1312 1313 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1309 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.
2639 2640 2641 2642 2643 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2639 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.
1514 1515 1516 1517 1518 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1514 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
1506 1507 1508 1509 1510 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1506 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.
1561 1562 1563 1564 1565 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1561 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.
1585 1586 1587 1588 1589 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1585 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.
1577 1578 1579 1580 1581 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1577 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
1553 1554 1555 1556 1557 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1553 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.
438 439 440 441 442 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 438 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
430 431 432 433 434 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 430 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.
1956 1957 1958 1959 1960 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1956 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
1948 1949 1950 1951 1952 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1948 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.
2019 2020 2021 2022 2023 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2019 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
2011 2012 2013 2014 2015 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2011 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.
2423 2424 2425 2426 2427 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2423 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.
2654 2655 2656 2657 2658 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2654 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
2646 2647 2648 2649 2650 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2646 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.
2343 2344 2345 2346 2347 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2343 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
2335 2336 2337 2338 2339 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2335 def get_worksheets( get_worksheets_request, opts = {}) data, _status_code, _headers = get_worksheets_request.create_http_request(@api_client,opts ) return data end |
#move_file(move_file_request, opts = {}) ⇒ Object
2714 2715 2716 2717 2718 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2714 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
2749 2750 2751 2752 2753 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2749 def move_folder( move_folder_request, opts = {}) data, _status_code, _headers = move_folder_request.create_http_request(@api_client,opts ) return data end |
#object_exists(object_exists_request, opts = {}) ⇒ Object
2770 2771 2772 2773 2774 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2770 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
209 210 211 212 213 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 209 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 workbook at specified positions within cells based on provided options using ASP.NET Core Web API.
2088 2089 2090 2091 2092 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2088 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
44 45 46 47 48 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 44 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
1087 1088 1089 1090 1091 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1087 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.
2280 2281 2282 2283 2284 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2280 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.
2272 2273 2274 2275 2276 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2272 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.
2551 2552 2553 2554 2555 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2551 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.
2535 2536 2537 2538 2539 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2535 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.
2543 2544 2545 2546 2547 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2543 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
169 170 171 172 173 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 169 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.
185 186 187 188 189 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 185 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.
177 178 179 180 181 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 177 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.
201 202 203 204 205 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 201 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.
193 194 195 196 197 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 193 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.
328 329 330 331 332 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 328 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.
336 337 338 339 340 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 336 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
2058 2059 2060 2061 2062 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2058 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.
732 733 734 735 736 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 732 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.
748 749 750 751 752 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 748 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.
756 757 758 759 760 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 756 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.
724 725 726 727 728 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 724 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.
740 741 742 743 744 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 740 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
216 217 218 219 220 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 216 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.
224 225 226 227 228 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 224 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.
1151 1152 1153 1154 1155 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1151 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.
423 424 425 426 427 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 423 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.
1095 1096 1097 1098 1099 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1095 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
2116 2117 2118 2119 2120 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2116 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_to_csv(post_convert_workbook_to_csv_request, opts = {}) ⇒ Object
Convert Excel file to Csv files.
922 923 924 925 926 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 922 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.
874 875 876 877 878 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 874 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.
890 891 892 893 894 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 890 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.
906 907 908 909 910 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 906 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.
898 899 900 901 902 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 898 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.
858 859 860 861 862 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 858 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.
866 867 868 869 870 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 866 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.
882 883 884 885 886 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 882 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.
914 915 916 917 918 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 914 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
929 930 931 932 933 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 929 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.
304 305 306 307 308 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 304 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.
2591 2592 2593 2594 2595 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2591 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.
415 416 417 418 419 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 415 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.
518 519 520 521 522 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 518 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.
985 986 987 988 989 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 985 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.
1001 1002 1003 1004 1005 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1001 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.
1017 1018 1019 1020 1021 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1017 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.
1033 1034 1035 1036 1037 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1033 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.
1025 1026 1027 1028 1029 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1025 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
1759 1760 1761 1762 1763 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1759 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.
1767 1768 1769 1770 1771 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1767 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
936 937 938 939 940 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 936 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
2130 2131 2132 2133 2134 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2130 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.
1499 1500 1501 1502 1503 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1499 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.
1491 1492 1493 1494 1495 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1491 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.
1483 1484 1485 1486 1487 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1483 def ( , opts = {}) data, _status_code, _headers = .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.
399 400 401 402 403 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 399 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.
502 503 504 505 506 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 502 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.
1467 1468 1469 1470 1471 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1467 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.
383 384 385 386 387 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 383 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.
486 487 488 489 490 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 486 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.
1135 1136 1137 1138 1139 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1135 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.
969 970 971 972 973 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 969 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.
1823 1824 1825 1826 1827 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1823 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.
1103 1104 1105 1106 1107 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1103 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.
1183 1184 1185 1186 1187 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1183 def ( , opts = {}) data, _status_code, _headers = .create_http_request(@api_client,opts ) return data end |
#post_move_worksheet(post_move_worksheet_request, opts = {}) ⇒ Object
Move worksheet in the workbook.
2399 2400 2401 2402 2403 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2399 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.
1443 1444 1445 1446 1447 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1443 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.
1633 1634 1635 1636 1637 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1633 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.
1617 1618 1619 1620 1621 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1617 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.
1625 1626 1627 1628 1629 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1625 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.
1641 1642 1643 1644 1645 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1641 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.
1657 1658 1659 1660 1661 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1657 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.
1649 1650 1651 1652 1653 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1649 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.
1831 1832 1833 1834 1835 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1831 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.
1783 1784 1785 1786 1787 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1783 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
2109 2110 2111 2112 2113 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2109 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
2123 2124 2125 2126 2127 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2123 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.
2599 2600 2601 2602 2603 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2599 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.
1167 1168 1169 1170 1171 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1167 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.
1127 1128 1129 1130 1131 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1127 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.
1159 1160 1161 1162 1163 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1159 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.
1175 1176 1177 1178 1179 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1175 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.
526 527 528 529 530 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 526 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.
2080 2081 2082 2083 2084 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2080 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.
1119 1120 1121 1122 1123 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1119 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.
320 321 322 323 324 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 320 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.
296 297 298 299 300 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 296 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.
351 352 353 354 355 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 351 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
2072 2073 2074 2075 2076 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2072 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.
1111 1112 1113 1114 1115 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1111 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
2137 2138 2139 2140 2141 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2137 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
2095 2096 2097 2098 2099 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2095 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.
407 408 409 410 411 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 407 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.
510 511 512 513 514 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 510 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.
391 392 393 394 395 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 391 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.
494 495 496 497 498 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 494 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.
1815 1816 1817 1818 1819 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1815 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
2102 2103 2104 2105 2106 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2102 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.
288 289 290 291 292 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 288 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.
1341 1342 1343 1344 1345 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1341 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.
2607 2608 2609 2610 2611 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2607 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.
232 233 234 235 236 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 232 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.
478 479 480 481 482 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 478 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.
2631 2632 2633 2634 2635 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2631 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.
1143 1144 1145 1146 1147 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1143 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
2065 2066 2067 2068 2069 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2065 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.
2264 2265 2266 2267 2268 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2264 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.
977 978 979 980 981 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 977 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.
993 994 995 996 997 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 993 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.
1009 1010 1011 1012 1013 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1009 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.
945 946 947 948 949 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 945 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.
2240 2241 2242 2243 2244 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2240 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.
953 954 955 956 957 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 953 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.
961 962 963 964 965 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 961 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.
2184 2185 2186 2187 2188 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2184 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.
850 851 852 853 854 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 850 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.
2296 2297 2298 2299 2300 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2296 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.
2256 2257 2258 2259 2260 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2256 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.
2232 2233 2234 2235 2236 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2232 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.
2216 2217 2218 2219 2220 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2216 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.
2224 2225 2226 2227 2228 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2224 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.
131 132 133 134 135 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 131 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.
2503 2504 2505 2506 2507 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2503 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.
280 281 282 283 284 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 280 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.
1910 1911 1912 1913 1914 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1910 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.
1846 1847 1848 1849 1850 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1846 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.
1886 1887 1888 1889 1890 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1886 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.
1902 1903 1904 1905 1906 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1902 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.
1918 1919 1920 1921 1922 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1918 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.
1894 1895 1896 1897 1898 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1894 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.
1862 1863 1864 1865 1866 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1862 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
1925 1926 1927 1928 1929 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1925 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.
1854 1855 1856 1857 1858 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1854 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.
1878 1879 1880 1881 1882 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1878 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
1838 1839 1840 1841 1842 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1838 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.
604 605 606 607 608 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 604 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.
620 621 622 623 624 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 620 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.
660 661 662 663 664 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 660 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.
2455 2456 2457 2458 2459 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2455 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.
1996 1997 1998 1999 2000 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1996 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.
1064 1065 1066 1067 1068 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1064 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.
1294 1295 1296 1297 1298 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1294 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.
1302 1303 1304 1305 1306 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1302 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.
1246 1247 1248 1249 1250 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1246 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.
1254 1255 1256 1257 1258 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1254 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.
1286 1287 1288 1289 1290 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1286 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.
1278 1279 1280 1281 1282 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1278 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.
1270 1271 1272 1273 1274 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1270 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.
1262 1263 1264 1265 1266 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1262 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.
115 116 117 118 119 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 115 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.
123 124 125 126 127 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 123 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.
240 241 242 243 244 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 240 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.
1530 1531 1532 1533 1534 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1530 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.
1665 1666 1667 1668 1669 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1665 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.
1673 1674 1675 1676 1677 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1673 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.
2527 2528 2529 2530 2531 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2527 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.
1988 1989 1990 1991 1992 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1988 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.
2051 2052 2053 2054 2055 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2051 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.
2519 2520 2521 2522 2523 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2519 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.
2511 2512 2513 2514 2515 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2511 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.
2004 2005 2006 2007 2008 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2004 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.
248 249 250 251 252 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 248 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.
2670 2671 2672 2673 2674 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2670 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 |
#put_active_worksheet(put_active_worksheet_request, opts = {}) ⇒ Object
Set active worksheet index in the workbook.
2359 2360 2361 2362 2363 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2359 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.
2375 2376 2377 2378 2379 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2375 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.
2351 2352 2353 2354 2355 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2351 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.
842 843 844 845 846 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 842 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.
1728 1729 1730 1731 1732 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1728 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.
1799 1800 1801 1802 1803 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1799 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.
1396 1397 1398 1399 1400 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1396 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.
2367 2368 2369 2370 2371 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2367 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.
367 368 369 370 371 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 367 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.
470 471 472 473 474 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 470 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.
462 463 464 465 466 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 462 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.
1601 1602 1603 1604 1605 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1601 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.
2407 2408 2409 2410 2411 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2407 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.
1388 1389 1390 1391 1392 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1388 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.
2304 2305 2306 2307 2308 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2304 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.
2248 2249 2250 2251 2252 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2248 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.
2168 2169 2170 2171 2172 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2168 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.
2320 2321 2322 2323 2324 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2320 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.
1522 1523 1524 1525 1526 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1522 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.
2559 2560 2561 2562 2563 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2559 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.
1933 1934 1935 1936 1937 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1933 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.
588 589 590 591 592 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 588 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.
628 629 630 631 632 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 628 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.
668 669 670 671 672 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 668 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.
107 108 109 110 111 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 107 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.
2447 2448 2449 2450 2451 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2447 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.
779 780 781 782 783 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 779 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.
83 84 85 86 87 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 83 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.
59 60 61 62 63 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 59 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.
91 92 93 94 95 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 91 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.
67 68 69 70 71 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 67 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.
99 100 101 102 103 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 99 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.
787 788 789 790 791 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 787 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.
795 796 797 798 799 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 795 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.
803 804 805 806 807 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 803 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.
2575 2576 2577 2578 2579 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2575 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.
1072 1073 1074 1075 1076 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1072 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.
75 76 77 78 79 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 75 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.
1222 1223 1224 1225 1226 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1222 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.
1349 1350 1351 1352 1353 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1349 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.
1593 1594 1595 1596 1597 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1593 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.
1609 1610 1611 1612 1613 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1609 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.
1964 1965 1966 1967 1968 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1964 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.
2043 2044 2045 2046 2047 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2043 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.
2662 2663 2664 2665 2666 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2662 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 |
#storage_exists(storage_exists_request, opts = {}) ⇒ Object
2763 2764 2765 2766 2767 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2763 def storage_exists( storage_exists_request, opts = {}) data, _status_code, _headers = storage_exists_request.create_http_request(@api_client,opts ) return data end |
#upload_file(upload_file_request, opts = {}) ⇒ Object
2700 2701 2702 2703 2704 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2700 def upload_file( upload_file_request, opts = {}) data, _status_code, _headers = upload_file_request.create_http_request(@api_client,opts ) return data end |