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 clean built-in ones.
-
#delete_document_property(delete_document_property_request, opts = {}) ⇒ Object
Deletes a document 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
Clears header footer in worksheet.
-
#delete_horizontal_page_break(delete_horizontal_page_break_request, opts = {}) ⇒ Object
Delete a horizontal page breaks in worksheet.
-
#delete_horizontal_page_breaks(delete_horizontal_page_breaks_request, opts = {}) ⇒ Object
Delete horizontal page breaks in 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
Deletes pivot field in pivot table.
-
#delete_un_protect_workbook(delete_un_protect_workbook_request, opts = {}) ⇒ Object
Excel unprotection.
-
#delete_unprotect_worksheet(delete_unprotect_worksheet_request, opts = {}) ⇒ Object
Unprotects worksheet.
-
#delete_vertical_page_break(delete_vertical_page_break_request, opts = {}) ⇒ Object
Delete a vertical page breaks in worksheet.
-
#delete_vertical_page_breaks(delete_vertical_page_breaks_request, opts = {}) ⇒ Object
Delete vertical page breaks in worksheet.
-
#delete_workbook_background(delete_workbook_background_request, opts = {}) ⇒ Object
Delete workbook background.
-
#delete_workbook_name(delete_workbook_name_request, opts = {}) ⇒ Object
Gets workbook’s name description.
-
#delete_workbook_names(delete_workbook_names_request, opts = {}) ⇒ Object
Delete workbook’s names.
-
#delete_worksheet(delete_worksheet_request, opts = {}) ⇒ Object
Deletes a worksheet in workbook.
-
#delete_worksheet_background(delete_worksheet_background_request, opts = {}) ⇒ Object
Delete background image in worksheet.
-
#delete_worksheet_cells_range(delete_worksheet_cells_range_request, opts = {}) ⇒ Object
Deletes a range of cells and shift cells according to the shift option.
-
#delete_worksheet_chart_legend(delete_worksheet_chart_legend_request, opts = {}) ⇒ Object
Hides chart legend in worksheet.
-
#delete_worksheet_chart_title(delete_worksheet_chart_title_request, opts = {}) ⇒ Object
Hides chart title in worksheet.
-
#delete_worksheet_clear_charts(delete_worksheet_clear_charts_request, opts = {}) ⇒ Object
Clear the charts in worksheets.
-
#delete_worksheet_columns(delete_worksheet_columns_request, opts = {}) ⇒ Object
Delete worksheet columns.
-
#delete_worksheet_comment(delete_worksheet_comment_request, opts = {}) ⇒ Object
Deletes cell comment in worksheet.
-
#delete_worksheet_comments(delete_worksheet_comments_request, opts = {}) ⇒ Object
Delete all comments in 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
Removes cell area from conditional formatting.
-
#delete_worksheet_conditional_formattings(delete_worksheet_conditional_formattings_request, opts = {}) ⇒ Object
Clear all condition formattings.
-
#delete_worksheet_date_filter(delete_worksheet_date_filter_request, opts = {}) ⇒ Object
Remove a date filter in the worksheet.
-
#delete_worksheet_delete_chart(delete_worksheet_delete_chart_request, opts = {}) ⇒ Object
Delete a chart by index 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
Unfreezes panes in worksheet.
-
#delete_worksheet_hyperlink(delete_worksheet_hyperlink_request, opts = {}) ⇒ Object
Deletes hyperlink by index in worksheet.
-
#delete_worksheet_hyperlinks(delete_worksheet_hyperlinks_request, opts = {}) ⇒ Object
Delete all hyperlinks in worksheet.
-
#delete_worksheet_list_object(delete_worksheet_list_object_request, opts = {}) ⇒ Object
Deletes list object by index in worksheet.
-
#delete_worksheet_list_objects(delete_worksheet_list_objects_request, opts = {}) ⇒ Object
Delete worksheet list objects in worksheet.
-
#delete_worksheet_ole_object(delete_worksheet_ole_object_request, opts = {}) ⇒ Object
Deletes an OLE object in worksheet.
-
#delete_worksheet_ole_objects(delete_worksheet_ole_objects_request, opts = {}) ⇒ Object
Delete all OLE objects in worksheet.
-
#delete_worksheet_picture(delete_worksheet_picture_request, opts = {}) ⇒ Object
Deletes a picture object in worksheet.
-
#delete_worksheet_pictures(delete_worksheet_pictures_request, opts = {}) ⇒ Object
Delete all pictures in worksheet.
-
#delete_worksheet_pivot_table(delete_worksheet_pivot_table_request, opts = {}) ⇒ Object
Deletes pivot table by index in worksheet.
-
#delete_worksheet_pivot_table_filter(delete_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object
Deletes a pivot filter in piovt table.
-
#delete_worksheet_pivot_table_filters(delete_worksheet_pivot_table_filters_request, opts = {}) ⇒ Object
Delete all pivot filters in piovt table.
-
#delete_worksheet_pivot_tables(delete_worksheet_pivot_tables_request, opts = {}) ⇒ Object
Delete pivot tables in worksheet.
-
#delete_worksheet_row(delete_worksheet_row_request, opts = {}) ⇒ Object
Deletes row in worksheet.
-
#delete_worksheet_rows(delete_worksheet_rows_request, opts = {}) ⇒ Object
Delete several rows in worksheet.
-
#delete_worksheet_shape(delete_worksheet_shape_request, opts = {}) ⇒ Object
Deletes a shape in worksheet.
-
#delete_worksheet_shapes(delete_worksheet_shapes_request, opts = {}) ⇒ Object
delete all shapes in worksheet.
-
#delete_worksheet_sparkline_group(delete_worksheet_sparkline_group_request, opts = {}) ⇒ Object
Delete worksheet sparkline group description.
-
#delete_worksheet_sparkline_groups(delete_worksheet_sparkline_groups_request, opts = {}) ⇒ Object
Delete worksheet sparkline groups description.
-
#delete_worksheet_validation(delete_worksheet_validation_request, opts = {}) ⇒ Object
Deletes a validation by index in worksheet.
-
#delete_worksheet_validations(delete_worksheet_validations_request, opts = {}) ⇒ Object
Delete all validations in worksheet.
- #delete_worksheets(delete_worksheets_request, opts = {}) ⇒ Object
- #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
- #get_chart_second_category_axis(get_chart_second_category_axis_request, opts = {}) ⇒ Object
- #get_chart_second_value_axis(get_chart_second_value_axis_request, opts = {}) ⇒ Object
- #get_chart_series_axis(get_chart_series_axis_request, opts = {}) ⇒ Object
- #get_chart_value_axis(get_chart_value_axis_request, opts = {}) ⇒ Object
- #get_disc_usage(get_disc_usage_request, opts = {}) ⇒ Object
-
#get_document_properties(get_document_properties_request, opts = {}) ⇒ Object
Get document properties description.
-
#get_document_property(get_document_property_request, opts = {}) ⇒ Object
Gets document 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
Gets page footer description in worksheet.
-
#get_header(get_header_request, opts = {}) ⇒ Object
Gets page header description in worksheet.
-
#get_horizontal_page_break(get_horizontal_page_break_request, opts = {}) ⇒ Object
Gets a horizontal page breaks descripton in worksheet.
-
#get_horizontal_page_breaks(get_horizontal_page_breaks_request, opts = {}) ⇒ Object
Get horizontal page breaks descripton in worksheet.
-
#get_metadata(get_metadata_request, opts = {}) ⇒ Object
Get cells document properties.
-
#get_named_range_value(get_named_range_value_request, opts = {}) ⇒ Object
Get range values.
-
#get_named_ranges(get_named_ranges_request, opts = {}) ⇒ Object
Get worksheets ranges description.
- #get_page_count(get_page_count_request, opts = {}) ⇒ Object
-
#get_page_setup(get_page_setup_request, opts = {}) ⇒ Object
Gets page setup description in worksheet.
-
#get_pivot_table_field(get_pivot_table_field_request, opts = {}) ⇒ Object
Gets pivot field description in pivot table.
-
#get_vertical_page_break(get_vertical_page_break_request, opts = {}) ⇒ Object
Gets a vertical page break description in worksheet.
-
#get_vertical_page_breaks(get_vertical_page_breaks_request, opts = {}) ⇒ Object
Get vertical page breaks description in worksheet.
-
#get_workbook(get_workbook_request, opts = {}) ⇒ Object
Retrieve workbooks in various formats.
-
#get_workbook_default_style(get_workbook_default_style_request, opts = {}) ⇒ Object
Gets workbook default style description.
-
#get_workbook_name(get_workbook_name_request, opts = {}) ⇒ Object
Gets workbook’s name description.
-
#get_workbook_name_value(get_workbook_name_value_request, opts = {}) ⇒ Object
Gets workbook’s name value.
-
#get_workbook_names(get_workbook_names_request, opts = {}) ⇒ Object
Get workbook’s names.
-
#get_workbook_settings(get_workbook_settings_request, opts = {}) ⇒ Object
Gets workbook settings description.
-
#get_workbook_text_items(get_workbook_text_items_request, opts = {}) ⇒ Object
Get workbook’s text items.
-
#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
Calculates formula value in 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
Get the value of cells in 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
Gets chart title description in 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
Gets worksheet column data by column’s index.
-
#get_worksheet_columns(get_worksheet_columns_request, opts = {}) ⇒ Object
Get worksheet columns description.
-
#get_worksheet_comment(get_worksheet_comment_request, opts = {}) ⇒ Object
Gets comment by cell name in worksheet.
-
#get_worksheet_comments(get_worksheet_comments_request, opts = {}) ⇒ Object
Get comments description in worksheet.
-
#get_worksheet_conditional_formatting(get_worksheet_conditional_formatting_request, opts = {}) ⇒ Object
Gets conditional formatting description in worksheet.
-
#get_worksheet_conditional_formattings(get_worksheet_conditional_formattings_request, opts = {}) ⇒ Object
Get conditional formattings description.
-
#get_worksheet_hyperlink(get_worksheet_hyperlink_request, opts = {}) ⇒ Object
Gets hyperlink description by index in worksheet.
-
#get_worksheet_hyperlinks(get_worksheet_hyperlinks_request, opts = {}) ⇒ Object
Get hyperlinks description in worksheet.
-
#get_worksheet_list_object(get_worksheet_list_object_request, opts = {}) ⇒ Object
Gets list object description by index in worksheet.
-
#get_worksheet_list_objects(get_worksheet_list_objects_request, opts = {}) ⇒ Object
Get listobjects description in worksheet.
-
#get_worksheet_merged_cell(get_worksheet_merged_cell_request, opts = {}) ⇒ Object
Gets merged cell description by its index in 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
Gets OLE object info or get the OLE object in some format.
-
#get_worksheet_ole_objects(get_worksheet_ole_objects_request, opts = {}) ⇒ Object
Get OLE objects description in worksheet.
- #get_worksheet_page_count(get_worksheet_page_count_request, opts = {}) ⇒ Object
-
#get_worksheet_picture_with_format(get_worksheet_picture_with_format_request, opts = {}) ⇒ Object
Gets a picture by number in worksheet.
-
#get_worksheet_pictures(get_worksheet_pictures_request, opts = {}) ⇒ Object
Get pictures description in worksheet.
-
#get_worksheet_pivot_table(get_worksheet_pivot_table_request, opts = {}) ⇒ Object
Gets a pivottable info by index in worksheet.
-
#get_worksheet_pivot_table_filter(get_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object
Gets pivot table filters in worksheet.
-
#get_worksheet_pivot_table_filters(get_worksheet_pivot_table_filters_request, opts = {}) ⇒ Object
Gets pivot table filters in worksheet.
-
#get_worksheet_pivot_tables(get_worksheet_pivot_tables_request, opts = {}) ⇒ Object
Get worksheet pivottables description.
-
#get_worksheet_row(get_worksheet_row_request, opts = {}) ⇒ Object
Gets row data by row’s index in worksheet.
-
#get_worksheet_rows(get_worksheet_rows_request, opts = {}) ⇒ Object
Get rows description in worksheet.
-
#get_worksheet_shape(get_worksheet_shape_request, opts = {}) ⇒ Object
Gets shape description in worksheet.
-
#get_worksheet_shapes(get_worksheet_shapes_request, opts = {}) ⇒ Object
Get shapes description in worksheet.
-
#get_worksheet_sparkline_group(get_worksheet_sparkline_group_request, opts = {}) ⇒ Object
Get worksheet sparkline group description.
-
#get_worksheet_sparkline_groups(get_worksheet_sparkline_groups_request, opts = {}) ⇒ Object
Get worksheet sparkline groups description.
-
#get_worksheet_text_items(get_worksheet_text_items_request, opts = {}) ⇒ Object
Get text items in worksheet.
-
#get_worksheet_validation(get_worksheet_validation_request, opts = {}) ⇒ Object
Gets a validation by index in worksheet.
-
#get_worksheet_validations(get_worksheet_validations_request, opts = {}) ⇒ Object
Get validations description in worksheet.
-
#get_worksheet_with_format(get_worksheet_with_format_request, opts = {}) ⇒ Object
Gets worksheet in some format.
-
#get_worksheets(get_worksheets_request, opts = {}) ⇒ Object
Get worksheets description.
-
#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_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
-
#post_autofit_workbook_rows(post_autofit_workbook_rows_request, opts = {}) ⇒ Object
Autofit workbook rows.
- #post_autofit_worksheet_columns(post_autofit_worksheet_columns_request, opts = {}) ⇒ Object
-
#post_autofit_worksheet_row(post_autofit_worksheet_row_request, opts = {}) ⇒ Object
Autofits row in worksheet.
-
#post_autofit_worksheet_rows(post_autofit_worksheet_rows_request, opts = {}) ⇒ Object
Autofit rows in 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
- #post_chart_second_category_axis(post_chart_second_category_axis_request, opts = {}) ⇒ Object
- #post_chart_second_value_axis(post_chart_second_value_axis_request, opts = {}) ⇒ Object
- #post_chart_series_axis(post_chart_series_axis_request, opts = {}) ⇒ Object
- #post_chart_value_axis(post_chart_value_axis_request, opts = {}) ⇒ Object
-
#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
Sets column style in 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
Copies contents and formats from another worksheet.
-
#post_copy_worksheet_columns(post_copy_worksheet_columns_request, opts = {}) ⇒ Object
Copy data to destination columns from source columns in worksheet.
-
#post_copy_worksheet_rows(post_copy_worksheet_rows_request, opts = {}) ⇒ Object
Copies data and formats of some whole rows in worksheet.
-
#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_footer(post_footer_request, opts = {}) ⇒ Object
Update page footer description in worksheet.
-
#post_group_worksheet_columns(post_group_worksheet_columns_request, opts = {}) ⇒ Object
Group worksheet columns.
-
#post_group_worksheet_rows(post_group_worksheet_rows_request, opts = {}) ⇒ Object
Group rows in worksheet.
-
#post_header(post_header_request, opts = {}) ⇒ Object
Updates page header in worksheet.
-
#post_hide_worksheet_columns(post_hide_worksheet_columns_request, opts = {}) ⇒ Object
Hide worksheet columns.
-
#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 workbook.
-
#post_page_setup(post_page_setup_request, opts = {}) ⇒ Object
Updates page setup in worksheet.
-
#post_pivot_table_cell_style(post_pivot_table_cell_style_request, opts = {}) ⇒ Object
Updates cell style in pivot table.
-
#post_pivot_table_field_hide_item(post_pivot_table_field_hide_item_request, opts = {}) ⇒ Object
Hides pivot field item in pivot table.
-
#post_pivot_table_field_move_to(post_pivot_table_field_move_to_request, opts = {}) ⇒ Object
Moves pivot field in pivot table.
-
#post_pivot_table_style(post_pivot_table_style_request, opts = {}) ⇒ Object
Updates style in pivot table.
- #post_pivot_table_update_pivot_field(post_pivot_table_update_pivot_field_request, opts = {}) ⇒ Object
- #post_pivot_table_update_pivot_fields(post_pivot_table_update_pivot_fields_request, opts = {}) ⇒ Object
-
#post_protect(post_protect_request, opts = {}) ⇒ Object
Excel files encryption.
-
#post_protect_workbook(post_protect_workbook_request, opts = {}) ⇒ Object
Excel protection.
-
#post_rename_worksheet(post_rename_worksheet_request, opts = {}) ⇒ Object
Rename worksheet.
-
#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
Applies formats for a whole row in 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
Sets 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_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 worksheet.
-
#post_unhide_worksheet_columns(post_unhide_worksheet_columns_request, opts = {}) ⇒ Object
Unhide worksheet columns.
-
#post_unhide_worksheet_rows(post_unhide_worksheet_rows_request, opts = {}) ⇒ Object
Unhide rows in worksheet.
-
#post_unlock(post_unlock_request, opts = {}) ⇒ Object
Unlock Excel files.
-
#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.
-
#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
Updates row in worksheet.
-
#post_update_worksheet_zoom(post_update_worksheet_zoom_request, opts = {}) ⇒ Object
Updates worksheet zoom.
-
#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 workbook.
-
#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 result.
-
#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 workbook’s name.
-
#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
Updates workbook setting.
-
#post_workbook_split(post_workbook_split_request, opts = {}) ⇒ Object
Splits workbook.
-
#post_workbook_text_replace(post_workbook_text_replace_request, opts = {}) ⇒ Object
Replaces text in workbook.
-
#post_workbooks_merge(post_workbooks_merge_request, opts = {}) ⇒ Object
Merge workbooks.
-
#post_workbooks_text_search(post_workbooks_text_search_request, opts = {}) ⇒ Object
Search text in 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
Calculates formula value in 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
Sets column width of range.
-
#post_worksheet_cells_range_merge(post_worksheet_cells_range_merge_request, opts = {}) ⇒ Object
Combines a range of cells into a single cell.
-
#post_worksheet_cells_range_move_to(post_worksheet_cells_range_move_to_request, opts = {}) ⇒ Object
Moves the current range to the dest range.
-
#post_worksheet_cells_range_outline_border(post_worksheet_cells_range_outline_border_request, opts = {}) ⇒ Object
Sets 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
Sets data sort around a range of cells.
-
#post_worksheet_cells_range_style(post_worksheet_cells_range_style_request, opts = {}) ⇒ Object
Sets the style of the range.
-
#post_worksheet_cells_range_un_merge(post_worksheet_cells_range_un_merge_request, opts = {}) ⇒ Object
Unmerges merged cells of this range.
-
#post_worksheet_cells_range_value(post_worksheet_cells_range_value_request, opts = {}) ⇒ Object
Puts a value into the range, if appropriate the value will be converted to other data type and cell’s number format will be reset.
-
#post_worksheet_cells_ranges_copy(post_worksheet_cells_ranges_copy_request, opts = {}) ⇒ Object
Copys content to destination range from source range in 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 worksheet.
-
#post_worksheet_comment(post_worksheet_comment_request, opts = {}) ⇒ Object
Updates cell comment in worksheet.
- #post_worksheet_group_shape(post_worksheet_group_shape_request, opts = {}) ⇒ Object
-
#post_worksheet_hyperlink(post_worksheet_hyperlink_request, opts = {}) ⇒ Object
Updates hyperlink by index in worksheet.
-
#post_worksheet_list_column(post_worksheet_list_column_request, opts = {}) ⇒ Object
Update list column properties.
-
#post_worksheet_list_columns_total(post_worksheet_list_columns_total_request, opts = {}) ⇒ Object
Update table total of list columns.
-
#post_worksheet_list_object(post_worksheet_list_object_request, opts = {}) ⇒ Object
Updates list object in worksheet.
-
#post_worksheet_list_object_convert_to_range(post_worksheet_list_object_convert_to_range_request, opts = {}) ⇒ Object
Converts list object to range in 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 on list object.
-
#post_worksheet_list_object_sort_table(post_worksheet_list_object_sort_table_request, opts = {}) ⇒ Object
Sorts list object in worksheet.
-
#post_worksheet_list_object_summarize_with_pivot_table(post_worksheet_list_object_summarize_with_pivot_table_request, opts = {}) ⇒ Object
Creates pivot table with list object in 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
Updates a picture by index in worksheet.
-
#post_worksheet_pivot_table_calculate(post_worksheet_pivot_table_calculate_request, opts = {}) ⇒ Object
Calculates pivottable’s data to cells.
-
#post_worksheet_pivot_table_move(post_worksheet_pivot_table_move_request, opts = {}) ⇒ Object
Moves pivot table in worksheet.
-
#post_worksheet_range_sort(post_worksheet_range_sort_request, opts = {}) ⇒ Object
Sorts range in worksheet.
-
#post_worksheet_shape(post_worksheet_shape_request, opts = {}) ⇒ Object
Updates a shape in worksheet.
-
#post_worksheet_sparkline_group(post_worksheet_sparkline_group_request, opts = {}) ⇒ Object
Post worksheet sparkline group description.
-
#post_worksheet_text_search(post_worksheet_text_search_request, opts = {}) ⇒ Object
Searchs text in worksheet.
- #post_worksheet_ungroup_shape(post_worksheet_ungroup_shape_request, opts = {}) ⇒ Object
-
#post_worksheet_unmerge(post_worksheet_unmerge_request, opts = {}) ⇒ Object
Unmerge cells in the worksheet.
-
#post_worksheet_validation(post_worksheet_validation_request, opts = {}) ⇒ Object
Updates a validation by index in worksheet.
-
#post_worsheet_text_replace(post_worsheet_text_replace_request, opts = {}) ⇒ Object
Replaces text in worksheet.
-
#put_active_worksheet(put_active_worksheet_request, opts = {}) ⇒ Object
Active sheet.
-
#put_add_new_worksheet(put_add_new_worksheet_request, opts = {}) ⇒ Object
Adds new worksheet in workbook.
-
#put_change_visibility_worksheet(put_change_visibility_worksheet_request, opts = {}) ⇒ Object
Changes worksheet visibility.
-
#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
Sets/creates a sdocument 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
Adds a horizontal page breaks in worksheet.
-
#put_insert_new_worksheet(put_insert_new_worksheet_request, opts = {}) ⇒ Object
Inserts new worksheet in workbook.
-
#put_insert_worksheet_columns(put_insert_worksheet_columns_request, opts = {}) ⇒ Object
Insert worksheet columns.
-
#put_insert_worksheet_row(put_insert_worksheet_row_request, opts = {}) ⇒ Object
Inserts new row in worksheet.
-
#put_insert_worksheet_rows(put_insert_worksheet_rows_request, opts = {}) ⇒ Object
Insert several new rows in worksheet.
-
#put_pivot_table_field(put_pivot_table_field_request, opts = {}) ⇒ Object
Adds a pivot field in pivot table.
-
#put_protect_worksheet(put_protect_worksheet_request, opts = {}) ⇒ Object
Protects worksheet.
-
#put_vertical_page_break(put_vertical_page_break_request, opts = {}) ⇒ Object
Adds a vertical page break in worksheet.
-
#put_workbook_background(put_workbook_background_request, opts = {}) ⇒ Object
Set workbook background.
-
#put_workbook_create(put_workbook_create_request, opts = {}) ⇒ Object
Creates new workbook using deferent methods.
-
#put_workbook_name(put_workbook_name_request, opts = {}) ⇒ Object
Defines a new name in workbook.
-
#put_workbook_water_marker(put_workbook_water_marker_request, opts = {}) ⇒ Object
Set workbook water marker.
-
#put_worksheet_add_chart(put_worksheet_add_chart_request, opts = {}) ⇒ Object
Add a new chart in the worksheet.
-
#put_worksheet_add_picture(put_worksheet_add_picture_request, opts = {}) ⇒ Object
Adds a new picture in worksheet.
-
#put_worksheet_background(put_worksheet_background_request, opts = {}) ⇒ Object
Sets background image in worksheet.
-
#put_worksheet_cells_range(put_worksheet_cells_range_request, opts = {}) ⇒ Object
Inserts a range of cells and shift cells according to the shift option.
-
#put_worksheet_chart_legend(put_worksheet_chart_legend_request, opts = {}) ⇒ Object
Show chart legend in worksheet.
-
#put_worksheet_chart_title(put_worksheet_chart_title_request, opts = {}) ⇒ Object
Add chart title / Set chart title visible.
-
#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
Adds cell comment in worksheet.
-
#put_worksheet_conditional_formatting(put_worksheet_conditional_formatting_request, opts = {}) ⇒ Object
Adds a condition formatting in 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
Adds a format condition in worksheet.
-
#put_worksheet_format_condition_area(put_worksheet_format_condition_area_request, opts = {}) ⇒ Object
Adds a cell area for format condition.
-
#put_worksheet_format_condition_condition(put_worksheet_format_condition_condition_request, opts = {}) ⇒ Object
Adds a condition for format condition.
-
#put_worksheet_freeze_panes(put_worksheet_freeze_panes_request, opts = {}) ⇒ Object
Sets freeze panes in worksheet.
-
#put_worksheet_hyperlink(put_worksheet_hyperlink_request, opts = {}) ⇒ Object
Adds hyperlink in 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
Adds a list object in worksheet.
-
#put_worksheet_ole_object(put_worksheet_ole_object_request, opts = {}) ⇒ Object
Add an OLE object in worksheet.
-
#put_worksheet_pivot_table(put_worksheet_pivot_table_request, opts = {}) ⇒ Object
Adds a pivot table in worksheet.
-
#put_worksheet_pivot_table_filter(put_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object
Adds a pivot filter for piovt table index.
-
#put_worksheet_shape(put_worksheet_shape_request, opts = {}) ⇒ Object
Adds shape in worksheet.
-
#put_worksheet_sparkline_group(put_worksheet_sparkline_group_request, opts = {}) ⇒ Object
Put worksheet sparkline group description.
-
#put_worksheet_validation(put_worksheet_validation_request, opts = {}) ⇒ Object
Adds a validation at index in 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
2528 2529 2530 2531 2532 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2528 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
2563 2564 2565 2566 2567 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2563 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
2556 2557 2558 2559 2560 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2556 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.
1682 1683 1684 1685 1686 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1682 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 clean built-in ones.
1658 1659 1660 1661 1662 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1658 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
Deletes a document property.
1650 1651 1652 1653 1654 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1650 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.
1714 1715 1716 1717 1718 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1714 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
2542 2543 2544 2545 2546 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2542 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
2577 2578 2579 2580 2581 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2577 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
Clears header footer in worksheet.
1372 1373 1374 1375 1376 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1372 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 breaks in worksheet.
1348 1349 1350 1351 1352 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1348 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 worksheet.
1332 1333 1334 1335 1336 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1332 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.
1116 1117 1118 1119 1120 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1116 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
Deletes pivot field in pivot table.
1602 1603 1604 1605 1606 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1602 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.
1698 1699 1700 1701 1702 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1698 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
Unprotects worksheet.
2237 2238 2239 2240 2241 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2237 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 breaks in worksheet.
1340 1341 1342 1343 1344 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1340 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 worksheet.
1324 1325 1326 1327 1328 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1324 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 workbook background.
2135 2136 2137 2138 2139 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2135 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
Gets workbook’s name description.
2032 2033 2034 2035 2036 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2032 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 workbook’s names.
2024 2025 2026 2027 2028 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2024 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
Deletes a worksheet in workbook.
2206 2207 2208 2209 2210 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2206 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 worksheet.
2388 2389 2390 2391 2392 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2388 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
Deletes a range of cells and shift cells according to the shift option.
1842 1843 1844 1845 1846 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1842 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_legend(delete_worksheet_chart_legend_request, opts = {}) ⇒ Object
Hides chart legend in worksheet.
629 630 631 632 633 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 629 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
Hides chart title in worksheet.
669 670 671 672 673 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 669 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_clear_charts(delete_worksheet_clear_charts_request, opts = {}) ⇒ Object
Clear the charts in worksheets.
637 638 639 640 641 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 637 def delete_worksheet_clear_charts( delete_worksheet_clear_charts_request, opts = {}) data, _status_code, _headers = delete_worksheet_clear_charts_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_columns(delete_worksheet_columns_request, opts = {}) ⇒ Object
Delete worksheet columns.
365 366 367 368 369 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 365 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
Deletes cell comment in worksheet.
2285 2286 2287 2288 2289 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2285 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 worksheet.
2293 2294 2295 2296 2297 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2293 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.
803 804 805 806 807 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 803 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
Removes cell area from conditional formatting.
811 812 813 814 815 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 811 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 condition formattings.
795 796 797 798 799 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 795 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.
133 134 135 136 137 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 133 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_delete_chart(delete_worksheet_delete_chart_request, opts = {}) ⇒ Object
Delete a chart by index in the worksheet.
589 590 591 592 593 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 589 def delete_worksheet_delete_chart( delete_worksheet_delete_chart_request, opts = {}) data, _status_code, _headers = delete_worksheet_delete_chart_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.
141 142 143 144 145 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 141 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
Unfreezes panes in worksheet.
2404 2405 2406 2407 2408 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2404 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
Deletes hyperlink by index in worksheet.
972 973 974 975 976 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 972 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 worksheet.
996 997 998 999 1000 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 996 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
Deletes list object by index in worksheet.
1156 1157 1158 1159 1160 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1156 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 worksheet list objects in worksheet.
1148 1149 1150 1151 1152 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1148 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
Deletes an OLE object in worksheet.
1252 1253 1254 1255 1256 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1252 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 worksheet.
1244 1245 1246 1247 1248 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1244 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
Deletes a picture object in worksheet
1444 1445 1446 1447 1448 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1444 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 worksheet.
1452 1453 1454 1455 1456 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1452 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
Deletes pivot table by index in worksheet.
1594 1595 1596 1597 1598 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1594 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
Deletes a pivot filter in piovt table.
1618 1619 1620 1621 1622 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1618 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 piovt table.
1610 1611 1612 1613 1614 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1610 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 pivot tables in worksheet.
1586 1587 1588 1589 1590 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1586 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
Deletes row in worksheet.
437 438 439 440 441 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 437 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 worksheet.
445 446 447 448 449 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 445 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
Deletes a shape in worksheet.
1882 1883 1884 1885 1886 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1882 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 worksheet.
1874 1875 1876 1877 1878 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1874 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 worksheet sparkline group description.
1936 1937 1938 1939 1940 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1936 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 worksheet sparkline groups description.
1928 1929 1930 1931 1932 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1928 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
Deletes a validation by index in worksheet.
2499 2500 2501 2502 2503 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2499 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 worksheet.
2507 2508 2509 2510 2511 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2507 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
2213 2214 2215 2216 2217 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2213 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
2514 2515 2516 2517 2518 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2514 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.
301 302 303 304 305 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 301 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.
533 534 535 536 537 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 533 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.
525 526 527 528 529 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 525 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.
541 542 543 544 545 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 541 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.
557 558 559 560 561 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 557 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.
549 550 551 552 553 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 549 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
683 684 685 686 687 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 683 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
697 698 699 700 701 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 697 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
704 705 706 707 708 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 704 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
676 677 678 679 680 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 676 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
690 691 692 693 694 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 690 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
2598 2599 2600 2601 2602 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2598 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
Get document properties description.
1626 1627 1628 1629 1630 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1626 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
Gets document property by name.
1642 1643 1644 1645 1646 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1642 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
2605 2606 2607 2608 2609 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2605 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
2549 2550 2551 2552 2553 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2549 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
Gets page footer description in worksheet.
1396 1397 1398 1399 1400 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1396 def ( , opts = {}) data, _status_code, _headers = .create_http_request(@api_client,opts ) return data end |
#get_header(get_header_request, opts = {}) ⇒ Object
Gets page header description in worksheet.
1380 1381 1382 1383 1384 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1380 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
Gets a horizontal page breaks descripton in worksheet.
1300 1301 1302 1303 1304 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1300 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
Get horizontal page breaks descripton in worksheet.
1284 1285 1286 1287 1288 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1284 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.
1108 1109 1110 1111 1112 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1108 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
Get range values.
2444 2445 2446 2447 2448 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2444 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
Get worksheets ranges description.
2436 2437 2438 2439 2440 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2436 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
2150 2151 2152 2153 2154 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2150 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
Gets page setup description in worksheet.
1356 1357 1358 1359 1360 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1356 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
Gets pivot field description in pivot table.
1476 1477 1478 1479 1480 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1476 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
Gets a vertical page break description in worksheet.
1292 1293 1294 1295 1296 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1292 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
Get vertical page breaks description in worksheet.
1276 1277 1278 1279 1280 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1276 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.
819 820 821 822 823 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 819 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
Gets workbook default style description.
1968 1969 1970 1971 1972 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1968 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
Gets workbook’s name description.
2000 2001 2002 2003 2004 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2000 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
Gets workbook’s name value.
2016 2017 2018 2019 2020 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2016 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
Get workbook’s names.
1984 1985 1986 1987 1988 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1984 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
Gets workbook settings description.
2111 2112 2113 2114 2115 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2111 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
Get workbook’s text items.
1976 1977 1978 1979 1980 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1976 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.
45 46 47 48 49 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 45 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.
157 158 159 160 161 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 157 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.
149 150 151 152 153 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 149 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
Calculates formula value in worksheet.
2317 2318 2319 2320 2321 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2317 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.
253 254 255 256 257 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 253 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.
261 262 263 264 265 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 261 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.
245 246 247 248 249 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 245 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
Get the value of cells in range.
1778 1779 1780 1781 1782 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1778 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.
573 574 575 576 577 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 573 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.
605 606 607 608 609 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 605 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
Gets chart title description in worksheet.
645 646 647 648 649 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 645 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.
565 566 567 568 569 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 565 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
Gets worksheet column data by column’s index.
349 350 351 352 353 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 349 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
Get worksheet columns description.
333 334 335 336 337 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 333 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
Gets comment by cell name in worksheet.
2261 2262 2263 2264 2265 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2261 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
Get comments description in worksheet.
2253 2254 2255 2256 2257 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2253 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
Gets conditional formatting description in worksheet.
755 756 757 758 759 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 755 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
Get conditional formattings description.
747 748 749 750 751 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 747 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
Gets hyperlink description by index in worksheet.
964 965 966 967 968 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 964 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
Get hyperlinks description in worksheet.
956 957 958 959 960 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 956 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
Gets list object description by index in worksheet.
1132 1133 1134 1135 1136 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1132 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
Get listobjects description in worksheet.
1124 1125 1126 1127 1128 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1124 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
Gets merged cell description by its index in worksheet.
2309 2310 2311 2312 2313 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2309 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.
2301 2302 2303 2304 2305 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2301 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
Gets OLE object info or get the OLE object in some format.
1236 1237 1238 1239 1240 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1236 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
Get OLE objects description in worksheet.
1228 1229 1230 1231 1232 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1228 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
2459 2460 2461 2462 2463 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2459 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
Gets a picture by number in worksheet.
1420 1421 1422 1423 1424 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1420 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
Get pictures description in worksheet.
1412 1413 1414 1415 1416 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1412 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
Gets a pivottable info by index in worksheet.
1468 1469 1470 1471 1472 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1468 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
Gets pivot table filters in worksheet.
1492 1493 1494 1495 1496 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1492 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 pivot table filters in worksheet.
1484 1485 1486 1487 1488 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1484 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
Get worksheet pivottables description.
1460 1461 1462 1463 1464 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1460 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
Gets row data by row’s index in worksheet.
429 430 431 432 433 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 429 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
Get rows description in worksheet.
421 422 423 424 425 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 421 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
Gets shape description in worksheet.
1858 1859 1860 1861 1862 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1858 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
Get shapes description in worksheet.
1850 1851 1852 1853 1854 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1850 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
Get worksheet sparkline group description.
1920 1921 1922 1923 1924 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1920 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
Get worksheet sparkline groups description.
1912 1913 1914 1915 1916 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1912 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
Get text items in worksheet.
2245 2246 2247 2248 2249 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2245 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
Gets a validation by index in worksheet.
2475 2476 2477 2478 2479 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2475 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
Get validations description in worksheet.
2467 2468 2469 2470 2471 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2467 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
Gets worksheet in some format.
2166 2167 2168 2169 2170 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2166 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
Get worksheets description.
2158 2159 2160 2161 2162 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2158 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
2535 2536 2537 2538 2539 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2535 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
2570 2571 2572 2573 2574 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2570 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
2591 2592 2593 2594 2595 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2591 def object_exists( object_exists_request, opts = {}) data, _status_code, _headers = object_exists_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.
1004 1005 1006 1007 1008 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1004 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
2103 2104 2105 2106 2107 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2103 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 workbook rows.
2096 2097 2098 2099 2100 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2096 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
2372 2373 2374 2375 2376 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2372 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
Autofits row in worksheet.
2357 2358 2359 2360 2361 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2357 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 worksheet.
2365 2366 2367 2368 2369 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2365 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.
165 166 167 168 169 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 165 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.
181 182 183 184 185 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 181 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.
173 174 175 176 177 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 173 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.
197 198 199 200 201 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 197 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.
189 190 191 192 193 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 189 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.
317 318 319 320 321 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 317 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.
325 326 327 328 329 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 325 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
718 719 720 721 722 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 718 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
732 733 734 735 736 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 732 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
739 740 741 742 743 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 739 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
711 712 713 714 715 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 711 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
725 726 727 728 729 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 725 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.
205 206 207 208 209 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 205 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.
213 214 215 216 217 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 213 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.
1068 1069 1070 1071 1072 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1068 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
Sets column style in worksheet.
413 414 415 416 417 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 413 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.
1012 1013 1014 1015 1016 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1012 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.
907 908 909 910 911 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 907 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.
859 860 861 862 863 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 859 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.
875 876 877 878 879 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 875 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.
891 892 893 894 895 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 891 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.
883 884 885 886 887 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 883 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.
843 844 845 846 847 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 843 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.
851 852 853 854 855 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 851 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.
867 868 869 870 871 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 867 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.
899 900 901 902 903 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 899 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.
293 294 295 296 297 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 293 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
Copies contents and formats from another worksheet.
2412 2413 2414 2415 2416 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2412 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 to destination columns from source columns in worksheet.
405 406 407 408 409 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 405 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
Copies data and formats of some whole rows in worksheet.
509 510 511 512 513 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 509 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_digital_signature(post_digital_signature_request, opts = {}) ⇒ Object
Excel file digital signature.
1666 1667 1668 1669 1670 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1666 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.
1674 1675 1676 1677 1678 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1674 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.
915 916 917 918 919 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 915 def post_export( post_export_request, opts = {}) data, _status_code, _headers = post_export_request.create_http_request(@api_client,opts ) return data end |
#post_footer(post_footer_request, opts = {}) ⇒ Object
Update page footer description in worksheet.
1404 1405 1406 1407 1408 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1404 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.
389 390 391 392 393 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 389 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 worksheet.
493 494 495 496 497 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 493 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
Updates page header in worksheet.
1388 1389 1390 1391 1392 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1388 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.
373 374 375 376 377 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 373 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.
477 478 479 480 481 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 477 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.
1052 1053 1054 1055 1056 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1052 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.
948 949 950 951 952 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 948 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.
1730 1731 1732 1733 1734 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1730 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.
1020 1021 1022 1023 1024 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1020 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.
1100 1101 1102 1103 1104 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1100 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 workbook.
2221 2222 2223 2224 2225 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2221 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
Updates page setup in worksheet.
1364 1365 1366 1367 1368 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1364 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
Updates cell style in pivot table.
1540 1541 1542 1543 1544 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1540 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
Hides pivot field item in pivot table.
1524 1525 1526 1527 1528 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1524 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
Moves pivot field in pivot table.
1532 1533 1534 1535 1536 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1532 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
Updates style in pivot table.
1548 1549 1550 1551 1552 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1548 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
1562 1563 1564 1565 1566 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1562 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
1555 1556 1557 1558 1559 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1555 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.
1738 1739 1740 1741 1742 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1738 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.
1690 1691 1692 1693 1694 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1690 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_rename_worksheet(post_rename_worksheet_request, opts = {}) ⇒ Object
Rename worksheet.
2420 2421 2422 2423 2424 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2420 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.
1084 1085 1086 1087 1088 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1084 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.
1044 1045 1046 1047 1048 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1044 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.
1076 1077 1078 1079 1080 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1076 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.
1092 1093 1094 1095 1096 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1092 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
Applies formats for a whole row in worksheet.
517 518 519 520 521 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 517 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.
1960 1961 1962 1963 1964 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1960 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.
1036 1037 1038 1039 1040 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1036 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.
309 310 311 312 313 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 309 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.
285 286 287 288 289 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 285 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
Sets worksheet column width.
341 342 343 344 345 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 341 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.
1028 1029 1030 1031 1032 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1028 def post_split( post_split_request, opts = {}) data, _status_code, _headers = post_split_request.create_http_request(@api_client,opts ) return data end |
#post_ungroup_worksheet_columns(post_ungroup_worksheet_columns_request, opts = {}) ⇒ Object
Ungroup worksheet columns.
397 398 399 400 401 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 397 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 worksheet.
501 502 503 504 505 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 501 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.
381 382 383 384 385 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 381 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 worksheet.
485 486 487 488 489 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 485 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.
1722 1723 1724 1725 1726 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1722 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_worksheet_cell_style(post_update_worksheet_cell_style_request, opts = {}) ⇒ Object
Set cell style using cell name in the worksheet.
277 278 279 280 281 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 277 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.
1260 1261 1262 1263 1264 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1260 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.
2428 2429 2430 2431 2432 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2428 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.
221 222 223 224 225 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 221 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
Updates row in worksheet.
469 470 471 472 473 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 469 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
Updates worksheet zoom.
2452 2453 2454 2455 2456 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2452 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.
1060 1061 1062 1063 1064 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1060 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 workbook.
2088 2089 2090 2091 2092 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2088 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_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.
924 925 926 927 928 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 924 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 result.
2064 2065 2066 2067 2068 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2064 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.
932 933 934 935 936 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 932 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.
940 941 942 943 944 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 940 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 workbook’s name.
2008 2009 2010 2011 2012 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2008 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.
835 836 837 838 839 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 835 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
Updates workbook setting.
2119 2120 2121 2122 2123 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2119 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
Splits workbook.
2080 2081 2082 2083 2084 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2080 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
Replaces text in workbook.
2056 2057 2058 2059 2060 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2056 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 workbooks.
2040 2041 2042 2043 2044 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2040 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 text in workbook.
2048 2049 2050 2051 2052 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2048 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.
125 126 127 128 129 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 125 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
Calculates formula value in worksheet.
2325 2326 2327 2328 2329 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2325 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.
269 270 271 272 273 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 269 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
Sets column width of range.
1818 1819 1820 1821 1822 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1818 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
Combines a range of cells into a single cell.
1754 1755 1756 1757 1758 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1754 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
Moves the current range to the dest range.
1794 1795 1796 1797 1798 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1794 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
Sets outline border around a range of cells.
1810 1811 1812 1813 1814 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1810 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.
1826 1827 1828 1829 1830 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1826 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
Sets data sort around a range of cells.
1802 1803 1804 1805 1806 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1802 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
Sets the style of the range.
1770 1771 1772 1773 1774 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1770 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
Unmerges merged cells of this range.
1762 1763 1764 1765 1766 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1762 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
Puts a value into the range, if appropriate the value will be converted to other data type and cell’s number format will be reset.
1786 1787 1788 1789 1790 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1786 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
Copys content to destination range from source range in worksheet.
1746 1747 1748 1749 1750 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1746 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.
597 598 599 600 601 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 597 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.
613 614 615 616 617 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 613 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 worksheet.
653 654 655 656 657 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 653 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
Updates cell comment in worksheet.
2277 2278 2279 2280 2281 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2277 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
1897 1898 1899 1900 1901 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1897 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
Updates hyperlink by index in worksheet.
980 981 982 983 984 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 980 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 properties.
1212 1213 1214 1215 1216 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1212 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 table total of list columns.
1220 1221 1222 1223 1224 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1220 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
Updates list object in worksheet.
1164 1165 1166 1167 1168 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1164 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
Converts list object to range in worksheet.
1172 1173 1174 1175 1176 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1172 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.
1204 1205 1206 1207 1208 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1204 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 on list object.
1196 1197 1198 1199 1200 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1196 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
Sorts list object in worksheet.
1188 1189 1190 1191 1192 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1188 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
Creates pivot table with list object in worksheet.
1180 1181 1182 1183 1184 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1180 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.
109 110 111 112 113 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 109 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.
117 118 119 120 121 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 117 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.
229 230 231 232 233 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 229 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
Updates a picture by index in worksheet.
1436 1437 1438 1439 1440 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1436 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
Calculates pivottable’s data to cells.
1570 1571 1572 1573 1574 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1570 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
Moves pivot table in worksheet.
1578 1579 1580 1581 1582 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1578 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
Sorts range in worksheet.
2349 2350 2351 2352 2353 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2349 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
Updates a shape in worksheet.
1890 1891 1892 1893 1894 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1890 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
Post worksheet sparkline group description.
1952 1953 1954 1955 1956 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1952 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_search(post_worksheet_text_search_request, opts = {}) ⇒ Object
Searchs text in worksheet.
2333 2334 2335 2336 2337 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2333 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
1904 1905 1906 1907 1908 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1904 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.
237 238 239 240 241 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 237 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
Updates a validation by index in worksheet.
2491 2492 2493 2494 2495 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2491 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 |
#post_worsheet_text_replace(post_worsheet_text_replace_request, opts = {}) ⇒ Object
Replaces text in worksheet.
2341 2342 2343 2344 2345 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2341 def post_worsheet_text_replace( post_worsheet_text_replace_request, opts = {}) data, _status_code, _headers = post_worsheet_text_replace_request.create_http_request(@api_client,opts ) return data end |
#put_active_worksheet(put_active_worksheet_request, opts = {}) ⇒ Object
Active sheet
2182 2183 2184 2185 2186 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2182 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
Adds new worksheet in workbook.
2198 2199 2200 2201 2202 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2198 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
Changes worksheet visibility.
2174 2175 2176 2177 2178 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2174 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.
827 828 829 830 831 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 827 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
Sets/creates a sdocument property.
1634 1635 1636 1637 1638 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1634 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.
1706 1707 1708 1709 1710 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1706 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
Adds a horizontal page breaks in worksheet.
1316 1317 1318 1319 1320 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1316 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
Inserts new worksheet in workbook.
2190 2191 2192 2193 2194 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2190 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.
357 358 359 360 361 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 357 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
Inserts new row in worksheet.
461 462 463 464 465 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 461 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 worksheet.
453 454 455 456 457 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 453 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
Adds a pivot field in pivot table
1508 1509 1510 1511 1512 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1508 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
Protects worksheet.
2229 2230 2231 2232 2233 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2229 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
Adds a vertical page break in worksheet.
1308 1309 1310 1311 1312 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1308 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 workbook background.
2127 2128 2129 2130 2131 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2127 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
Creates new workbook using deferent methods.
2072 2073 2074 2075 2076 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2072 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
Defines a new name in workbook.
1992 1993 1994 1995 1996 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1992 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 workbook water marker.
2143 2144 2145 2146 2147 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2143 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_chart(put_worksheet_add_chart_request, opts = {}) ⇒ Object
Add a new chart in the worksheet.
581 582 583 584 585 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 581 def put_worksheet_add_chart( put_worksheet_add_chart_request, opts = {}) data, _status_code, _headers = put_worksheet_add_chart_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_add_picture(put_worksheet_add_picture_request, opts = {}) ⇒ Object
Adds a new picture in worksheet.
1428 1429 1430 1431 1432 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1428 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
Sets background image in worksheet.
2380 2381 2382 2383 2384 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2380 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
Inserts a range of cells and shift cells according to the shift option.
1834 1835 1836 1837 1838 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1834 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_legend(put_worksheet_chart_legend_request, opts = {}) ⇒ Object
Show chart legend in worksheet.
621 622 623 624 625 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 621 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
Add chart title / Set chart title visible
661 662 663 664 665 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 661 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.
101 102 103 104 105 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 101 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
Adds cell comment in worksheet.
2269 2270 2271 2272 2273 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2269 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
Adds a condition formatting in worksheet.
763 764 765 766 767 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 763 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.
77 78 79 80 81 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 77 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.
53 54 55 56 57 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 53 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.
85 86 87 88 89 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 85 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.
61 62 63 64 65 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 61 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.
93 94 95 96 97 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 93 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
Adds a format condition in worksheet.
771 772 773 774 775 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 771 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
Adds a cell area for format condition.
779 780 781 782 783 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 779 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
Adds a condition for format condition.
787 788 789 790 791 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 787 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
Sets freeze panes in worksheet.
2396 2397 2398 2399 2400 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2396 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
Adds hyperlink in worksheet.
988 989 990 991 992 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 988 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.
69 70 71 72 73 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 69 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
Adds a list object in worksheet.
1140 1141 1142 1143 1144 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1140 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 worksheet.
1268 1269 1270 1271 1272 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1268 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
Adds a pivot table in worksheet.
1500 1501 1502 1503 1504 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1500 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
Adds a pivot filter for piovt table index
1516 1517 1518 1519 1520 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1516 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
Adds shape in worksheet.
1866 1867 1868 1869 1870 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1866 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
Put worksheet sparkline group description.
1944 1945 1946 1947 1948 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1944 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
Adds a validation at index in worksheet.
2483 2484 2485 2486 2487 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2483 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
2584 2585 2586 2587 2588 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2584 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
2521 2522 2523 2524 2525 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2521 def upload_file( upload_file_request, opts = {}) data, _status_code, _headers = upload_file_request.create_http_request(@api_client,opts ) return data end |