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
Retrieve chart area description in the worksheet.
-
#get_chart_area_border(get_chart_area_border_request, opts = {}) ⇒ Object
Retrieve chart area border description.
-
#get_chart_area_fill_format(get_chart_area_fill_format_request, opts = {}) ⇒ Object
Retrieve chart area fill format description in the worksheet.
-
#get_chart_category_axis(get_chart_category_axis_request, opts = {}) ⇒ Object
Retrieve descriptions of chart series axis in the chart.
-
#get_chart_second_category_axis(get_chart_second_category_axis_request, opts = {}) ⇒ Object
Retrieve chart second category axis in the chart.
-
#get_chart_second_value_axis(get_chart_second_value_axis_request, opts = {}) ⇒ Object
Retrieve chart second value axis in the chart.
-
#get_chart_series_axis(get_chart_series_axis_request, opts = {}) ⇒ Object
Retrieve descriptions of chart seriesaxis in the chart.
-
#get_chart_value_axis(get_chart_value_axis_request, opts = {}) ⇒ Object
Retrieve chart value axis in the chart.
- #get_disc_usage(get_disc_usage_request, opts = {}) ⇒ Object
-
#get_document_properties(get_document_properties_request, opts = {}) ⇒ Object
Retrieve descriptions of Excel file properties.
-
#get_document_property(get_document_property_request, opts = {}) ⇒ Object
Get Excel property by name.
- #get_file_versions(get_file_versions_request, opts = {}) ⇒ Object
- #get_files_list(get_files_list_request, opts = {}) ⇒ Object
-
#get_footer(get_footer_request, opts = {}) ⇒ Object
Retrieve page footer description in the worksheet.
-
#get_header(get_header_request, opts = {}) ⇒ Object
Retrieve page header description in the worksheet.
-
#get_horizontal_page_break(get_horizontal_page_break_request, opts = {}) ⇒ Object
Retrieve a horizontal page break descripton in the worksheet.
-
#get_horizontal_page_breaks(get_horizontal_page_breaks_request, opts = {}) ⇒ Object
Retrieve descriptions of horizontal page breaks in the worksheet.
-
#get_metadata(get_metadata_request, opts = {}) ⇒ Object
Get cells document properties.
-
#get_named_range_value(get_named_range_value_request, opts = {}) ⇒ Object
Retrieve values in range.
-
#get_named_ranges(get_named_ranges_request, opts = {}) ⇒ Object
Retrieve descriptions of ranges in the worksheets.
-
#get_page_count(get_page_count_request, opts = {}) ⇒ Object
Get page count in the workbook.
-
#get_page_setup(get_page_setup_request, opts = {}) ⇒ Object
Retrieve page setup description in the worksheet.
-
#get_pivot_table_field(get_pivot_table_field_request, opts = {}) ⇒ Object
Retrieve descriptions of pivot fields in the PivotTable.
-
#get_vertical_page_break(get_vertical_page_break_request, opts = {}) ⇒ Object
Retrieve a vertical page break description in the worksheet.
-
#get_vertical_page_breaks(get_vertical_page_breaks_request, opts = {}) ⇒ Object
Retrieve descriptions of vertical page breaks in the worksheet.
-
#get_workbook(get_workbook_request, opts = {}) ⇒ Object
Retrieve workbooks in various formats.
-
#get_workbook_default_style(get_workbook_default_style_request, opts = {}) ⇒ Object
Retrieve the description of the default style for the workbook .
-
#get_workbook_name(get_workbook_name_request, opts = {}) ⇒ Object
Retrieve description of a named range in the workbook.
-
#get_workbook_name_value(get_workbook_name_value_request, opts = {}) ⇒ Object
Retrieve the value of a named range in the workbook.
-
#get_workbook_names(get_workbook_names_request, opts = {}) ⇒ Object
Retrieve named ranges in the workbook.
-
#get_workbook_settings(get_workbook_settings_request, opts = {}) ⇒ Object
Retrieve descriptions of workbook settings.
-
#get_workbook_text_items(get_workbook_text_items_request, opts = {}) ⇒ Object
Retrieve text items in the workbook.
-
#get_worksheet_auto_filter(get_worksheet_auto_filter_request, opts = {}) ⇒ Object
Retrieve the description of auto filters from a worksheet.
-
#get_worksheet_autoshape_with_format(get_worksheet_autoshape_with_format_request, opts = {}) ⇒ Object
Get autoshape description in some format.
-
#get_worksheet_autoshapes(get_worksheet_autoshapes_request, opts = {}) ⇒ Object
Get autoshapes description in worksheet.
-
#get_worksheet_calculate_formula(get_worksheet_calculate_formula_request, opts = {}) ⇒ Object
Calculate formula in the worksheet.
-
#get_worksheet_cell(get_worksheet_cell_request, opts = {}) ⇒ Object
Retrieve cell data using either cell reference or method name in the worksheet.
-
#get_worksheet_cell_style(get_worksheet_cell_style_request, opts = {}) ⇒ Object
Retrieve cell style descriptions in the worksheet.
-
#get_worksheet_cells(get_worksheet_cells_request, opts = {}) ⇒ Object
Retrieve cell descriptions in a specified format.
-
#get_worksheet_cells_range_value(get_worksheet_cells_range_value_request, opts = {}) ⇒ Object
Retrieve the values of cells within the specified range.
-
#get_worksheet_chart(get_worksheet_chart_request, opts = {}) ⇒ Object
Retrieve the chart in a specified format.
-
#get_worksheet_chart_legend(get_worksheet_chart_legend_request, opts = {}) ⇒ Object
Retrieve chart legend description in the worksheet.
-
#get_worksheet_chart_title(get_worksheet_chart_title_request, opts = {}) ⇒ Object
Retrieve chart title description in the worksheet.
-
#get_worksheet_charts(get_worksheet_charts_request, opts = {}) ⇒ Object
Retrieve descriptions of charts in the worksheet.
-
#get_worksheet_column(get_worksheet_column_request, opts = {}) ⇒ Object
Retrieve worksheet column data by column index.
-
#get_worksheet_columns(get_worksheet_columns_request, opts = {}) ⇒ Object
Retrieve descriptions of worksheet columns.
-
#get_worksheet_comment(get_worksheet_comment_request, opts = {}) ⇒ Object
Retrieve the description of comment in the worksheet.
-
#get_worksheet_comments(get_worksheet_comments_request, opts = {}) ⇒ Object
Retrieve the description of comments in the worksheet.
-
#get_worksheet_conditional_formatting(get_worksheet_conditional_formatting_request, opts = {}) ⇒ Object
Retrieve conditional formatting descriptions in the worksheet.
-
#get_worksheet_conditional_formattings(get_worksheet_conditional_formattings_request, opts = {}) ⇒ Object
Retrieve descriptions of conditional formattings in a worksheet.
-
#get_worksheet_hyperlink(get_worksheet_hyperlink_request, opts = {}) ⇒ Object
Retrieve hyperlink description by index in the worksheet.
-
#get_worksheet_hyperlinks(get_worksheet_hyperlinks_request, opts = {}) ⇒ Object
Retrieve descriptions of hyperlinks in the worksheet.
-
#get_worksheet_list_object(get_worksheet_list_object_request, opts = {}) ⇒ Object
Retrieve list object description by index in the worksheet.
-
#get_worksheet_list_objects(get_worksheet_list_objects_request, opts = {}) ⇒ Object
Retrieve descriptions of ListObjects in the worksheet.
-
#get_worksheet_merged_cell(get_worksheet_merged_cell_request, opts = {}) ⇒ Object
Retrieve description of a merged cell by its index in the worksheet.
-
#get_worksheet_merged_cells(get_worksheet_merged_cells_request, opts = {}) ⇒ Object
Get worksheet merged cells.
-
#get_worksheet_ole_object(get_worksheet_ole_object_request, opts = {}) ⇒ Object
Retrieve the OLE object in a specified format in the worksheet.
-
#get_worksheet_ole_objects(get_worksheet_ole_objects_request, opts = {}) ⇒ Object
Retrieve descriptions of OLE objects in the worksheet.
-
#get_worksheet_page_count(get_worksheet_page_count_request, opts = {}) ⇒ Object
Get page count in the worksheet.
-
#get_worksheet_picture_with_format(get_worksheet_picture_with_format_request, opts = {}) ⇒ Object
Retrieve a picture by number in the worksheet.
-
#get_worksheet_pictures(get_worksheet_pictures_request, opts = {}) ⇒ Object
Retrieve descriptions of pictures in the worksheet.
-
#get_worksheet_pivot_table(get_worksheet_pivot_table_request, opts = {}) ⇒ Object
Retrieve PivotTable information by index in the worksheet.
-
#get_worksheet_pivot_table_filter(get_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object
Retrieve PivotTable filters in the worksheet.
-
#get_worksheet_pivot_table_filters(get_worksheet_pivot_table_filters_request, opts = {}) ⇒ Object
Gets PivotTable filters in worksheet.
-
#get_worksheet_pivot_tables(get_worksheet_pivot_tables_request, opts = {}) ⇒ Object
Retrieve descriptions of pivottables in the worksheet.
-
#get_worksheet_row(get_worksheet_row_request, opts = {}) ⇒ Object
Retrieve row data by the row’s index in the worksheet.
-
#get_worksheet_rows(get_worksheet_rows_request, opts = {}) ⇒ Object
Retrieve descriptions of rows in the worksheet.
-
#get_worksheet_shape(get_worksheet_shape_request, opts = {}) ⇒ Object
Retrieve description of shape in the worksheet.
-
#get_worksheet_shapes(get_worksheet_shapes_request, opts = {}) ⇒ Object
Retrieve descriptions of shapes in the worksheet.
-
#get_worksheet_sparkline_group(get_worksheet_sparkline_group_request, opts = {}) ⇒ Object
Retrieve description of a sparkline group in the worksheet.
-
#get_worksheet_sparkline_groups(get_worksheet_sparkline_groups_request, opts = {}) ⇒ Object
Retrieve descriptions of sparkline groups in the worksheet.
-
#get_worksheet_text_items(get_worksheet_text_items_request, opts = {}) ⇒ Object
Retrieve text items in the worksheet.
-
#get_worksheet_validation(get_worksheet_validation_request, opts = {}) ⇒ Object
Retrieve a validation by its index in the worksheet.
-
#get_worksheet_validations(get_worksheet_validations_request, opts = {}) ⇒ Object
Retrieve descriptions of validations in the worksheet.
-
#get_worksheet_with_format(get_worksheet_with_format_request, opts = {}) ⇒ Object
Retrieve the worksheet in a specified format from the workbook.
-
#get_worksheets(get_worksheets_request, opts = {}) ⇒ Object
Retrieve the description of worksheets from a workbook.
-
#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
-
#post_analyze_excel(post_analyze_excel_request, opts = {}) ⇒ Object
Perform business analysis of data in Excel files.
-
#post_assemble(post_assemble_request, opts = {}) ⇒ Object
Assemble data files with template files to generate files in various formats.
-
#post_autofit_workbook_columns(post_autofit_workbook_columns_request, opts = {}) ⇒ Object
Autofit columns in the workbook.
-
#post_autofit_workbook_rows(post_autofit_workbook_rows_request, opts = {}) ⇒ Object
Autofit rows in the workbook.
-
#post_autofit_worksheet_columns(post_autofit_worksheet_columns_request, opts = {}) ⇒ Object
Autofit columns in the worksheet.
-
#post_autofit_worksheet_row(post_autofit_worksheet_row_request, opts = {}) ⇒ Object
Autofit a row in the worksheet.
-
#post_autofit_worksheet_rows(post_autofit_worksheet_rows_request, opts = {}) ⇒ Object
Autofit rows in the worksheet.
-
#post_batch_convert(post_batch_convert_request, opts = {}) ⇒ Object
Batch converting files that meet specific matching conditions.
-
#post_batch_lock(post_batch_lock_request, opts = {}) ⇒ Object
Batch locking files that meet specific matching conditions.
-
#post_batch_protect(post_batch_protect_request, opts = {}) ⇒ Object
Batch protecting files that meet specific matching conditions.
-
#post_batch_split(post_batch_split_request, opts = {}) ⇒ Object
Batch splitting files that meet specific matching conditions.
-
#post_batch_unlock(post_batch_unlock_request, opts = {}) ⇒ Object
Batch unlocking files that meet specific matching conditions.
-
#post_cell_calculate(post_cell_calculate_request, opts = {}) ⇒ Object
Calculate cell formula in the worksheet.
-
#post_cell_characters(post_cell_characters_request, opts = {}) ⇒ Object
Set cell characters in the worksheet.
-
#post_chart_category_axis(post_chart_category_axis_request, opts = {}) ⇒ Object
Update chart category axis in the chart.
-
#post_chart_second_category_axis(post_chart_second_category_axis_request, opts = {}) ⇒ Object
Update chart sencond category axis in the chart.
-
#post_chart_second_value_axis(post_chart_second_value_axis_request, opts = {}) ⇒ Object
Update chart sencond value axis in the chart.
-
#post_chart_series_axis(post_chart_series_axis_request, opts = {}) ⇒ Object
Update chart series axis in the chart.
-
#post_chart_value_axis(post_chart_value_axis_request, opts = {}) ⇒ Object
Update chart value axis in the chart.
-
#post_clear_contents(post_clear_contents_request, opts = {}) ⇒ Object
Clear cell area contents in the worksheet.
-
#post_clear_formats(post_clear_formats_request, opts = {}) ⇒ Object
Clear cell formats in the worksheet.
-
#post_clear_objects(post_clear_objects_request, opts = {}) ⇒ Object
Clear internal elements in Excel files and generate output files in various formats.
-
#post_column_style(post_column_style_request, opts = {}) ⇒ Object
Set column style in the worksheet.
-
#post_compress(post_compress_request, opts = {}) ⇒ Object
Compress files and generate target files in various formats, supported file formats are include Xls, Xlsx, Xlsm, Xlsb, Ods and more.
-
#post_convert_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_copy_cell_into_cell(post_copy_cell_into_cell_request, opts = {}) ⇒ Object
Copy data from a source cell to a destination cell in the worksheet.
-
#post_copy_worksheet(post_copy_worksheet_request, opts = {}) ⇒ Object
Copy contents and formats from another worksheet.
-
#post_copy_worksheet_columns(post_copy_worksheet_columns_request, opts = {}) ⇒ Object
Copy data from source columns to destination columns in the worksheet.
-
#post_copy_worksheet_rows(post_copy_worksheet_rows_request, opts = {}) ⇒ Object
Copy data and formats from specific entire rows in the worksheet.
-
#post_data_cleansing(post_data_cleansing_request, opts = {}) ⇒ Object
Data cleansing of spreadsheet files is a data management process used to identify, correct, and remove errors, incompleteness, duplicates, or inaccuracies in tables and ranges.
-
#post_data_deduplication(post_data_deduplication_request, opts = {}) ⇒ Object
Data deduplication of spreadsheet files is mainly used to eliminate duplicate data in tables and ranges.
-
#post_data_fill(post_data_fill_request, opts = {}) ⇒ Object
Data filling for spreadsheet files is primarily used to fill empty data in tables and ranges.
-
#post_data_transformation(post_data_transformation_request, opts = {}) ⇒ Object
Transform spreadsheet data is mainly used to pivot columns, unpivot columns.
-
#post_delete_incomplete_rows(post_delete_incomplete_rows_request, opts = {}) ⇒ Object
Deleting incomplete rows of spreadsheet files is mainly used to eliminate incomplete rows in tables and ranges.
-
#post_digital_signature(post_digital_signature_request, opts = {}) ⇒ Object
Excel file digital signature.
-
#post_encrypt_workbook(post_encrypt_workbook_request, opts = {}) ⇒ Object
Excel Encryption.
-
#post_export(post_export_request, opts = {}) ⇒ Object
Export Excel internal elements or the workbook itself to various format files.
-
#post_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_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_split(post_split_request, opts = {}) ⇒ Object
Split Excel spreadsheet files based on worksheets and create output files in various formats.
- #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_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_un_merge(post_worksheet_cells_range_un_merge_request, opts = {}) ⇒ Object
Unmerge merged cells within this range.
-
#post_worksheet_cells_range_value(post_worksheet_cells_range_value_request, opts = {}) ⇒ Object
Assign a value to the range; if necessary, the value will be converted to another data type, and the cell’s number format will be reset.
-
#post_worksheet_cells_ranges_copy(post_worksheet_cells_ranges_copy_request, opts = {}) ⇒ Object
Copy content from the source range to the destination range in the worksheet.
-
#post_worksheet_chart(post_worksheet_chart_request, opts = {}) ⇒ Object
Update chart properties in the worksheet.
-
#post_worksheet_chart_legend(post_worksheet_chart_legend_request, opts = {}) ⇒ Object
Update chart legend in the worksheet.
-
#post_worksheet_chart_title(post_worksheet_chart_title_request, opts = {}) ⇒ Object
Update chart title in the worksheet.
-
#post_worksheet_comment(post_worksheet_comment_request, opts = {}) ⇒ Object
Update cell comment in the worksheet.
-
#post_worksheet_group_shape(post_worksheet_group_shape_request, opts = {}) ⇒ Object
Group shapes in the worksheet.
-
#post_worksheet_hyperlink(post_worksheet_hyperlink_request, opts = {}) ⇒ Object
Update hyperlink by index in the worksheet.
-
#post_worksheet_list_column(post_worksheet_list_column_request, opts = {}) ⇒ Object
Update list column in list object.
-
#post_worksheet_list_columns_total(post_worksheet_list_columns_total_request, opts = {}) ⇒ Object
Update total of list columns in the table.
-
#post_worksheet_list_object(post_worksheet_list_object_request, opts = {}) ⇒ Object
Update list object by index in the worksheet.
-
#post_worksheet_list_object_convert_to_range(post_worksheet_list_object_convert_to_range_request, opts = {}) ⇒ Object
Convert list object to range in the worksheet.
-
#post_worksheet_list_object_insert_slicer(post_worksheet_list_object_insert_slicer_request, opts = {}) ⇒ Object
Insert slicer for list object.
-
#post_worksheet_list_object_remove_duplicates(post_worksheet_list_object_remove_duplicates_request, opts = {}) ⇒ Object
Remove duplicates in list object.
-
#post_worksheet_list_object_sort_table(post_worksheet_list_object_sort_table_request, opts = {}) ⇒ Object
Sort list object in the worksheet.
-
#post_worksheet_list_object_summarize_with_pivot_table(post_worksheet_list_object_summarize_with_pivot_table_request, opts = {}) ⇒ Object
Create a pivot table with a list object in the worksheet.
-
#post_worksheet_match_blanks(post_worksheet_match_blanks_request, opts = {}) ⇒ Object
Match all blank cells in the list.
-
#post_worksheet_match_non_blanks(post_worksheet_match_non_blanks_request, opts = {}) ⇒ Object
Match all not blank cells in the list.
-
#post_worksheet_merge(post_worksheet_merge_request, opts = {}) ⇒ Object
Merge cells in the worksheet.
-
#post_worksheet_picture(post_worksheet_picture_request, opts = {}) ⇒ Object
Update a picture by index in the worksheet.
-
#post_worksheet_pivot_table_calculate(post_worksheet_pivot_table_calculate_request, opts = {}) ⇒ Object
Calculate pivottable’s data to cells.
-
#post_worksheet_pivot_table_move(post_worksheet_pivot_table_move_request, opts = {}) ⇒ Object
Move PivotTable in the worksheet.
-
#post_worksheet_range_sort(post_worksheet_range_sort_request, opts = {}) ⇒ Object
Sort a range in the worksheet.
-
#post_worksheet_shape(post_worksheet_shape_request, opts = {}) ⇒ Object
Update a shape in the worksheet.
-
#post_worksheet_sparkline_group(post_worksheet_sparkline_group_request, opts = {}) ⇒ Object
Update a sparkline group in the worksheet.
-
#post_worksheet_text_replace(post_worksheet_text_replace_request, opts = {}) ⇒ Object
Replace old text with new text in the worksheet.
-
#post_worksheet_text_search(post_worksheet_text_search_request, opts = {}) ⇒ Object
Search for text in the worksheet.
-
#post_worksheet_ungroup_shape(post_worksheet_ungroup_shape_request, opts = {}) ⇒ Object
Ungroup shapes in the worksheet.
-
#post_worksheet_unmerge(post_worksheet_unmerge_request, opts = {}) ⇒ Object
Unmerge cells in the worksheet.
-
#post_worksheet_validation(post_worksheet_validation_request, opts = {}) ⇒ Object
Update a validation by index in the worksheet.
-
#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
2671 2672 2673 2674 2675 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2671 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
2706 2707 2708 2709 2710 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2706 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
2699 2700 2701 2702 2703 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2699 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.
1790 1791 1792 1793 1794 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1790 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.
1766 1767 1768 1769 1770 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1766 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.
1758 1759 1760 1761 1762 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1758 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.
1822 1823 1824 1825 1826 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1822 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
2685 2686 2687 2688 2689 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2685 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
2720 2721 2722 2723 2724 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2720 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.
1462 1463 1464 1465 1466 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1462 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.
1438 1439 1440 1441 1442 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1438 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.
1422 1423 1424 1425 1426 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1422 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.
1206 1207 1208 1209 1210 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1206 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.
1710 1711 1712 1713 1714 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1710 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.
1806 1807 1808 1809 1810 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1806 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.
2378 2379 2380 2381 2382 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2378 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.
1430 1431 1432 1433 1434 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1430 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.
1414 1415 1416 1417 1418 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1414 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.
2274 2275 2276 2277 2278 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2274 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.
2170 2171 2172 2173 2174 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2170 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.
2162 2163 2164 2165 2166 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2162 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.
2346 2347 2348 2349 2350 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2346 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.
2530 2531 2532 2533 2534 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2530 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.
1950 1951 1952 1953 1954 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1950 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.
605 606 607 608 609 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 605 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.
645 646 647 648 649 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 645 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.
685 686 687 688 689 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 685 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.
653 654 655 656 657 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 653 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.
381 382 383 384 385 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 381 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.
2426 2427 2428 2429 2430 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2426 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.
2434 2435 2436 2437 2438 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2434 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.
829 830 831 832 833 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 829 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.
837 838 839 840 841 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 837 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.
821 822 823 824 825 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 821 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.
141 142 143 144 145 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 141 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.
149 150 151 152 153 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 149 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.
2546 2547 2548 2549 2550 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2546 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.
1062 1063 1064 1065 1066 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1062 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.
1086 1087 1088 1089 1090 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1086 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.
1246 1247 1248 1249 1250 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1246 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.
1238 1239 1240 1241 1242 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1238 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.
1342 1343 1344 1345 1346 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1342 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.
1334 1335 1336 1337 1338 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1334 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.
1550 1551 1552 1553 1554 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1550 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.
1558 1559 1560 1561 1562 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1558 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.
1702 1703 1704 1705 1706 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1702 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.
1726 1727 1728 1729 1730 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1726 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.
1718 1719 1720 1721 1722 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1718 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.
1694 1695 1696 1697 1698 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1694 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.
453 454 455 456 457 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 453 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.
461 462 463 464 465 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 461 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.
1990 1991 1992 1993 1994 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1990 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.
1982 1983 1984 1985 1986 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1982 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.
2046 2047 2048 2049 2050 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2046 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.
2038 2039 2040 2041 2042 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2038 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.
2642 2643 2644 2645 2646 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2642 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.
2650 2651 2652 2653 2654 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2650 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.
2354 2355 2356 2357 2358 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2354 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
2657 2658 2659 2660 2661 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2657 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.
317 318 319 320 321 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 317 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.
549 550 551 552 553 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 549 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.
541 542 543 544 545 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 541 def get_cells_cloud_services_health_check( get_cells_cloud_services_health_check_request, opts = {}) data, _status_code, _headers = get_cells_cloud_services_health_check_request.create_http_request(@api_client,opts ) return data end |
#get_chart_area(get_chart_area_request, opts = {}) ⇒ Object
Retrieve chart area description in the worksheet.
557 558 559 560 561 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 557 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.
573 574 575 576 577 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 573 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.
565 566 567 568 569 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 565 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.
701 702 703 704 705 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 701 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
717 718 719 720 721 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 717 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.
725 726 727 728 729 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 725 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.
693 694 695 696 697 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 693 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.
709 710 711 712 713 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 709 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
2741 2742 2743 2744 2745 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2741 def get_disc_usage( get_disc_usage_request, opts = {}) data, _status_code, _headers = get_disc_usage_request.create_http_request(@api_client,opts ) return data end |
#get_document_properties(get_document_properties_request, opts = {}) ⇒ Object
Retrieve descriptions of Excel file properties.
1734 1735 1736 1737 1738 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1734 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.
1750 1751 1752 1753 1754 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1750 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
2748 2749 2750 2751 2752 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2748 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
2692 2693 2694 2695 2696 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2692 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.
1486 1487 1488 1489 1490 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1486 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.
1470 1471 1472 1473 1474 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1470 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.
1390 1391 1392 1393 1394 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1390 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.
1374 1375 1376 1377 1378 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1374 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.
1198 1199 1200 1201 1202 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1198 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.
2586 2587 2588 2589 2590 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2586 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.
2578 2579 2580 2581 2582 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2578 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.
2290 2291 2292 2293 2294 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2290 def get_page_count( get_page_count_request, opts = {}) data, _status_code, _headers = get_page_count_request.create_http_request(@api_client,opts ) return data end |
#get_page_setup(get_page_setup_request, opts = {}) ⇒ Object
Retrieve page setup description in the worksheet.
1446 1447 1448 1449 1450 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1446 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.
1582 1583 1584 1585 1586 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1582 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.
1382 1383 1384 1385 1386 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1382 def get_vertical_page_break( get_vertical_page_break_request, opts = {}) data, _status_code, _headers = get_vertical_page_break_request.create_http_request(@api_client,opts ) return data end |
#get_vertical_page_breaks(get_vertical_page_breaks_request, opts = {}) ⇒ Object
Retrieve descriptions of vertical page breaks in the worksheet.
1366 1367 1368 1369 1370 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1366 def get_vertical_page_breaks( get_vertical_page_breaks_request, opts = {}) data, _status_code, _headers = get_vertical_page_breaks_request.create_http_request(@api_client,opts ) return data end |
#get_workbook(get_workbook_request, opts = {}) ⇒ Object
Retrieve workbooks in various formats.
845 846 847 848 849 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 845 def get_workbook( get_workbook_request, opts = {}) data, _status_code, _headers = get_workbook_request.create_http_request(@api_client,opts ) return data end |
#get_workbook_default_style(get_workbook_default_style_request, opts = {}) ⇒ Object
Retrieve the description of the default style for the workbook .
2106 2107 2108 2109 2110 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2106 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.
2138 2139 2140 2141 2142 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2138 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.
2154 2155 2156 2157 2158 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2154 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.
2122 2123 2124 2125 2126 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2122 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.
2250 2251 2252 2253 2254 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2250 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.
2114 2115 2116 2117 2118 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2114 def get_workbook_text_items( get_workbook_text_items_request, opts = {}) data, _status_code, _headers = get_workbook_text_items_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_auto_filter(get_worksheet_auto_filter_request, opts = {}) ⇒ Object
Retrieve the description of auto filters from a worksheet.
53 54 55 56 57 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 53 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.
165 166 167 168 169 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 165 def get_worksheet_autoshape_with_format( get_worksheet_autoshape_with_format_request, opts = {}) data, _status_code, _headers = get_worksheet_autoshape_with_format_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_autoshapes(get_worksheet_autoshapes_request, opts = {}) ⇒ Object
Get autoshapes description in worksheet.
157 158 159 160 161 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 157 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.
2458 2459 2460 2461 2462 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2458 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.
269 270 271 272 273 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 269 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.
277 278 279 280 281 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 277 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.
261 262 263 264 265 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 261 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.
1886 1887 1888 1889 1890 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1886 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.
589 590 591 592 593 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 589 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.
621 622 623 624 625 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 621 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.
661 662 663 664 665 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 661 def get_worksheet_chart_title( get_worksheet_chart_title_request, opts = {}) data, _status_code, _headers = get_worksheet_chart_title_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_charts(get_worksheet_charts_request, opts = {}) ⇒ Object
Retrieve descriptions of charts in the worksheet.
581 582 583 584 585 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 581 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.
365 366 367 368 369 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 365 def get_worksheet_column( get_worksheet_column_request, opts = {}) data, _status_code, _headers = get_worksheet_column_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_columns(get_worksheet_columns_request, opts = {}) ⇒ Object
Retrieve descriptions of worksheet columns.
349 350 351 352 353 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 349 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.
2402 2403 2404 2405 2406 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2402 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.
2394 2395 2396 2397 2398 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2394 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.
781 782 783 784 785 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 781 def get_worksheet_conditional_formatting( get_worksheet_conditional_formatting_request, opts = {}) data, _status_code, _headers = get_worksheet_conditional_formatting_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_conditional_formattings(get_worksheet_conditional_formattings_request, opts = {}) ⇒ Object
Retrieve descriptions of conditional formattings in a worksheet.
773 774 775 776 777 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 773 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.
1054 1055 1056 1057 1058 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1054 def get_worksheet_hyperlink( get_worksheet_hyperlink_request, opts = {}) data, _status_code, _headers = get_worksheet_hyperlink_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_hyperlinks(get_worksheet_hyperlinks_request, opts = {}) ⇒ Object
Retrieve descriptions of hyperlinks in the worksheet.
1046 1047 1048 1049 1050 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1046 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.
1222 1223 1224 1225 1226 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1222 def get_worksheet_list_object( get_worksheet_list_object_request, opts = {}) data, _status_code, _headers = get_worksheet_list_object_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_list_objects(get_worksheet_list_objects_request, opts = {}) ⇒ Object
Retrieve descriptions of ListObjects in the worksheet.
1214 1215 1216 1217 1218 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1214 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.
2450 2451 2452 2453 2454 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2450 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.
2442 2443 2444 2445 2446 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2442 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.
1326 1327 1328 1329 1330 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1326 def get_worksheet_ole_object( get_worksheet_ole_object_request, opts = {}) data, _status_code, _headers = get_worksheet_ole_object_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_ole_objects(get_worksheet_ole_objects_request, opts = {}) ⇒ Object
Retrieve descriptions of OLE objects in the worksheet.
1318 1319 1320 1321 1322 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1318 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.
2602 2603 2604 2605 2606 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2602 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.
1526 1527 1528 1529 1530 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1526 def get_worksheet_picture_with_format( get_worksheet_picture_with_format_request, opts = {}) data, _status_code, _headers = get_worksheet_picture_with_format_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_pictures(get_worksheet_pictures_request, opts = {}) ⇒ Object
Retrieve descriptions of pictures in the worksheet.
1518 1519 1520 1521 1522 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1518 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.
1574 1575 1576 1577 1578 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1574 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.
1598 1599 1600 1601 1602 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1598 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.
1590 1591 1592 1593 1594 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1590 def get_worksheet_pivot_table_filters( get_worksheet_pivot_table_filters_request, opts = {}) data, _status_code, _headers = get_worksheet_pivot_table_filters_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_pivot_tables(get_worksheet_pivot_tables_request, opts = {}) ⇒ Object
Retrieve descriptions of pivottables in the worksheet.
1566 1567 1568 1569 1570 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1566 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.
445 446 447 448 449 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 445 def get_worksheet_row( get_worksheet_row_request, opts = {}) data, _status_code, _headers = get_worksheet_row_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_rows(get_worksheet_rows_request, opts = {}) ⇒ Object
Retrieve descriptions of rows in the worksheet.
437 438 439 440 441 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 437 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.
1966 1967 1968 1969 1970 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1966 def get_worksheet_shape( get_worksheet_shape_request, opts = {}) data, _status_code, _headers = get_worksheet_shape_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_shapes(get_worksheet_shapes_request, opts = {}) ⇒ Object
Retrieve descriptions of shapes in the worksheet.
1958 1959 1960 1961 1962 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1958 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.
2030 2031 2032 2033 2034 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2030 def get_worksheet_sparkline_group( get_worksheet_sparkline_group_request, opts = {}) data, _status_code, _headers = get_worksheet_sparkline_group_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_sparkline_groups(get_worksheet_sparkline_groups_request, opts = {}) ⇒ Object
Retrieve descriptions of sparkline groups in the worksheet.
2022 2023 2024 2025 2026 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2022 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.
2386 2387 2388 2389 2390 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2386 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.
2618 2619 2620 2621 2622 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2618 def get_worksheet_validation( get_worksheet_validation_request, opts = {}) data, _status_code, _headers = get_worksheet_validation_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_validations(get_worksheet_validations_request, opts = {}) ⇒ Object
Retrieve descriptions of validations in the worksheet.
2610 2611 2612 2613 2614 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2610 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.
2306 2307 2308 2309 2310 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2306 def get_worksheet_with_format( get_worksheet_with_format_request, opts = {}) data, _status_code, _headers = get_worksheet_with_format_request.create_http_request(@api_client,opts ) return data end |
#get_worksheets(get_worksheets_request, opts = {}) ⇒ Object
Retrieve the description of worksheets from a workbook.
2298 2299 2300 2301 2302 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2298 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
2678 2679 2680 2681 2682 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2678 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
2713 2714 2715 2716 2717 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2713 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
2734 2735 2736 2737 2738 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2734 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
213 214 215 216 217 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 213 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
2077 2078 2079 2080 2081 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2077 def post_add_text_content( post_add_text_content_request, opts = {}) data, _status_code, _headers = post_add_text_content_request.create_http_request(@api_client,opts ) return data end |
#post_analyze_excel(post_analyze_excel_request, opts = {}) ⇒ Object
Perform business analysis of data in Excel files.
45 46 47 48 49 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 45 def post_analyze_excel( post_analyze_excel_request, opts = {}) data, _status_code, _headers = post_analyze_excel_request.create_http_request(@api_client,opts ) return data end |
#post_assemble(post_assemble_request, opts = {}) ⇒ Object
Assemble data files with template files to generate files in various formats.
1094 1095 1096 1097 1098 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1094 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.
2242 2243 2244 2245 2246 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2242 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.
2234 2235 2236 2237 2238 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2234 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.
2514 2515 2516 2517 2518 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2514 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.
2498 2499 2500 2501 2502 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2498 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.
2506 2507 2508 2509 2510 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2506 def post_autofit_worksheet_rows( post_autofit_worksheet_rows_request, opts = {}) data, _status_code, _headers = post_autofit_worksheet_rows_request.create_http_request(@api_client,opts ) return data end |
#post_batch_convert(post_batch_convert_request, opts = {}) ⇒ Object
Batch converting files that meet specific matching conditions.
173 174 175 176 177 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 173 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.
189 190 191 192 193 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 189 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.
181 182 183 184 185 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 181 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.
205 206 207 208 209 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 205 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.
197 198 199 200 201 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 197 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.
333 334 335 336 337 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 333 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.
341 342 343 344 345 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 341 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_chart_category_axis(post_chart_category_axis_request, opts = {}) ⇒ Object
Update chart category axis in the chart.
741 742 743 744 745 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 741 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.
757 758 759 760 761 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 757 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.
765 766 767 768 769 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 765 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.
733 734 735 736 737 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 733 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.
749 750 751 752 753 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 749 def post_chart_value_axis( post_chart_value_axis_request, opts = {}) data, _status_code, _headers = post_chart_value_axis_request.create_http_request(@api_client,opts ) return data end |
#post_clear_contents(post_clear_contents_request, opts = {}) ⇒ Object
Clear cell area contents in the worksheet.
221 222 223 224 225 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 221 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.
229 230 231 232 233 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 229 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.
1158 1159 1160 1161 1162 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1158 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.
429 430 431 432 433 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 429 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.
1102 1103 1104 1105 1106 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1102 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_workbook_to_csv(post_convert_workbook_to_csv_request, opts = {}) ⇒ Object
Convert Excel file to Csv files.
933 934 935 936 937 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 933 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.
885 886 887 888 889 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 885 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.
901 902 903 904 905 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 901 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.
917 918 919 920 921 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 917 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.
909 910 911 912 913 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 909 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.
869 870 871 872 873 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 869 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.
877 878 879 880 881 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 877 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.
893 894 895 896 897 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 893 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.
925 926 927 928 929 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 925 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_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.
309 310 311 312 313 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 309 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.
2554 2555 2556 2557 2558 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2554 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.
421 422 423 424 425 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 421 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.
525 526 527 528 529 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 525 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.
990 991 992 993 994 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 990 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.
1006 1007 1008 1009 1010 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1006 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.
1022 1023 1024 1025 1026 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1022 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.
1038 1039 1040 1041 1042 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1038 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.
1030 1031 1032 1033 1034 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1030 def post_delete_incomplete_rows( post_delete_incomplete_rows_request, opts = {}) data, _status_code, _headers = post_delete_incomplete_rows_request.create_http_request(@api_client,opts ) return data end |
#post_digital_signature(post_digital_signature_request, opts = {}) ⇒ Object
Excel file digital signature.
1774 1775 1776 1777 1778 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1774 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.
1782 1783 1784 1785 1786 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1782 def post_encrypt_workbook( post_encrypt_workbook_request, opts = {}) data, _status_code, _headers = post_encrypt_workbook_request.create_http_request(@api_client,opts ) return data end |
#post_export(post_export_request, opts = {}) ⇒ Object
Export Excel internal elements or the workbook itself to various format files.
941 942 943 944 945 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 941 def post_export( post_export_request, opts = {}) data, _status_code, _headers = post_export_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.
1510 1511 1512 1513 1514 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1510 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.
1502 1503 1504 1505 1506 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1502 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.
1494 1495 1496 1497 1498 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1494 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.
405 406 407 408 409 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 405 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.
509 510 511 512 513 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 509 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.
1478 1479 1480 1481 1482 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1478 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.
389 390 391 392 393 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 389 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.
493 494 495 496 497 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 493 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.
1142 1143 1144 1145 1146 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1142 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.
974 975 976 977 978 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 974 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.
1838 1839 1840 1841 1842 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1838 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.
1110 1111 1112 1113 1114 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1110 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.
1190 1191 1192 1193 1194 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1190 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.
2362 2363 2364 2365 2366 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2362 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.
1454 1455 1456 1457 1458 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1454 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.
1646 1647 1648 1649 1650 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1646 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.
1630 1631 1632 1633 1634 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1630 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.
1638 1639 1640 1641 1642 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1638 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.
1654 1655 1656 1657 1658 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1654 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.
1670 1671 1672 1673 1674 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1670 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.
1662 1663 1664 1665 1666 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1662 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.
1846 1847 1848 1849 1850 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1846 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.
1798 1799 1800 1801 1802 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1798 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
2098 2099 2100 2101 2102 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2098 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_rename_worksheet(post_rename_worksheet_request, opts = {}) ⇒ Object
Rename worksheet in the workbook.
2562 2563 2564 2565 2566 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2562 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.
1174 1175 1176 1177 1178 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1174 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.
1134 1135 1136 1137 1138 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1134 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.
1166 1167 1168 1169 1170 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1166 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.
1182 1183 1184 1185 1186 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1182 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.
533 534 535 536 537 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 533 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.
2070 2071 2072 2073 2074 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2070 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.
1126 1127 1128 1129 1130 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1126 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.
325 326 327 328 329 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 325 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.
301 302 303 304 305 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 301 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.
357 358 359 360 361 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 357 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_split(post_split_request, opts = {}) ⇒ Object
Split Excel spreadsheet files based on worksheets and create output files in various formats.
1118 1119 1120 1121 1122 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1118 def post_split( post_split_request, opts = {}) data, _status_code, _headers = post_split_request.create_http_request(@api_client,opts ) return data end |
#post_trim_content(post_trim_content_request, opts = {}) ⇒ Object
2084 2085 2086 2087 2088 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2084 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.
413 414 415 416 417 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 413 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.
517 518 519 520 521 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 517 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.
397 398 399 400 401 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 397 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.
501 502 503 504 505 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 501 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.
1830 1831 1832 1833 1834 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1830 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
2091 2092 2093 2094 2095 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2091 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.
293 294 295 296 297 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 293 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.
1350 1351 1352 1353 1354 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1350 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.
2570 2571 2572 2573 2574 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2570 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.
237 238 239 240 241 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 237 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.
485 486 487 488 489 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 485 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.
2594 2595 2596 2597 2598 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2594 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.
1150 1151 1152 1153 1154 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1150 def post_watermark( post_watermark_request, opts = {}) data, _status_code, _headers = post_watermark_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.
2226 2227 2228 2229 2230 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2226 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.
982 983 984 985 986 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 982 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.
998 999 1000 1001 1002 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 998 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.
1014 1015 1016 1017 1018 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1014 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.
950 951 952 953 954 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 950 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.
2202 2203 2204 2205 2206 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2202 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.
958 959 960 961 962 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 958 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.
966 967 968 969 970 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 966 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.
2146 2147 2148 2149 2150 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2146 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.
861 862 863 864 865 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 861 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.
2258 2259 2260 2261 2262 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2258 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.
2218 2219 2220 2221 2222 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2218 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.
2194 2195 2196 2197 2198 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2194 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.
2178 2179 2180 2181 2182 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2178 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.
2186 2187 2188 2189 2190 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2186 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.
133 134 135 136 137 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 133 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.
2466 2467 2468 2469 2470 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2466 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.
285 286 287 288 289 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 285 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.
1926 1927 1928 1929 1930 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1926 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.
1862 1863 1864 1865 1866 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1862 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.
1902 1903 1904 1905 1906 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1902 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.
1918 1919 1920 1921 1922 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1918 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.
1934 1935 1936 1937 1938 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1934 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.
1910 1911 1912 1913 1914 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1910 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.
1878 1879 1880 1881 1882 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1878 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_un_merge(post_worksheet_cells_range_un_merge_request, opts = {}) ⇒ Object
Unmerge merged cells within this range.
1870 1871 1872 1873 1874 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1870 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.
1894 1895 1896 1897 1898 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1894 def post_worksheet_cells_range_value( post_worksheet_cells_range_value_request, opts = {}) data, _status_code, _headers = post_worksheet_cells_range_value_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_cells_ranges_copy(post_worksheet_cells_ranges_copy_request, opts = {}) ⇒ Object
Copy content from the source range to the destination range in the worksheet.
1854 1855 1856 1857 1858 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1854 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.
613 614 615 616 617 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 613 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.
629 630 631 632 633 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 629 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.
669 670 671 672 673 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 669 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.
2418 2419 2420 2421 2422 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2418 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.
2006 2007 2008 2009 2010 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2006 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.
1070 1071 1072 1073 1074 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1070 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.
1302 1303 1304 1305 1306 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1302 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.
1310 1311 1312 1313 1314 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1310 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.
1254 1255 1256 1257 1258 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1254 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.
1262 1263 1264 1265 1266 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1262 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.
1294 1295 1296 1297 1298 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1294 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.
1286 1287 1288 1289 1290 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1286 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.
1278 1279 1280 1281 1282 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1278 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.
1270 1271 1272 1273 1274 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1270 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.
117 118 119 120 121 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 117 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.
125 126 127 128 129 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 125 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.
245 246 247 248 249 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 245 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.
1542 1543 1544 1545 1546 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1542 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.
1678 1679 1680 1681 1682 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1678 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.
1686 1687 1688 1689 1690 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1686 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.
2490 2491 2492 2493 2494 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2490 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.
1998 1999 2000 2001 2002 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1998 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.
2062 2063 2064 2065 2066 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2062 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.
2482 2483 2484 2485 2486 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2482 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.
2474 2475 2476 2477 2478 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2474 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.
2014 2015 2016 2017 2018 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2014 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.
253 254 255 256 257 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 253 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.
2634 2635 2636 2637 2638 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2634 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.
2322 2323 2324 2325 2326 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2322 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.
2338 2339 2340 2341 2342 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2338 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.
2314 2315 2316 2317 2318 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2314 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.
853 854 855 856 857 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 853 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.
1742 1743 1744 1745 1746 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1742 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.
1814 1815 1816 1817 1818 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1814 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.
1406 1407 1408 1409 1410 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1406 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.
2330 2331 2332 2333 2334 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2330 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.
373 374 375 376 377 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 373 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.
477 478 479 480 481 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 477 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.
469 470 471 472 473 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 469 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.
1614 1615 1616 1617 1618 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1614 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.
2370 2371 2372 2373 2374 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2370 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.
1398 1399 1400 1401 1402 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1398 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.
2266 2267 2268 2269 2270 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2266 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.
2210 2211 2212 2213 2214 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2210 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.
2130 2131 2132 2133 2134 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2130 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.
2282 2283 2284 2285 2286 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2282 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.
1534 1535 1536 1537 1538 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1534 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.
2522 2523 2524 2525 2526 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2522 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.
1942 1943 1944 1945 1946 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1942 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.
597 598 599 600 601 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 597 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.
637 638 639 640 641 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 637 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.
677 678 679 680 681 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 677 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.
109 110 111 112 113 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 109 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.
2410 2411 2412 2413 2414 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2410 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.
789 790 791 792 793 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 789 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.
85 86 87 88 89 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 85 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.
61 62 63 64 65 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 61 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.
93 94 95 96 97 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 93 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.
69 70 71 72 73 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 69 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.
101 102 103 104 105 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 101 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.
797 798 799 800 801 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 797 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.
805 806 807 808 809 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 805 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.
813 814 815 816 817 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 813 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.
2538 2539 2540 2541 2542 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2538 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.
1078 1079 1080 1081 1082 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1078 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.
77 78 79 80 81 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 77 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.
1230 1231 1232 1233 1234 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1230 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.
1358 1359 1360 1361 1362 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1358 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.
1606 1607 1608 1609 1610 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1606 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.
1622 1623 1624 1625 1626 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1622 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.
1974 1975 1976 1977 1978 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1974 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.
2054 2055 2056 2057 2058 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2054 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.
2626 2627 2628 2629 2630 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2626 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
2727 2728 2729 2730 2731 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2727 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
2664 2665 2666 2667 2668 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2664 def upload_file( upload_file_request, opts = {}) data, _status_code, _headers = upload_file_request.create_http_request(@api_client,opts ) return data end |