class AsposeCellsCloud::CellsApi

Attributes

api_client[RW]

Public Class Methods

new(client_id,client_secret, app_version = 'v3.0', app_host = 'api.aspose.cloud', api_client = ApiClient.default) click to toggle source
# 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

Public Instance Methods

copy_file( copy_file_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2671
def copy_file( copy_file_request, opts = {})

   data, _status_code, _headers = copy_file_request.create_http_request(@api_client,opts )
   return data
end
copy_folder( copy_folder_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2706
def copy_folder( copy_folder_request, opts = {})

   data, _status_code, _headers = copy_folder_request.create_http_request(@api_client,opts )
   return data
end
create_folder( create_folder_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2699
def create_folder( create_folder_request, opts = {})

   data, _status_code, _headers = create_folder_request.create_http_request(@api_client,opts )
   return data
end
delete_decrypt_workbook( delete_decrypt_workbook_request, opts = {}) click to toggle source

Excel files decryption.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1790
def delete_decrypt_workbook( delete_decrypt_workbook_request, opts = {})

   data, _status_code, _headers = delete_decrypt_workbook_request.create_http_request(@api_client,opts )
   return data
end
delete_document_properties( delete_document_properties_request, opts = {}) click to toggle source

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

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1766
def delete_document_properties( delete_document_properties_request, opts = {})

   data, _status_code, _headers = delete_document_properties_request.create_http_request(@api_client,opts )
   return data
end
delete_document_property( delete_document_property_request, opts = {}) click to toggle source

Delete an Excel property.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1758
def delete_document_property( delete_document_property_request, opts = {})

   data, _status_code, _headers = delete_document_property_request.create_http_request(@api_client,opts )
   return data
end
delete_document_un_protect_from_changes( delete_document_un_protect_from_changes_request, opts = {}) click to toggle source

Excel file cancel write protection.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1822
def delete_document_un_protect_from_changes( delete_document_un_protect_from_changes_request, opts = {})

   data, _status_code, _headers = delete_document_un_protect_from_changes_request.create_http_request(@api_client,opts )
   return data
end
delete_file( delete_file_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2685
def delete_file( delete_file_request, opts = {})

   data, _status_code, _headers = delete_file_request.create_http_request(@api_client,opts )
   return data
end
delete_folder( delete_folder_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2720
def delete_folder( delete_folder_request, opts = {})

   data, _status_code, _headers = delete_folder_request.create_http_request(@api_client,opts )
   return data
end
delete_horizontal_page_break( delete_horizontal_page_break_request, opts = {}) click to toggle source

Delete a horizontal page break in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1438
def delete_horizontal_page_break( delete_horizontal_page_break_request, opts = {})

   data, _status_code, _headers = delete_horizontal_page_break_request.create_http_request(@api_client,opts )
   return data
end
delete_horizontal_page_breaks( delete_horizontal_page_breaks_request, opts = {}) click to toggle source

Delete horizontal page breaks in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1422
def delete_horizontal_page_breaks( delete_horizontal_page_breaks_request, opts = {})

   data, _status_code, _headers = delete_horizontal_page_breaks_request.create_http_request(@api_client,opts )
   return data
end
delete_metadata( delete_metadata_request, opts = {}) click to toggle source

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

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1206
def delete_metadata( delete_metadata_request, opts = {})

   data, _status_code, _headers = delete_metadata_request.create_http_request(@api_client,opts )
   return data
end
delete_pivot_table_field( delete_pivot_table_field_request, opts = {}) click to toggle source

Delete a pivot field in the PivotTable.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1710
def delete_pivot_table_field( delete_pivot_table_field_request, opts = {})

   data, _status_code, _headers = delete_pivot_table_field_request.create_http_request(@api_client,opts )
   return data
end
delete_un_protect_workbook( delete_un_protect_workbook_request, opts = {}) click to toggle source

Excel unprotection.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1806
def delete_un_protect_workbook( delete_un_protect_workbook_request, opts = {})

   data, _status_code, _headers = delete_un_protect_workbook_request.create_http_request(@api_client,opts )
   return data
end
delete_unprotect_worksheet( delete_unprotect_worksheet_request, opts = {}) click to toggle source

Unprotect worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2378
def delete_unprotect_worksheet( delete_unprotect_worksheet_request, opts = {})

   data, _status_code, _headers = delete_unprotect_worksheet_request.create_http_request(@api_client,opts )
   return data
end
delete_vertical_page_break( delete_vertical_page_break_request, opts = {}) click to toggle source

Delete a vertical page break in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1430
def delete_vertical_page_break( delete_vertical_page_break_request, opts = {})

   data, _status_code, _headers = delete_vertical_page_break_request.create_http_request(@api_client,opts )
   return data
end
delete_vertical_page_breaks( delete_vertical_page_breaks_request, opts = {}) click to toggle source

Delete vertical page breaks in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1414
def delete_vertical_page_breaks( delete_vertical_page_breaks_request, opts = {})

   data, _status_code, _headers = delete_vertical_page_breaks_request.create_http_request(@api_client,opts )
   return data
end
delete_workbook_background( delete_workbook_background_request, opts = {}) click to toggle source

Delete background in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2274
def delete_workbook_background( delete_workbook_background_request, opts = {})

   data, _status_code, _headers = delete_workbook_background_request.create_http_request(@api_client,opts )
   return data
end
delete_workbook_name( delete_workbook_name_request, opts = {}) click to toggle source

Delete a named range in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2170
def delete_workbook_name( delete_workbook_name_request, opts = {})

   data, _status_code, _headers = delete_workbook_name_request.create_http_request(@api_client,opts )
   return data
end
delete_workbook_names( delete_workbook_names_request, opts = {}) click to toggle source

Delete all named ranges in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2162
def delete_workbook_names( delete_workbook_names_request, opts = {})

   data, _status_code, _headers = delete_workbook_names_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet( delete_worksheet_request, opts = {}) click to toggle source

Delete a worksheet in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2346
def delete_worksheet( delete_worksheet_request, opts = {})

   data, _status_code, _headers = delete_worksheet_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_background( delete_worksheet_background_request, opts = {}) click to toggle source

Delete background image in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2530
def delete_worksheet_background( delete_worksheet_background_request, opts = {})

   data, _status_code, _headers = delete_worksheet_background_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_cells_range( delete_worksheet_cells_range_request, opts = {}) click to toggle source

Delete a range of cells and shift existing cells based on the specified shift option.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1950
def delete_worksheet_cells_range( delete_worksheet_cells_range_request, opts = {})

   data, _status_code, _headers = delete_worksheet_cells_range_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_chart( delete_worksheet_chart_request, opts = {}) click to toggle source

Delete a chart by index in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 605
def delete_worksheet_chart( delete_worksheet_chart_request, opts = {})

   data, _status_code, _headers = delete_worksheet_chart_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_chart_legend( delete_worksheet_chart_legend_request, opts = {}) click to toggle source

Hides chart legend in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 645
def delete_worksheet_chart_legend( delete_worksheet_chart_legend_request, opts = {})

   data, _status_code, _headers = delete_worksheet_chart_legend_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_chart_title( delete_worksheet_chart_title_request, opts = {}) click to toggle source

Hide chart title in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 685
def delete_worksheet_chart_title( delete_worksheet_chart_title_request, opts = {})

   data, _status_code, _headers = delete_worksheet_chart_title_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_charts( delete_worksheet_charts_request, opts = {}) click to toggle source

Clear the charts in the worksheets.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 653
def delete_worksheet_charts( delete_worksheet_charts_request, opts = {})

   data, _status_code, _headers = delete_worksheet_charts_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_columns( delete_worksheet_columns_request, opts = {}) click to toggle source

Delete worksheet columns in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 381
def delete_worksheet_columns( delete_worksheet_columns_request, opts = {})

   data, _status_code, _headers = delete_worksheet_columns_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_comment( delete_worksheet_comment_request, opts = {}) click to toggle source

Delete cell comment in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2426
def delete_worksheet_comment( delete_worksheet_comment_request, opts = {})

   data, _status_code, _headers = delete_worksheet_comment_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_comments( delete_worksheet_comments_request, opts = {}) click to toggle source

Delete all comments in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2434
def delete_worksheet_comments( delete_worksheet_comments_request, opts = {})

   data, _status_code, _headers = delete_worksheet_comments_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_conditional_formatting( delete_worksheet_conditional_formatting_request, opts = {}) click to toggle source

Remove a conditional formatting.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 829
def delete_worksheet_conditional_formatting( delete_worksheet_conditional_formatting_request, opts = {})

   data, _status_code, _headers = delete_worksheet_conditional_formatting_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_conditional_formatting_area( delete_worksheet_conditional_formatting_area_request, opts = {}) click to toggle source

Remove cell area from conditional formatting.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 837
def delete_worksheet_conditional_formatting_area( delete_worksheet_conditional_formatting_area_request, opts = {})

   data, _status_code, _headers = delete_worksheet_conditional_formatting_area_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_conditional_formattings( delete_worksheet_conditional_formattings_request, opts = {}) click to toggle source

Clear all conditional formattings in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 821
def delete_worksheet_conditional_formattings( delete_worksheet_conditional_formattings_request, opts = {})

   data, _status_code, _headers = delete_worksheet_conditional_formattings_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_date_filter( delete_worksheet_date_filter_request, opts = {}) click to toggle source

Remove a date filter in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 141
def delete_worksheet_date_filter( delete_worksheet_date_filter_request, opts = {})

   data, _status_code, _headers = delete_worksheet_date_filter_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_filter( delete_worksheet_filter_request, opts = {}) click to toggle source

Delete a filter for a column in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 149
def delete_worksheet_filter( delete_worksheet_filter_request, opts = {})

   data, _status_code, _headers = delete_worksheet_filter_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_freeze_panes( delete_worksheet_freeze_panes_request, opts = {}) click to toggle source

Unfreeze panes in worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2546
def delete_worksheet_freeze_panes( delete_worksheet_freeze_panes_request, opts = {})

   data, _status_code, _headers = delete_worksheet_freeze_panes_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_list_object( delete_worksheet_list_object_request, opts = {}) click to toggle source

Delete list object by index in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1246
def delete_worksheet_list_object( delete_worksheet_list_object_request, opts = {})

   data, _status_code, _headers = delete_worksheet_list_object_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_list_objects( delete_worksheet_list_objects_request, opts = {}) click to toggle source

Delete ListObjects in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1238
def delete_worksheet_list_objects( delete_worksheet_list_objects_request, opts = {})

   data, _status_code, _headers = delete_worksheet_list_objects_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_ole_object( delete_worksheet_ole_object_request, opts = {}) click to toggle source

Delete an OLE object in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1342
def delete_worksheet_ole_object( delete_worksheet_ole_object_request, opts = {})

   data, _status_code, _headers = delete_worksheet_ole_object_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_ole_objects( delete_worksheet_ole_objects_request, opts = {}) click to toggle source

Delete all OLE objects in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1334
def delete_worksheet_ole_objects( delete_worksheet_ole_objects_request, opts = {})

   data, _status_code, _headers = delete_worksheet_ole_objects_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_picture( delete_worksheet_picture_request, opts = {}) click to toggle source

Delete a picture object by index in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1550
def delete_worksheet_picture( delete_worksheet_picture_request, opts = {})

   data, _status_code, _headers = delete_worksheet_picture_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_pictures( delete_worksheet_pictures_request, opts = {}) click to toggle source

Delete all pictures in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1558
def delete_worksheet_pictures( delete_worksheet_pictures_request, opts = {})

   data, _status_code, _headers = delete_worksheet_pictures_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_pivot_table( delete_worksheet_pivot_table_request, opts = {}) click to toggle source

Delete PivotTable by index in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1702
def delete_worksheet_pivot_table( delete_worksheet_pivot_table_request, opts = {})

   data, _status_code, _headers = delete_worksheet_pivot_table_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_pivot_table_filter( delete_worksheet_pivot_table_filter_request, opts = {}) click to toggle source

Delete a pivot filter in the PivotTable.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1726
def delete_worksheet_pivot_table_filter( delete_worksheet_pivot_table_filter_request, opts = {})

   data, _status_code, _headers = delete_worksheet_pivot_table_filter_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_pivot_table_filters( delete_worksheet_pivot_table_filters_request, opts = {}) click to toggle source

Delete all pivot filters in the PivotTable.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1718
def delete_worksheet_pivot_table_filters( delete_worksheet_pivot_table_filters_request, opts = {})

   data, _status_code, _headers = delete_worksheet_pivot_table_filters_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_pivot_tables( delete_worksheet_pivot_tables_request, opts = {}) click to toggle source

Delete PivotTables in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1694
def delete_worksheet_pivot_tables( delete_worksheet_pivot_tables_request, opts = {})

   data, _status_code, _headers = delete_worksheet_pivot_tables_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_row( delete_worksheet_row_request, opts = {}) click to toggle source

Delete a row in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 453
def delete_worksheet_row( delete_worksheet_row_request, opts = {})

   data, _status_code, _headers = delete_worksheet_row_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_rows( delete_worksheet_rows_request, opts = {}) click to toggle source

Delete several rows in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 461
def delete_worksheet_rows( delete_worksheet_rows_request, opts = {})

   data, _status_code, _headers = delete_worksheet_rows_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_shape( delete_worksheet_shape_request, opts = {}) click to toggle source

Delete a shape in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1990
def delete_worksheet_shape( delete_worksheet_shape_request, opts = {})

   data, _status_code, _headers = delete_worksheet_shape_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_shapes( delete_worksheet_shapes_request, opts = {}) click to toggle source

Delete all shapes in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1982
def delete_worksheet_shapes( delete_worksheet_shapes_request, opts = {})

   data, _status_code, _headers = delete_worksheet_shapes_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_sparkline_group( delete_worksheet_sparkline_group_request, opts = {}) click to toggle source

Delete a sparkline group in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2046
def delete_worksheet_sparkline_group( delete_worksheet_sparkline_group_request, opts = {})

   data, _status_code, _headers = delete_worksheet_sparkline_group_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_sparkline_groups( delete_worksheet_sparkline_groups_request, opts = {}) click to toggle source

Delete sparkline groups in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2038
def delete_worksheet_sparkline_groups( delete_worksheet_sparkline_groups_request, opts = {})

   data, _status_code, _headers = delete_worksheet_sparkline_groups_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_validation( delete_worksheet_validation_request, opts = {}) click to toggle source

Delete a validation by index in worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2642
def delete_worksheet_validation( delete_worksheet_validation_request, opts = {})

   data, _status_code, _headers = delete_worksheet_validation_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheet_validations( delete_worksheet_validations_request, opts = {}) click to toggle source

Delete all validations in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2650
def delete_worksheet_validations( delete_worksheet_validations_request, opts = {})

   data, _status_code, _headers = delete_worksheet_validations_request.create_http_request(@api_client,opts )
   return data
end
delete_worksheets( delete_worksheets_request, opts = {}) click to toggle source

Delete matched worksheets in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2354
def delete_worksheets( delete_worksheets_request, opts = {})

   data, _status_code, _headers = delete_worksheets_request.create_http_request(@api_client,opts )
   return data
end
download_file( download_file_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2657
def download_file( download_file_request, opts = {})

   data, _status_code, _headers = download_file_request.create_http_request(@api_client,opts )
   return data
end
get_cell_html_string( get_cell_html_string_request, opts = {}) click to toggle source

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

# File lib/aspose_cells_cloud/api/cells_api.rb, line 317
def get_cell_html_string( get_cell_html_string_request, opts = {})

   data, _status_code, _headers = get_cell_html_string_request.create_http_request(@api_client,opts )
   return data
end
get_cells_cloud_service_status( get_cells_cloud_service_status_request, opts = {}) click to toggle source

Aspose.Cells Cloud service health status check.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 549
def get_cells_cloud_service_status( get_cells_cloud_service_status_request, opts = {})

   data, _status_code, _headers = get_cells_cloud_service_status_request.create_http_request(@api_client,opts )
   return data
end
get_cells_cloud_services_health_check( get_cells_cloud_services_health_check_request, opts = {}) click to toggle source

Retrieve cell descriptions in a specified format.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 541
def get_cells_cloud_services_health_check( get_cells_cloud_services_health_check_request, opts = {})

   data, _status_code, _headers = get_cells_cloud_services_health_check_request.create_http_request(@api_client,opts )
   return data
end
get_chart_area( get_chart_area_request, opts = {}) click to toggle source

Retrieve chart area description in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 557
def get_chart_area( get_chart_area_request, opts = {})

   data, _status_code, _headers = get_chart_area_request.create_http_request(@api_client,opts )
   return data
end
get_chart_area_border( get_chart_area_border_request, opts = {}) click to toggle source

Retrieve chart area border description.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 573
def get_chart_area_border( get_chart_area_border_request, opts = {})

   data, _status_code, _headers = get_chart_area_border_request.create_http_request(@api_client,opts )
   return data
end
get_chart_area_fill_format( get_chart_area_fill_format_request, opts = {}) click to toggle source

Retrieve chart area fill format description in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 565
def get_chart_area_fill_format( get_chart_area_fill_format_request, opts = {})

   data, _status_code, _headers = get_chart_area_fill_format_request.create_http_request(@api_client,opts )
   return data
end
get_chart_category_axis( get_chart_category_axis_request, opts = {}) click to toggle source

Retrieve descriptions of chart series axis in the chart.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 701
def get_chart_category_axis( get_chart_category_axis_request, opts = {})

   data, _status_code, _headers = get_chart_category_axis_request.create_http_request(@api_client,opts )
   return data
end
get_chart_second_category_axis( get_chart_second_category_axis_request, opts = {}) click to toggle source

Retrieve chart second category axis in the chart

# File lib/aspose_cells_cloud/api/cells_api.rb, line 717
def get_chart_second_category_axis( get_chart_second_category_axis_request, opts = {})

   data, _status_code, _headers = get_chart_second_category_axis_request.create_http_request(@api_client,opts )
   return data
end
get_chart_second_value_axis( get_chart_second_value_axis_request, opts = {}) click to toggle source

Retrieve chart second value axis in the chart.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 725
def get_chart_second_value_axis( get_chart_second_value_axis_request, opts = {})

   data, _status_code, _headers = get_chart_second_value_axis_request.create_http_request(@api_client,opts )
   return data
end
get_chart_series_axis( get_chart_series_axis_request, opts = {}) click to toggle source

Retrieve descriptions of chart seriesaxis in the chart.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 693
def get_chart_series_axis( get_chart_series_axis_request, opts = {})

   data, _status_code, _headers = get_chart_series_axis_request.create_http_request(@api_client,opts )
   return data
end
get_chart_value_axis( get_chart_value_axis_request, opts = {}) click to toggle source

Retrieve chart value axis in the chart.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 709
def get_chart_value_axis( get_chart_value_axis_request, opts = {})

   data, _status_code, _headers = get_chart_value_axis_request.create_http_request(@api_client,opts )
   return data
end
get_disc_usage( get_disc_usage_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2741
def get_disc_usage( get_disc_usage_request, opts = {})

   data, _status_code, _headers = get_disc_usage_request.create_http_request(@api_client,opts )
   return data
end
get_document_properties( get_document_properties_request, opts = {}) click to toggle source

Retrieve descriptions of Excel file properties.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1734
def get_document_properties( get_document_properties_request, opts = {})

   data, _status_code, _headers = get_document_properties_request.create_http_request(@api_client,opts )
   return data
end
get_document_property( get_document_property_request, opts = {}) click to toggle source

Get Excel property by name.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1750
def get_document_property( get_document_property_request, opts = {})

   data, _status_code, _headers = get_document_property_request.create_http_request(@api_client,opts )
   return data
end
get_file_versions( get_file_versions_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2748
def get_file_versions( get_file_versions_request, opts = {})

   data, _status_code, _headers = get_file_versions_request.create_http_request(@api_client,opts )
   return data
end
get_files_list( get_files_list_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2692
def get_files_list( get_files_list_request, opts = {})

   data, _status_code, _headers = get_files_list_request.create_http_request(@api_client,opts )
   return data
end
get_header( get_header_request, opts = {}) click to toggle source

Retrieve page header description in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1470
def get_header( get_header_request, opts = {})

   data, _status_code, _headers = get_header_request.create_http_request(@api_client,opts )
   return data
end
get_horizontal_page_break( get_horizontal_page_break_request, opts = {}) click to toggle source

Retrieve a horizontal page break descripton in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1390
def get_horizontal_page_break( get_horizontal_page_break_request, opts = {})

   data, _status_code, _headers = get_horizontal_page_break_request.create_http_request(@api_client,opts )
   return data
end
get_horizontal_page_breaks( get_horizontal_page_breaks_request, opts = {}) click to toggle source

Retrieve descriptions of horizontal page breaks in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1374
def get_horizontal_page_breaks( get_horizontal_page_breaks_request, opts = {})

   data, _status_code, _headers = get_horizontal_page_breaks_request.create_http_request(@api_client,opts )
   return data
end
get_metadata( get_metadata_request, opts = {}) click to toggle source

Get cells document properties.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1198
def get_metadata( get_metadata_request, opts = {})

   data, _status_code, _headers = get_metadata_request.create_http_request(@api_client,opts )
   return data
end
get_named_range_value( get_named_range_value_request, opts = {}) click to toggle source

Retrieve values in range.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2586
def get_named_range_value( get_named_range_value_request, opts = {})

   data, _status_code, _headers = get_named_range_value_request.create_http_request(@api_client,opts )
   return data
end
get_named_ranges( get_named_ranges_request, opts = {}) click to toggle source

Retrieve descriptions of ranges in the worksheets.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2578
def get_named_ranges( get_named_ranges_request, opts = {})

   data, _status_code, _headers = get_named_ranges_request.create_http_request(@api_client,opts )
   return data
end
get_page_count( get_page_count_request, opts = {}) click to toggle source

Get page count in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2290
def get_page_count( get_page_count_request, opts = {})

   data, _status_code, _headers = get_page_count_request.create_http_request(@api_client,opts )
   return data
end
get_page_setup( get_page_setup_request, opts = {}) click to toggle source

Retrieve page setup description in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1446
def get_page_setup( get_page_setup_request, opts = {})

   data, _status_code, _headers = get_page_setup_request.create_http_request(@api_client,opts )
   return data
end
get_pivot_table_field( get_pivot_table_field_request, opts = {}) click to toggle source

Retrieve descriptions of pivot fields in the PivotTable.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1582
def get_pivot_table_field( get_pivot_table_field_request, opts = {})

   data, _status_code, _headers = get_pivot_table_field_request.create_http_request(@api_client,opts )
   return data
end
get_vertical_page_break( get_vertical_page_break_request, opts = {}) click to toggle source

Retrieve a vertical page break description in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1382
def get_vertical_page_break( get_vertical_page_break_request, opts = {})

   data, _status_code, _headers = get_vertical_page_break_request.create_http_request(@api_client,opts )
   return data
end
get_vertical_page_breaks( get_vertical_page_breaks_request, opts = {}) click to toggle source

Retrieve descriptions of vertical page breaks in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1366
def get_vertical_page_breaks( get_vertical_page_breaks_request, opts = {})

   data, _status_code, _headers = get_vertical_page_breaks_request.create_http_request(@api_client,opts )
   return data
end
get_workbook( get_workbook_request, opts = {}) click to toggle source

Retrieve workbooks in various formats.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 845
def get_workbook( get_workbook_request, opts = {})

   data, _status_code, _headers = get_workbook_request.create_http_request(@api_client,opts )
   return data
end
get_workbook_default_style( get_workbook_default_style_request, opts = {}) click to toggle source

Retrieve the description of the default style for the workbook .

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2106
def get_workbook_default_style( get_workbook_default_style_request, opts = {})

   data, _status_code, _headers = get_workbook_default_style_request.create_http_request(@api_client,opts )
   return data
end
get_workbook_name( get_workbook_name_request, opts = {}) click to toggle source

Retrieve description of a named range in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2138
def get_workbook_name( get_workbook_name_request, opts = {})

   data, _status_code, _headers = get_workbook_name_request.create_http_request(@api_client,opts )
   return data
end
get_workbook_name_value( get_workbook_name_value_request, opts = {}) click to toggle source

Retrieve the value of a named range in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2154
def get_workbook_name_value( get_workbook_name_value_request, opts = {})

   data, _status_code, _headers = get_workbook_name_value_request.create_http_request(@api_client,opts )
   return data
end
get_workbook_names( get_workbook_names_request, opts = {}) click to toggle source

Retrieve named ranges in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2122
def get_workbook_names( get_workbook_names_request, opts = {})

   data, _status_code, _headers = get_workbook_names_request.create_http_request(@api_client,opts )
   return data
end
get_workbook_settings( get_workbook_settings_request, opts = {}) click to toggle source

Retrieve descriptions of workbook settings.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2250
def get_workbook_settings( get_workbook_settings_request, opts = {})

   data, _status_code, _headers = get_workbook_settings_request.create_http_request(@api_client,opts )
   return data
end
get_workbook_text_items( get_workbook_text_items_request, opts = {}) click to toggle source

Retrieve text items in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2114
def get_workbook_text_items( get_workbook_text_items_request, opts = {})

   data, _status_code, _headers = get_workbook_text_items_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_auto_filter( get_worksheet_auto_filter_request, opts = {}) click to toggle source

Retrieve the description of auto filters from a worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 53
def get_worksheet_auto_filter( get_worksheet_auto_filter_request, opts = {})

   data, _status_code, _headers = get_worksheet_auto_filter_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_autoshape_with_format( get_worksheet_autoshape_with_format_request, opts = {}) click to toggle source

Get autoshape description in some format.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 165
def get_worksheet_autoshape_with_format( get_worksheet_autoshape_with_format_request, opts = {})

   data, _status_code, _headers = get_worksheet_autoshape_with_format_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_autoshapes( get_worksheet_autoshapes_request, opts = {}) click to toggle source

Get autoshapes description in worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 157
def get_worksheet_autoshapes( get_worksheet_autoshapes_request, opts = {})

   data, _status_code, _headers = get_worksheet_autoshapes_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_calculate_formula( get_worksheet_calculate_formula_request, opts = {}) click to toggle source

Calculate formula in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2458
def get_worksheet_calculate_formula( get_worksheet_calculate_formula_request, opts = {})

   data, _status_code, _headers = get_worksheet_calculate_formula_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_cell( get_worksheet_cell_request, opts = {}) click to toggle source

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

# File lib/aspose_cells_cloud/api/cells_api.rb, line 269
def get_worksheet_cell( get_worksheet_cell_request, opts = {})

   data, _status_code, _headers = get_worksheet_cell_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_cell_style( get_worksheet_cell_style_request, opts = {}) click to toggle source

Retrieve cell style descriptions in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 277
def get_worksheet_cell_style( get_worksheet_cell_style_request, opts = {})

   data, _status_code, _headers = get_worksheet_cell_style_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_cells( get_worksheet_cells_request, opts = {}) click to toggle source

Retrieve cell descriptions in a specified format.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 261
def get_worksheet_cells( get_worksheet_cells_request, opts = {})

   data, _status_code, _headers = get_worksheet_cells_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_cells_range_value( get_worksheet_cells_range_value_request, opts = {}) click to toggle source

Retrieve the values of cells within the specified range.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1886
def get_worksheet_cells_range_value( get_worksheet_cells_range_value_request, opts = {})

   data, _status_code, _headers = get_worksheet_cells_range_value_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_chart( get_worksheet_chart_request, opts = {}) click to toggle source

Retrieve the chart in a specified format.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 589
def get_worksheet_chart( get_worksheet_chart_request, opts = {})

   data, _status_code, _headers = get_worksheet_chart_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_chart_legend( get_worksheet_chart_legend_request, opts = {}) click to toggle source

Retrieve chart legend description in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 621
def get_worksheet_chart_legend( get_worksheet_chart_legend_request, opts = {})

   data, _status_code, _headers = get_worksheet_chart_legend_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_chart_title( get_worksheet_chart_title_request, opts = {}) click to toggle source

Retrieve chart title description in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 661
def get_worksheet_chart_title( get_worksheet_chart_title_request, opts = {})

   data, _status_code, _headers = get_worksheet_chart_title_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_charts( get_worksheet_charts_request, opts = {}) click to toggle source

Retrieve descriptions of charts in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 581
def get_worksheet_charts( get_worksheet_charts_request, opts = {})

   data, _status_code, _headers = get_worksheet_charts_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_column( get_worksheet_column_request, opts = {}) click to toggle source

Retrieve worksheet column data by column index.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 365
def get_worksheet_column( get_worksheet_column_request, opts = {})

   data, _status_code, _headers = get_worksheet_column_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_columns( get_worksheet_columns_request, opts = {}) click to toggle source

Retrieve descriptions of worksheet columns.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 349
def get_worksheet_columns( get_worksheet_columns_request, opts = {})

   data, _status_code, _headers = get_worksheet_columns_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_comment( get_worksheet_comment_request, opts = {}) click to toggle source

Retrieve the description of comment in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2402
def get_worksheet_comment( get_worksheet_comment_request, opts = {})

   data, _status_code, _headers = get_worksheet_comment_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_comments( get_worksheet_comments_request, opts = {}) click to toggle source

Retrieve the description of comments in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2394
def get_worksheet_comments( get_worksheet_comments_request, opts = {})

   data, _status_code, _headers = get_worksheet_comments_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_conditional_formatting( get_worksheet_conditional_formatting_request, opts = {}) click to toggle source

Retrieve conditional formatting descriptions in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 781
def get_worksheet_conditional_formatting( get_worksheet_conditional_formatting_request, opts = {})

   data, _status_code, _headers = get_worksheet_conditional_formatting_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_conditional_formattings( get_worksheet_conditional_formattings_request, opts = {}) click to toggle source

Retrieve descriptions of conditional formattings in a worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 773
def get_worksheet_conditional_formattings( get_worksheet_conditional_formattings_request, opts = {})

   data, _status_code, _headers = get_worksheet_conditional_formattings_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_list_object( get_worksheet_list_object_request, opts = {}) click to toggle source

Retrieve list object description by index in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1222
def get_worksheet_list_object( get_worksheet_list_object_request, opts = {})

   data, _status_code, _headers = get_worksheet_list_object_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_list_objects( get_worksheet_list_objects_request, opts = {}) click to toggle source

Retrieve descriptions of ListObjects in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1214
def get_worksheet_list_objects( get_worksheet_list_objects_request, opts = {})

   data, _status_code, _headers = get_worksheet_list_objects_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_merged_cell( get_worksheet_merged_cell_request, opts = {}) click to toggle source

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

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2450
def get_worksheet_merged_cell( get_worksheet_merged_cell_request, opts = {})

   data, _status_code, _headers = get_worksheet_merged_cell_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_merged_cells( get_worksheet_merged_cells_request, opts = {}) click to toggle source

Get worksheet merged cells.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2442
def get_worksheet_merged_cells( get_worksheet_merged_cells_request, opts = {})

   data, _status_code, _headers = get_worksheet_merged_cells_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_ole_object( get_worksheet_ole_object_request, opts = {}) click to toggle source

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

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1326
def get_worksheet_ole_object( get_worksheet_ole_object_request, opts = {})

   data, _status_code, _headers = get_worksheet_ole_object_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_ole_objects( get_worksheet_ole_objects_request, opts = {}) click to toggle source

Retrieve descriptions of OLE objects in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1318
def get_worksheet_ole_objects( get_worksheet_ole_objects_request, opts = {})

   data, _status_code, _headers = get_worksheet_ole_objects_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_page_count( get_worksheet_page_count_request, opts = {}) click to toggle source

Get page count in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2602
def get_worksheet_page_count( get_worksheet_page_count_request, opts = {})

   data, _status_code, _headers = get_worksheet_page_count_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_picture_with_format( get_worksheet_picture_with_format_request, opts = {}) click to toggle source

Retrieve a picture by number in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1526
def get_worksheet_picture_with_format( get_worksheet_picture_with_format_request, opts = {})

   data, _status_code, _headers = get_worksheet_picture_with_format_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_pictures( get_worksheet_pictures_request, opts = {}) click to toggle source

Retrieve descriptions of pictures in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1518
def get_worksheet_pictures( get_worksheet_pictures_request, opts = {})

   data, _status_code, _headers = get_worksheet_pictures_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_pivot_table( get_worksheet_pivot_table_request, opts = {}) click to toggle source

Retrieve PivotTable information by index in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1574
def get_worksheet_pivot_table( get_worksheet_pivot_table_request, opts = {})

   data, _status_code, _headers = get_worksheet_pivot_table_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_pivot_table_filter( get_worksheet_pivot_table_filter_request, opts = {}) click to toggle source

Retrieve PivotTable filters in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1598
def get_worksheet_pivot_table_filter( get_worksheet_pivot_table_filter_request, opts = {})

   data, _status_code, _headers = get_worksheet_pivot_table_filter_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_pivot_table_filters( get_worksheet_pivot_table_filters_request, opts = {}) click to toggle source

Gets PivotTable filters in worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1590
def get_worksheet_pivot_table_filters( get_worksheet_pivot_table_filters_request, opts = {})

   data, _status_code, _headers = get_worksheet_pivot_table_filters_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_pivot_tables( get_worksheet_pivot_tables_request, opts = {}) click to toggle source

Retrieve descriptions of pivottables in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1566
def get_worksheet_pivot_tables( get_worksheet_pivot_tables_request, opts = {})

   data, _status_code, _headers = get_worksheet_pivot_tables_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_row( get_worksheet_row_request, opts = {}) click to toggle source

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

# File lib/aspose_cells_cloud/api/cells_api.rb, line 445
def get_worksheet_row( get_worksheet_row_request, opts = {})

   data, _status_code, _headers = get_worksheet_row_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_rows( get_worksheet_rows_request, opts = {}) click to toggle source

Retrieve descriptions of rows in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 437
def get_worksheet_rows( get_worksheet_rows_request, opts = {})

   data, _status_code, _headers = get_worksheet_rows_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_shape( get_worksheet_shape_request, opts = {}) click to toggle source

Retrieve description of shape in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1966
def get_worksheet_shape( get_worksheet_shape_request, opts = {})

   data, _status_code, _headers = get_worksheet_shape_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_shapes( get_worksheet_shapes_request, opts = {}) click to toggle source

Retrieve descriptions of shapes in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1958
def get_worksheet_shapes( get_worksheet_shapes_request, opts = {})

   data, _status_code, _headers = get_worksheet_shapes_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_sparkline_group( get_worksheet_sparkline_group_request, opts = {}) click to toggle source

Retrieve description of a sparkline group in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2030
def get_worksheet_sparkline_group( get_worksheet_sparkline_group_request, opts = {})

   data, _status_code, _headers = get_worksheet_sparkline_group_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_sparkline_groups( get_worksheet_sparkline_groups_request, opts = {}) click to toggle source

Retrieve descriptions of sparkline groups in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2022
def get_worksheet_sparkline_groups( get_worksheet_sparkline_groups_request, opts = {})

   data, _status_code, _headers = get_worksheet_sparkline_groups_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_text_items( get_worksheet_text_items_request, opts = {}) click to toggle source

Retrieve text items in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2386
def get_worksheet_text_items( get_worksheet_text_items_request, opts = {})

   data, _status_code, _headers = get_worksheet_text_items_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_validation( get_worksheet_validation_request, opts = {}) click to toggle source

Retrieve a validation by its index in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2618
def get_worksheet_validation( get_worksheet_validation_request, opts = {})

   data, _status_code, _headers = get_worksheet_validation_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_validations( get_worksheet_validations_request, opts = {}) click to toggle source

Retrieve descriptions of validations in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2610
def get_worksheet_validations( get_worksheet_validations_request, opts = {})

   data, _status_code, _headers = get_worksheet_validations_request.create_http_request(@api_client,opts )
   return data
end
get_worksheet_with_format( get_worksheet_with_format_request, opts = {}) click to toggle source

Retrieve the worksheet in a specified format from the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2306
def get_worksheet_with_format( get_worksheet_with_format_request, opts = {})

   data, _status_code, _headers = get_worksheet_with_format_request.create_http_request(@api_client,opts )
   return data
end
get_worksheets( get_worksheets_request, opts = {}) click to toggle source

Retrieve the description of worksheets from a workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2298
def get_worksheets( get_worksheets_request, opts = {})

   data, _status_code, _headers = get_worksheets_request.create_http_request(@api_client,opts )
   return data
end
move_file( move_file_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2678
def move_file( move_file_request, opts = {})

   data, _status_code, _headers = move_file_request.create_http_request(@api_client,opts )
   return data
end
move_folder( move_folder_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2713
def move_folder( move_folder_request, opts = {})

   data, _status_code, _headers = move_folder_request.create_http_request(@api_client,opts )
   return data
end
object_exists( object_exists_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2734
def object_exists( object_exists_request, opts = {})

   data, _status_code, _headers = object_exists_request.create_http_request(@api_client,opts )
   return data
end
post_access_token( post_access_token_request, opts = {}) click to toggle source

Get Access Token Result

# File lib/aspose_cells_cloud/api/cells_api.rb, line 213
def post_access_token( post_access_token_request, opts = {})

   data, _status_code, _headers = post_access_token_request.create_http_request(@api_client,opts )
   return data
end
post_add_text_content( post_add_text_content_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2077
def post_add_text_content( post_add_text_content_request, opts = {})

   data, _status_code, _headers = post_add_text_content_request.create_http_request(@api_client,opts )
   return data
end
post_analyze_excel( post_analyze_excel_request, opts = {}) click to toggle source

Perform business analysis of data in Excel files.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 45
def post_analyze_excel( post_analyze_excel_request, opts = {})

   data, _status_code, _headers = post_analyze_excel_request.create_http_request(@api_client,opts )
   return data
end
post_assemble( post_assemble_request, opts = {}) click to toggle source

Assemble data files with template files to generate files in various formats.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1094
def post_assemble( post_assemble_request, opts = {})

   data, _status_code, _headers = post_assemble_request.create_http_request(@api_client,opts )
   return data
end
post_autofit_workbook_columns( post_autofit_workbook_columns_request, opts = {}) click to toggle source

Autofit columns in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2242
def post_autofit_workbook_columns( post_autofit_workbook_columns_request, opts = {})

   data, _status_code, _headers = post_autofit_workbook_columns_request.create_http_request(@api_client,opts )
   return data
end
post_autofit_workbook_rows( post_autofit_workbook_rows_request, opts = {}) click to toggle source

Autofit rows in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2234
def post_autofit_workbook_rows( post_autofit_workbook_rows_request, opts = {})

   data, _status_code, _headers = post_autofit_workbook_rows_request.create_http_request(@api_client,opts )
   return data
end
post_autofit_worksheet_columns( post_autofit_worksheet_columns_request, opts = {}) click to toggle source

Autofit columns in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2514
def post_autofit_worksheet_columns( post_autofit_worksheet_columns_request, opts = {})

   data, _status_code, _headers = post_autofit_worksheet_columns_request.create_http_request(@api_client,opts )
   return data
end
post_autofit_worksheet_row( post_autofit_worksheet_row_request, opts = {}) click to toggle source

Autofit a row in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2498
def post_autofit_worksheet_row( post_autofit_worksheet_row_request, opts = {})

   data, _status_code, _headers = post_autofit_worksheet_row_request.create_http_request(@api_client,opts )
   return data
end
post_autofit_worksheet_rows( post_autofit_worksheet_rows_request, opts = {}) click to toggle source

Autofit rows in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2506
def post_autofit_worksheet_rows( post_autofit_worksheet_rows_request, opts = {})

   data, _status_code, _headers = post_autofit_worksheet_rows_request.create_http_request(@api_client,opts )
   return data
end
post_batch_convert( post_batch_convert_request, opts = {}) click to toggle source

Batch converting files that meet specific matching conditions.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 173
def post_batch_convert( post_batch_convert_request, opts = {})

   data, _status_code, _headers = post_batch_convert_request.create_http_request(@api_client,opts )
   return data
end
post_batch_lock( post_batch_lock_request, opts = {}) click to toggle source

Batch locking files that meet specific matching conditions.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 189
def post_batch_lock( post_batch_lock_request, opts = {})

   data, _status_code, _headers = post_batch_lock_request.create_http_request(@api_client,opts )
   return data
end
post_batch_protect( post_batch_protect_request, opts = {}) click to toggle source

Batch protecting files that meet specific matching conditions.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 181
def post_batch_protect( post_batch_protect_request, opts = {})

   data, _status_code, _headers = post_batch_protect_request.create_http_request(@api_client,opts )
   return data
end
post_batch_split( post_batch_split_request, opts = {}) click to toggle source

Batch splitting files that meet specific matching conditions.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 205
def post_batch_split( post_batch_split_request, opts = {})

   data, _status_code, _headers = post_batch_split_request.create_http_request(@api_client,opts )
   return data
end
post_batch_unlock( post_batch_unlock_request, opts = {}) click to toggle source

Batch unlocking files that meet specific matching conditions.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 197
def post_batch_unlock( post_batch_unlock_request, opts = {})

   data, _status_code, _headers = post_batch_unlock_request.create_http_request(@api_client,opts )
   return data
end
post_cell_calculate( post_cell_calculate_request, opts = {}) click to toggle source

Calculate cell formula in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 333
def post_cell_calculate( post_cell_calculate_request, opts = {})

   data, _status_code, _headers = post_cell_calculate_request.create_http_request(@api_client,opts )
   return data
end
post_cell_characters( post_cell_characters_request, opts = {}) click to toggle source

Set cell characters in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 341
def post_cell_characters( post_cell_characters_request, opts = {})

   data, _status_code, _headers = post_cell_characters_request.create_http_request(@api_client,opts )
   return data
end
post_chart_category_axis( post_chart_category_axis_request, opts = {}) click to toggle source

Update chart category axis in the chart.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 741
def post_chart_category_axis( post_chart_category_axis_request, opts = {})

   data, _status_code, _headers = post_chart_category_axis_request.create_http_request(@api_client,opts )
   return data
end
post_chart_second_category_axis( post_chart_second_category_axis_request, opts = {}) click to toggle source

Update chart sencond category axis in the chart.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 757
def post_chart_second_category_axis( post_chart_second_category_axis_request, opts = {})

   data, _status_code, _headers = post_chart_second_category_axis_request.create_http_request(@api_client,opts )
   return data
end
post_chart_second_value_axis( post_chart_second_value_axis_request, opts = {}) click to toggle source

Update chart sencond value axis in the chart.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 765
def post_chart_second_value_axis( post_chart_second_value_axis_request, opts = {})

   data, _status_code, _headers = post_chart_second_value_axis_request.create_http_request(@api_client,opts )
   return data
end
post_chart_series_axis( post_chart_series_axis_request, opts = {}) click to toggle source

Update chart series axis in the chart.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 733
def post_chart_series_axis( post_chart_series_axis_request, opts = {})

   data, _status_code, _headers = post_chart_series_axis_request.create_http_request(@api_client,opts )
   return data
end
post_chart_value_axis( post_chart_value_axis_request, opts = {}) click to toggle source

Update chart value axis in the chart.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 749
def post_chart_value_axis( post_chart_value_axis_request, opts = {})

   data, _status_code, _headers = post_chart_value_axis_request.create_http_request(@api_client,opts )
   return data
end
post_clear_contents( post_clear_contents_request, opts = {}) click to toggle source

Clear cell area contents in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 221
def post_clear_contents( post_clear_contents_request, opts = {})

   data, _status_code, _headers = post_clear_contents_request.create_http_request(@api_client,opts )
   return data
end
post_clear_formats( post_clear_formats_request, opts = {}) click to toggle source

Clear cell formats in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 229
def post_clear_formats( post_clear_formats_request, opts = {})

   data, _status_code, _headers = post_clear_formats_request.create_http_request(@api_client,opts )
   return data
end
post_clear_objects( post_clear_objects_request, opts = {}) click to toggle source

Clear internal elements in Excel files and generate output files in various formats.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1158
def post_clear_objects( post_clear_objects_request, opts = {})

   data, _status_code, _headers = post_clear_objects_request.create_http_request(@api_client,opts )
   return data
end
post_column_style( post_column_style_request, opts = {}) click to toggle source

Set column style in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 429
def post_column_style( post_column_style_request, opts = {})

   data, _status_code, _headers = post_column_style_request.create_http_request(@api_client,opts )
   return data
end
post_compress( post_compress_request, opts = {}) click to toggle source

Compress files and generate target files in various formats, supported file formats are include Xls, Xlsx, Xlsm, Xlsb, Ods and more.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1102
def post_compress( post_compress_request, opts = {})

   data, _status_code, _headers = post_compress_request.create_http_request(@api_client,opts )
   return data
end
post_convert_workbook_to_csv( post_convert_workbook_to_csv_request, opts = {}) click to toggle source

Convert Excel file to Csv files.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 933
def post_convert_workbook_to_csv( post_convert_workbook_to_csv_request, opts = {})

   data, _status_code, _headers = post_convert_workbook_to_csv_request.create_http_request(@api_client,opts )
   return data
end
post_convert_workbook_to_docx( post_convert_workbook_to_docx_request, opts = {}) click to toggle source

Convert Excel file to Docx files.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 885
def post_convert_workbook_to_docx( post_convert_workbook_to_docx_request, opts = {})

   data, _status_code, _headers = post_convert_workbook_to_docx_request.create_http_request(@api_client,opts )
   return data
end
post_convert_workbook_to_html( post_convert_workbook_to_html_request, opts = {}) click to toggle source

Convert Excel file to HTML files.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 901
def post_convert_workbook_to_html( post_convert_workbook_to_html_request, opts = {})

   data, _status_code, _headers = post_convert_workbook_to_html_request.create_http_request(@api_client,opts )
   return data
end
post_convert_workbook_to_json( post_convert_workbook_to_json_request, opts = {}) click to toggle source

Convert Excel file to Json files.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 917
def post_convert_workbook_to_json( post_convert_workbook_to_json_request, opts = {})

   data, _status_code, _headers = post_convert_workbook_to_json_request.create_http_request(@api_client,opts )
   return data
end
post_convert_workbook_to_markdown( post_convert_workbook_to_markdown_request, opts = {}) click to toggle source

Convert Excel file to Markdown files.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 909
def post_convert_workbook_to_markdown( post_convert_workbook_to_markdown_request, opts = {})

   data, _status_code, _headers = post_convert_workbook_to_markdown_request.create_http_request(@api_client,opts )
   return data
end
post_convert_workbook_to_pdf( post_convert_workbook_to_pdf_request, opts = {}) click to toggle source

Convert Excel file to PDF files.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 869
def post_convert_workbook_to_pdf( post_convert_workbook_to_pdf_request, opts = {})

   data, _status_code, _headers = post_convert_workbook_to_pdf_request.create_http_request(@api_client,opts )
   return data
end
post_convert_workbook_to_png( post_convert_workbook_to_png_request, opts = {}) click to toggle source

Convert Excel file to PNG files.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 877
def post_convert_workbook_to_png( post_convert_workbook_to_png_request, opts = {})

   data, _status_code, _headers = post_convert_workbook_to_png_request.create_http_request(@api_client,opts )
   return data
end
post_convert_workbook_to_pptx( post_convert_workbook_to_pptx_request, opts = {}) click to toggle source

Convert Excel file to Pptx files.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 893
def post_convert_workbook_to_pptx( post_convert_workbook_to_pptx_request, opts = {})

   data, _status_code, _headers = post_convert_workbook_to_pptx_request.create_http_request(@api_client,opts )
   return data
end
post_convert_workbook_to_sql( post_convert_workbook_to_sql_request, opts = {}) click to toggle source

Convert Excel file to SQL Script files.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 925
def post_convert_workbook_to_sql( post_convert_workbook_to_sql_request, opts = {})

   data, _status_code, _headers = post_convert_workbook_to_sql_request.create_http_request(@api_client,opts )
   return data
end
post_copy_cell_into_cell( post_copy_cell_into_cell_request, opts = {}) click to toggle source

Copy data from a source cell to a destination cell in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 309
def post_copy_cell_into_cell( post_copy_cell_into_cell_request, opts = {})

   data, _status_code, _headers = post_copy_cell_into_cell_request.create_http_request(@api_client,opts )
   return data
end
post_copy_worksheet( post_copy_worksheet_request, opts = {}) click to toggle source

Copy contents and formats from another worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2554
def post_copy_worksheet( post_copy_worksheet_request, opts = {})

   data, _status_code, _headers = post_copy_worksheet_request.create_http_request(@api_client,opts )
   return data
end
post_copy_worksheet_columns( post_copy_worksheet_columns_request, opts = {}) click to toggle source

Copy data from source columns to destination columns in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 421
def post_copy_worksheet_columns( post_copy_worksheet_columns_request, opts = {})

   data, _status_code, _headers = post_copy_worksheet_columns_request.create_http_request(@api_client,opts )
   return data
end
post_copy_worksheet_rows( post_copy_worksheet_rows_request, opts = {}) click to toggle source

Copy data and formats from specific entire rows in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 525
def post_copy_worksheet_rows( post_copy_worksheet_rows_request, opts = {})

   data, _status_code, _headers = post_copy_worksheet_rows_request.create_http_request(@api_client,opts )
   return data
end
post_data_cleansing( post_data_cleansing_request, opts = {}) click to toggle source

Data cleansing of spreadsheet files is a data management process used to identify, correct, and remove errors, incompleteness, duplicates, or inaccuracies in tables and ranges.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 990
def post_data_cleansing( post_data_cleansing_request, opts = {})

   data, _status_code, _headers = post_data_cleansing_request.create_http_request(@api_client,opts )
   return data
end
post_data_deduplication( post_data_deduplication_request, opts = {}) click to toggle source

Data deduplication of spreadsheet files is mainly used to eliminate duplicate data in tables and ranges.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1006
def post_data_deduplication( post_data_deduplication_request, opts = {})

   data, _status_code, _headers = post_data_deduplication_request.create_http_request(@api_client,opts )
   return data
end
post_data_fill( post_data_fill_request, opts = {}) click to toggle source

Data filling for spreadsheet files is primarily used to fill empty data in tables and ranges.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1022
def post_data_fill( post_data_fill_request, opts = {})

   data, _status_code, _headers = post_data_fill_request.create_http_request(@api_client,opts )
   return data
end
post_data_transformation( post_data_transformation_request, opts = {}) click to toggle source

Transform spreadsheet data is mainly used to pivot columns, unpivot columns.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1038
def post_data_transformation( post_data_transformation_request, opts = {})

   data, _status_code, _headers = post_data_transformation_request.create_http_request(@api_client,opts )
   return data
end
post_delete_incomplete_rows( post_delete_incomplete_rows_request, opts = {}) click to toggle source

Deleting incomplete rows of spreadsheet files is mainly used to eliminate incomplete rows in tables and ranges.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1030
def post_delete_incomplete_rows( post_delete_incomplete_rows_request, opts = {})

   data, _status_code, _headers = post_delete_incomplete_rows_request.create_http_request(@api_client,opts )
   return data
end
post_digital_signature( post_digital_signature_request, opts = {}) click to toggle source

Excel file digital signature.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1774
def post_digital_signature( post_digital_signature_request, opts = {})

   data, _status_code, _headers = post_digital_signature_request.create_http_request(@api_client,opts )
   return data
end
post_encrypt_workbook( post_encrypt_workbook_request, opts = {}) click to toggle source

Excel Encryption.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1782
def post_encrypt_workbook( post_encrypt_workbook_request, opts = {})

   data, _status_code, _headers = post_encrypt_workbook_request.create_http_request(@api_client,opts )
   return data
end
post_export( post_export_request, opts = {}) click to toggle source

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

# File lib/aspose_cells_cloud/api/cells_api.rb, line 941
def post_export( post_export_request, opts = {})

   data, _status_code, _headers = post_export_request.create_http_request(@api_client,opts )
   return data
end
post_fit_tall_to_pages( post_fit_tall_to_pages_request, opts = {}) click to toggle source

Set the scale at which the page will fit tall when printed on the sheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1510
def post_fit_tall_to_pages( post_fit_tall_to_pages_request, opts = {})

   data, _status_code, _headers = post_fit_tall_to_pages_request.create_http_request(@api_client,opts )
   return data
end
post_fit_wide_to_pages( post_fit_wide_to_pages_request, opts = {}) click to toggle source

Set the scale at which the page will fit wide when printed on the sheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1502
def post_fit_wide_to_pages( post_fit_wide_to_pages_request, opts = {})

   data, _status_code, _headers = post_fit_wide_to_pages_request.create_http_request(@api_client,opts )
   return data
end
post_footer( post_footer_request, opts = {}) click to toggle source

Update page footer in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1494
def post_footer( post_footer_request, opts = {})

   data, _status_code, _headers = post_footer_request.create_http_request(@api_client,opts )
   return data
end
post_group_worksheet_columns( post_group_worksheet_columns_request, opts = {}) click to toggle source

Group worksheet columns in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 405
def post_group_worksheet_columns( post_group_worksheet_columns_request, opts = {})

   data, _status_code, _headers = post_group_worksheet_columns_request.create_http_request(@api_client,opts )
   return data
end
post_group_worksheet_rows( post_group_worksheet_rows_request, opts = {}) click to toggle source

Group rows in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 509
def post_group_worksheet_rows( post_group_worksheet_rows_request, opts = {})

   data, _status_code, _headers = post_group_worksheet_rows_request.create_http_request(@api_client,opts )
   return data
end
post_header( post_header_request, opts = {}) click to toggle source

Update page header in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1478
def post_header( post_header_request, opts = {})

   data, _status_code, _headers = post_header_request.create_http_request(@api_client,opts )
   return data
end
post_hide_worksheet_columns( post_hide_worksheet_columns_request, opts = {}) click to toggle source

Hide worksheet columns in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 389
def post_hide_worksheet_columns( post_hide_worksheet_columns_request, opts = {})

   data, _status_code, _headers = post_hide_worksheet_columns_request.create_http_request(@api_client,opts )
   return data
end
post_hide_worksheet_rows( post_hide_worksheet_rows_request, opts = {}) click to toggle source

Hide rows in worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 493
def post_hide_worksheet_rows( post_hide_worksheet_rows_request, opts = {})

   data, _status_code, _headers = post_hide_worksheet_rows_request.create_http_request(@api_client,opts )
   return data
end
post_import( post_import_request, opts = {}) click to toggle source

Import data into an Excel file and generate output files in various formats.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1142
def post_import( post_import_request, opts = {})

   data, _status_code, _headers = post_import_request.create_http_request(@api_client,opts )
   return data
end
post_import_data( post_import_data_request, opts = {}) click to toggle source

Import data into the Excel file.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 974
def post_import_data( post_import_data_request, opts = {})

   data, _status_code, _headers = post_import_data_request.create_http_request(@api_client,opts )
   return data
end
post_lock( post_lock_request, opts = {}) click to toggle source

Lock Excel files.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1838
def post_lock( post_lock_request, opts = {})

   data, _status_code, _headers = post_lock_request.create_http_request(@api_client,opts )
   return data
end
post_merge( post_merge_request, opts = {}) click to toggle source

Merge cells in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1110
def post_merge( post_merge_request, opts = {})

   data, _status_code, _headers = post_merge_request.create_http_request(@api_client,opts )
   return data
end
post_metadata( post_metadata_request, opts = {}) click to toggle source

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

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1190
def post_metadata( post_metadata_request, opts = {})

   data, _status_code, _headers = post_metadata_request.create_http_request(@api_client,opts )
   return data
end
post_move_worksheet( post_move_worksheet_request, opts = {}) click to toggle source

Move worksheet in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2362
def post_move_worksheet( post_move_worksheet_request, opts = {})

   data, _status_code, _headers = post_move_worksheet_request.create_http_request(@api_client,opts )
   return data
end
post_page_setup( post_page_setup_request, opts = {}) click to toggle source

Update page setup in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1454
def post_page_setup( post_page_setup_request, opts = {})

   data, _status_code, _headers = post_page_setup_request.create_http_request(@api_client,opts )
   return data
end
post_pivot_table_cell_style( post_pivot_table_cell_style_request, opts = {}) click to toggle source

Update cell style in the PivotTable.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1646
def post_pivot_table_cell_style( post_pivot_table_cell_style_request, opts = {})

   data, _status_code, _headers = post_pivot_table_cell_style_request.create_http_request(@api_client,opts )
   return data
end
post_pivot_table_field_hide_item( post_pivot_table_field_hide_item_request, opts = {}) click to toggle source

Hide a pivot field item in the PivotTable.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1630
def post_pivot_table_field_hide_item( post_pivot_table_field_hide_item_request, opts = {})

   data, _status_code, _headers = post_pivot_table_field_hide_item_request.create_http_request(@api_client,opts )
   return data
end
post_pivot_table_field_move_to( post_pivot_table_field_move_to_request, opts = {}) click to toggle source

Move a pivot field in the PivotTable.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1638
def post_pivot_table_field_move_to( post_pivot_table_field_move_to_request, opts = {})

   data, _status_code, _headers = post_pivot_table_field_move_to_request.create_http_request(@api_client,opts )
   return data
end
post_pivot_table_style( post_pivot_table_style_request, opts = {}) click to toggle source

Update style in the PivotTable.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1654
def post_pivot_table_style( post_pivot_table_style_request, opts = {})

   data, _status_code, _headers = post_pivot_table_style_request.create_http_request(@api_client,opts )
   return data
end
post_pivot_table_update_pivot_field( post_pivot_table_update_pivot_field_request, opts = {}) click to toggle source

Update pivot field in the PivotTable.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1670
def post_pivot_table_update_pivot_field( post_pivot_table_update_pivot_field_request, opts = {})

   data, _status_code, _headers = post_pivot_table_update_pivot_field_request.create_http_request(@api_client,opts )
   return data
end
post_pivot_table_update_pivot_fields( post_pivot_table_update_pivot_fields_request, opts = {}) click to toggle source

Update pivot fields in the PivotTable.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1662
def post_pivot_table_update_pivot_fields( post_pivot_table_update_pivot_fields_request, opts = {})

   data, _status_code, _headers = post_pivot_table_update_pivot_fields_request.create_http_request(@api_client,opts )
   return data
end
post_protect( post_protect_request, opts = {}) click to toggle source

Excel files encryption.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1846
def post_protect( post_protect_request, opts = {})

   data, _status_code, _headers = post_protect_request.create_http_request(@api_client,opts )
   return data
end
post_protect_workbook( post_protect_workbook_request, opts = {}) click to toggle source

Excel protection.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1798
def post_protect_workbook( post_protect_workbook_request, opts = {})

   data, _status_code, _headers = post_protect_workbook_request.create_http_request(@api_client,opts )
   return data
end
post_remove_characters( post_remove_characters_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2098
def post_remove_characters( post_remove_characters_request, opts = {})

   data, _status_code, _headers = post_remove_characters_request.create_http_request(@api_client,opts )
   return data
end
post_rename_worksheet( post_rename_worksheet_request, opts = {}) click to toggle source

Rename worksheet in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2562
def post_rename_worksheet( post_rename_worksheet_request, opts = {})

   data, _status_code, _headers = post_rename_worksheet_request.create_http_request(@api_client,opts )
   return data
end
post_repair( post_repair_request, opts = {}) click to toggle source

Repair abnormal files and generate files in various formats.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1174
def post_repair( post_repair_request, opts = {})

   data, _status_code, _headers = post_repair_request.create_http_request(@api_client,opts )
   return data
end
post_replace( post_replace_request, opts = {}) click to toggle source

Replace specified text with new text in Excel files.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1134
def post_replace( post_replace_request, opts = {})

   data, _status_code, _headers = post_replace_request.create_http_request(@api_client,opts )
   return data
end
post_reverse( post_reverse_request, opts = {}) click to toggle source

Reverse rows or columns in Excel files and create output files in various formats.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1166
def post_reverse( post_reverse_request, opts = {})

   data, _status_code, _headers = post_reverse_request.create_http_request(@api_client,opts )
   return data
end
post_rotate( post_rotate_request, opts = {}) click to toggle source

Rotate rows, columns, or other objects in Excel files and save them in various formats.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1182
def post_rotate( post_rotate_request, opts = {})

   data, _status_code, _headers = post_rotate_request.create_http_request(@api_client,opts )
   return data
end
post_row_style( post_row_style_request, opts = {}) click to toggle source

Apply formats to an entire row in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 533
def post_row_style( post_row_style_request, opts = {})

   data, _status_code, _headers = post_row_style_request.create_http_request(@api_client,opts )
   return data
end
post_run_task( post_run_task_request, opts = {}) click to toggle source

Run tasks.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2070
def post_run_task( post_run_task_request, opts = {})

   data, _status_code, _headers = post_run_task_request.create_http_request(@api_client,opts )
   return data
end
post_search( post_search_request, opts = {}) click to toggle source

Search for specified text within Excel files.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1126
def post_search( post_search_request, opts = {})

   data, _status_code, _headers = post_search_request.create_http_request(@api_client,opts )
   return data
end
post_set_cell_html_string( post_set_cell_html_string_request, opts = {}) click to toggle source

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

# File lib/aspose_cells_cloud/api/cells_api.rb, line 325
def post_set_cell_html_string( post_set_cell_html_string_request, opts = {})

   data, _status_code, _headers = post_set_cell_html_string_request.create_http_request(@api_client,opts )
   return data
end
post_set_cell_range_value( post_set_cell_range_value_request, opts = {}) click to toggle source

Set the value of the range in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 301
def post_set_cell_range_value( post_set_cell_range_value_request, opts = {})

   data, _status_code, _headers = post_set_cell_range_value_request.create_http_request(@api_client,opts )
   return data
end
post_set_worksheet_column_width( post_set_worksheet_column_width_request, opts = {}) click to toggle source

Set worksheet column width.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 357
def post_set_worksheet_column_width( post_set_worksheet_column_width_request, opts = {})

   data, _status_code, _headers = post_set_worksheet_column_width_request.create_http_request(@api_client,opts )
   return data
end
post_split( post_split_request, opts = {}) click to toggle source

Split Excel spreadsheet files based on worksheets and create output files in various formats.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1118
def post_split( post_split_request, opts = {})

   data, _status_code, _headers = post_split_request.create_http_request(@api_client,opts )
   return data
end
post_trim_content( post_trim_content_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2084
def post_trim_content( post_trim_content_request, opts = {})

   data, _status_code, _headers = post_trim_content_request.create_http_request(@api_client,opts )
   return data
end
post_ungroup_worksheet_columns( post_ungroup_worksheet_columns_request, opts = {}) click to toggle source

Ungroup worksheet columns.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 413
def post_ungroup_worksheet_columns( post_ungroup_worksheet_columns_request, opts = {})

   data, _status_code, _headers = post_ungroup_worksheet_columns_request.create_http_request(@api_client,opts )
   return data
end
post_ungroup_worksheet_rows( post_ungroup_worksheet_rows_request, opts = {}) click to toggle source

Ungroup rows in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 517
def post_ungroup_worksheet_rows( post_ungroup_worksheet_rows_request, opts = {})

   data, _status_code, _headers = post_ungroup_worksheet_rows_request.create_http_request(@api_client,opts )
   return data
end
post_unhide_worksheet_columns( post_unhide_worksheet_columns_request, opts = {}) click to toggle source

Unhide worksheet columns in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 397
def post_unhide_worksheet_columns( post_unhide_worksheet_columns_request, opts = {})

   data, _status_code, _headers = post_unhide_worksheet_columns_request.create_http_request(@api_client,opts )
   return data
end
post_unhide_worksheet_rows( post_unhide_worksheet_rows_request, opts = {}) click to toggle source

Unhide rows in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 501
def post_unhide_worksheet_rows( post_unhide_worksheet_rows_request, opts = {})

   data, _status_code, _headers = post_unhide_worksheet_rows_request.create_http_request(@api_client,opts )
   return data
end
post_unlock( post_unlock_request, opts = {}) click to toggle source

Unlock Excel files.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1830
def post_unlock( post_unlock_request, opts = {})

   data, _status_code, _headers = post_unlock_request.create_http_request(@api_client,opts )
   return data
end
post_update_word_case( post_update_word_case_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2091
def post_update_word_case( post_update_word_case_request, opts = {})

   data, _status_code, _headers = post_update_word_case_request.create_http_request(@api_client,opts )
   return data
end
post_update_worksheet_cell_style( post_update_worksheet_cell_style_request, opts = {}) click to toggle source

Set cell style using cell name in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 293
def post_update_worksheet_cell_style( post_update_worksheet_cell_style_request, opts = {})

   data, _status_code, _headers = post_update_worksheet_cell_style_request.create_http_request(@api_client,opts )
   return data
end
post_update_worksheet_ole_object( post_update_worksheet_ole_object_request, opts = {}) click to toggle source

Update an OLE object in worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1350
def post_update_worksheet_ole_object( post_update_worksheet_ole_object_request, opts = {})

   data, _status_code, _headers = post_update_worksheet_ole_object_request.create_http_request(@api_client,opts )
   return data
end
post_update_worksheet_property( post_update_worksheet_property_request, opts = {}) click to toggle source

Update worksheet properties in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2570
def post_update_worksheet_property( post_update_worksheet_property_request, opts = {})

   data, _status_code, _headers = post_update_worksheet_property_request.create_http_request(@api_client,opts )
   return data
end
post_update_worksheet_range_style( post_update_worksheet_range_style_request, opts = {}) click to toggle source

Update cell range styles in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 237
def post_update_worksheet_range_style( post_update_worksheet_range_style_request, opts = {})

   data, _status_code, _headers = post_update_worksheet_range_style_request.create_http_request(@api_client,opts )
   return data
end
post_update_worksheet_row( post_update_worksheet_row_request, opts = {}) click to toggle source

Update height of rows in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 485
def post_update_worksheet_row( post_update_worksheet_row_request, opts = {})

   data, _status_code, _headers = post_update_worksheet_row_request.create_http_request(@api_client,opts )
   return data
end
post_update_worksheet_zoom( post_update_worksheet_zoom_request, opts = {}) click to toggle source

Update the scaling percentage in the worksheet. It should be between 10 and 400.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2594
def post_update_worksheet_zoom( post_update_worksheet_zoom_request, opts = {})

   data, _status_code, _headers = post_update_worksheet_zoom_request.create_http_request(@api_client,opts )
   return data
end
post_watermark( post_watermark_request, opts = {}) click to toggle source

Add Text Watermark to Excel files and generate output files in various formats.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1150
def post_watermark( post_watermark_request, opts = {})

   data, _status_code, _headers = post_watermark_request.create_http_request(@api_client,opts )
   return data
end
post_workbook_calculate_formula( post_workbook_calculate_formula_request, opts = {}) click to toggle source

Calculate all formulas in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2226
def post_workbook_calculate_formula( post_workbook_calculate_formula_request, opts = {})

   data, _status_code, _headers = post_workbook_calculate_formula_request.create_http_request(@api_client,opts )
   return data
end
post_workbook_data_cleansing( post_workbook_data_cleansing_request, opts = {}) click to toggle source

Data cleaning of spreadsheet files is a data management process used to identify, correct, and remove errors, incompleteness, duplicates, or inaccuracies in tables and ranges.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 982
def post_workbook_data_cleansing( post_workbook_data_cleansing_request, opts = {})

   data, _status_code, _headers = post_workbook_data_cleansing_request.create_http_request(@api_client,opts )
   return data
end
post_workbook_data_deduplication( post_workbook_data_deduplication_request, opts = {}) click to toggle source

Data deduplication of spreadsheet files is mainly used to eliminate duplicate data in tables and ranges.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 998
def post_workbook_data_deduplication( post_workbook_data_deduplication_request, opts = {})

   data, _status_code, _headers = post_workbook_data_deduplication_request.create_http_request(@api_client,opts )
   return data
end
post_workbook_data_fill( post_workbook_data_fill_request, opts = {}) click to toggle source

Data filling for spreadsheet files is primarily used to fill empty data in tables and ranges.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1014
def post_workbook_data_fill( post_workbook_data_fill_request, opts = {})

   data, _status_code, _headers = post_workbook_data_fill_request.create_http_request(@api_client,opts )
   return data
end
post_workbook_export_xml( post_workbook_export_xml_request, opts = {}) click to toggle source

Export XML data from an Excel file. When there are XML Maps in an Excel file, export XML data. When there is no XML map in the Excel file, convert the Excel file to an XML file.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 950
def post_workbook_export_xml( post_workbook_export_xml_request, opts = {})

   data, _status_code, _headers = post_workbook_export_xml_request.create_http_request(@api_client,opts )
   return data
end
post_workbook_get_smart_marker_result( post_workbook_get_smart_marker_result_request, opts = {}) click to toggle source

Smart marker processing.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2202
def post_workbook_get_smart_marker_result( post_workbook_get_smart_marker_result_request, opts = {})

   data, _status_code, _headers = post_workbook_get_smart_marker_result_request.create_http_request(@api_client,opts )
   return data
end
post_workbook_import_json( post_workbook_import_json_request, opts = {}) click to toggle source

Import a JSON data file into the workbook. The JSON data file can either be a cloud file or data from an HTTP URI.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 958
def post_workbook_import_json( post_workbook_import_json_request, opts = {})

   data, _status_code, _headers = post_workbook_import_json_request.create_http_request(@api_client,opts )
   return data
end
post_workbook_import_xml( post_workbook_import_xml_request, opts = {}) click to toggle source

Import an XML data file into an Excel file. The XML data file can either be a cloud file or data from an HTTP URI.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 966
def post_workbook_import_xml( post_workbook_import_xml_request, opts = {})

   data, _status_code, _headers = post_workbook_import_xml_request.create_http_request(@api_client,opts )
   return data
end
post_workbook_name( post_workbook_name_request, opts = {}) click to toggle source

Update a named range in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2146
def post_workbook_name( post_workbook_name_request, opts = {})

   data, _status_code, _headers = post_workbook_name_request.create_http_request(@api_client,opts )
   return data
end
post_workbook_save_as( post_workbook_save_as_request, opts = {}) click to toggle source

Save an Excel file in various formats.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 861
def post_workbook_save_as( post_workbook_save_as_request, opts = {})

   data, _status_code, _headers = post_workbook_save_as_request.create_http_request(@api_client,opts )
   return data
end
post_workbook_settings( post_workbook_settings_request, opts = {}) click to toggle source

Update setting in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2258
def post_workbook_settings( post_workbook_settings_request, opts = {})

   data, _status_code, _headers = post_workbook_settings_request.create_http_request(@api_client,opts )
   return data
end
post_workbook_split( post_workbook_split_request, opts = {}) click to toggle source

Split the workbook with a specific format.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2218
def post_workbook_split( post_workbook_split_request, opts = {})

   data, _status_code, _headers = post_workbook_split_request.create_http_request(@api_client,opts )
   return data
end
post_workbook_text_replace( post_workbook_text_replace_request, opts = {}) click to toggle source

Replace text in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2194
def post_workbook_text_replace( post_workbook_text_replace_request, opts = {})

   data, _status_code, _headers = post_workbook_text_replace_request.create_http_request(@api_client,opts )
   return data
end
post_workbooks_merge( post_workbooks_merge_request, opts = {}) click to toggle source

Merge a workbook into the existing workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2178
def post_workbooks_merge( post_workbooks_merge_request, opts = {})

   data, _status_code, _headers = post_workbooks_merge_request.create_http_request(@api_client,opts )
   return data
end
post_workbooks_text_search( post_workbooks_text_search_request, opts = {}) click to toggle source

Search for text in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2186
def post_workbooks_text_search( post_workbooks_text_search_request, opts = {})

   data, _status_code, _headers = post_workbooks_text_search_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_auto_filter_refresh( post_worksheet_auto_filter_refresh_request, opts = {}) click to toggle source

Refresh auto filters in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 133
def post_worksheet_auto_filter_refresh( post_worksheet_auto_filter_refresh_request, opts = {})

   data, _status_code, _headers = post_worksheet_auto_filter_refresh_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_calculate_formula( post_worksheet_calculate_formula_request, opts = {}) click to toggle source

Calculate formula in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2466
def post_worksheet_calculate_formula( post_worksheet_calculate_formula_request, opts = {})

   data, _status_code, _headers = post_worksheet_calculate_formula_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_cell_set_value( post_worksheet_cell_set_value_request, opts = {}) click to toggle source

Set cell value using cell name in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 285
def post_worksheet_cell_set_value( post_worksheet_cell_set_value_request, opts = {})

   data, _status_code, _headers = post_worksheet_cell_set_value_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_cells_range_column_width( post_worksheet_cells_range_column_width_request, opts = {}) click to toggle source

Set the column width of the specified range.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1926
def post_worksheet_cells_range_column_width( post_worksheet_cells_range_column_width_request, opts = {})

   data, _status_code, _headers = post_worksheet_cells_range_column_width_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_cells_range_merge( post_worksheet_cells_range_merge_request, opts = {}) click to toggle source

Merge a range of cells into a single cell.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1862
def post_worksheet_cells_range_merge( post_worksheet_cells_range_merge_request, opts = {})

   data, _status_code, _headers = post_worksheet_cells_range_merge_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_cells_range_move_to( post_worksheet_cells_range_move_to_request, opts = {}) click to toggle source

Move the current range to the destination range.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1902
def post_worksheet_cells_range_move_to( post_worksheet_cells_range_move_to_request, opts = {})

   data, _status_code, _headers = post_worksheet_cells_range_move_to_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_cells_range_outline_border( post_worksheet_cells_range_outline_border_request, opts = {}) click to toggle source

Apply an outline border around a range of cells.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1918
def post_worksheet_cells_range_outline_border( post_worksheet_cells_range_outline_border_request, opts = {})

   data, _status_code, _headers = post_worksheet_cells_range_outline_border_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_cells_range_row_height( post_worksheet_cells_range_row_height_request, opts = {}) click to toggle source

Sets row height of range.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1934
def post_worksheet_cells_range_row_height( post_worksheet_cells_range_row_height_request, opts = {})

   data, _status_code, _headers = post_worksheet_cells_range_row_height_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_cells_range_sort( post_worksheet_cells_range_sort_request, opts = {}) click to toggle source

Perform data sorting around a range of cells.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1910
def post_worksheet_cells_range_sort( post_worksheet_cells_range_sort_request, opts = {})

   data, _status_code, _headers = post_worksheet_cells_range_sort_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_cells_range_style( post_worksheet_cells_range_style_request, opts = {}) click to toggle source

Set the style for the specified range.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1878
def post_worksheet_cells_range_style( post_worksheet_cells_range_style_request, opts = {})

   data, _status_code, _headers = post_worksheet_cells_range_style_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_cells_range_un_merge( post_worksheet_cells_range_un_merge_request, opts = {}) click to toggle source

Unmerge merged cells within this range.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1870
def post_worksheet_cells_range_un_merge( post_worksheet_cells_range_un_merge_request, opts = {})

   data, _status_code, _headers = post_worksheet_cells_range_un_merge_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_cells_range_value( post_worksheet_cells_range_value_request, opts = {}) click to toggle source

Assign a value to the range; if necessary, the value will be converted to another data type, and the cell’s number format will be reset.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1894
def post_worksheet_cells_range_value( post_worksheet_cells_range_value_request, opts = {})

   data, _status_code, _headers = post_worksheet_cells_range_value_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_cells_ranges_copy( post_worksheet_cells_ranges_copy_request, opts = {}) click to toggle source

Copy content from the source range to the destination range in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1854
def post_worksheet_cells_ranges_copy( post_worksheet_cells_ranges_copy_request, opts = {})

   data, _status_code, _headers = post_worksheet_cells_ranges_copy_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_chart( post_worksheet_chart_request, opts = {}) click to toggle source

Update chart properties in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 613
def post_worksheet_chart( post_worksheet_chart_request, opts = {})

   data, _status_code, _headers = post_worksheet_chart_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_chart_legend( post_worksheet_chart_legend_request, opts = {}) click to toggle source

Update chart legend in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 629
def post_worksheet_chart_legend( post_worksheet_chart_legend_request, opts = {})

   data, _status_code, _headers = post_worksheet_chart_legend_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_chart_title( post_worksheet_chart_title_request, opts = {}) click to toggle source

Update chart title in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 669
def post_worksheet_chart_title( post_worksheet_chart_title_request, opts = {})

   data, _status_code, _headers = post_worksheet_chart_title_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_comment( post_worksheet_comment_request, opts = {}) click to toggle source

Update cell comment in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2418
def post_worksheet_comment( post_worksheet_comment_request, opts = {})

   data, _status_code, _headers = post_worksheet_comment_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_group_shape( post_worksheet_group_shape_request, opts = {}) click to toggle source

Group shapes in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2006
def post_worksheet_group_shape( post_worksheet_group_shape_request, opts = {})

   data, _status_code, _headers = post_worksheet_group_shape_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_hyperlink( post_worksheet_hyperlink_request, opts = {}) click to toggle source

Update hyperlink by index in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1070
def post_worksheet_hyperlink( post_worksheet_hyperlink_request, opts = {})

   data, _status_code, _headers = post_worksheet_hyperlink_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_list_column( post_worksheet_list_column_request, opts = {}) click to toggle source

Update list column in list object.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1302
def post_worksheet_list_column( post_worksheet_list_column_request, opts = {})

   data, _status_code, _headers = post_worksheet_list_column_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_list_columns_total( post_worksheet_list_columns_total_request, opts = {}) click to toggle source

Update total of list columns in the table.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1310
def post_worksheet_list_columns_total( post_worksheet_list_columns_total_request, opts = {})

   data, _status_code, _headers = post_worksheet_list_columns_total_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_list_object( post_worksheet_list_object_request, opts = {}) click to toggle source

Update list object by index in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1254
def post_worksheet_list_object( post_worksheet_list_object_request, opts = {})

   data, _status_code, _headers = post_worksheet_list_object_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_list_object_convert_to_range( post_worksheet_list_object_convert_to_range_request, opts = {}) click to toggle source

Convert list object to range in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1262
def post_worksheet_list_object_convert_to_range( post_worksheet_list_object_convert_to_range_request, opts = {})

   data, _status_code, _headers = post_worksheet_list_object_convert_to_range_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_list_object_insert_slicer( post_worksheet_list_object_insert_slicer_request, opts = {}) click to toggle source

Insert slicer for list object.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1294
def post_worksheet_list_object_insert_slicer( post_worksheet_list_object_insert_slicer_request, opts = {})

   data, _status_code, _headers = post_worksheet_list_object_insert_slicer_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_list_object_remove_duplicates( post_worksheet_list_object_remove_duplicates_request, opts = {}) click to toggle source

Remove duplicates in list object.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1286
def post_worksheet_list_object_remove_duplicates( post_worksheet_list_object_remove_duplicates_request, opts = {})

   data, _status_code, _headers = post_worksheet_list_object_remove_duplicates_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_list_object_sort_table( post_worksheet_list_object_sort_table_request, opts = {}) click to toggle source

Sort list object in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1278
def post_worksheet_list_object_sort_table( post_worksheet_list_object_sort_table_request, opts = {})

   data, _status_code, _headers = post_worksheet_list_object_sort_table_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_list_object_summarize_with_pivot_table( post_worksheet_list_object_summarize_with_pivot_table_request, opts = {}) click to toggle source

Create a pivot table with a list object in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1270
def post_worksheet_list_object_summarize_with_pivot_table( post_worksheet_list_object_summarize_with_pivot_table_request, opts = {})

   data, _status_code, _headers = post_worksheet_list_object_summarize_with_pivot_table_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_match_blanks( post_worksheet_match_blanks_request, opts = {}) click to toggle source

Match all blank cells in the list.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 117
def post_worksheet_match_blanks( post_worksheet_match_blanks_request, opts = {})

   data, _status_code, _headers = post_worksheet_match_blanks_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_match_non_blanks( post_worksheet_match_non_blanks_request, opts = {}) click to toggle source

Match all not blank cells in the list.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 125
def post_worksheet_match_non_blanks( post_worksheet_match_non_blanks_request, opts = {})

   data, _status_code, _headers = post_worksheet_match_non_blanks_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_merge( post_worksheet_merge_request, opts = {}) click to toggle source

Merge cells in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 245
def post_worksheet_merge( post_worksheet_merge_request, opts = {})

   data, _status_code, _headers = post_worksheet_merge_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_picture( post_worksheet_picture_request, opts = {}) click to toggle source

Update a picture by index in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1542
def post_worksheet_picture( post_worksheet_picture_request, opts = {})

   data, _status_code, _headers = post_worksheet_picture_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_pivot_table_calculate( post_worksheet_pivot_table_calculate_request, opts = {}) click to toggle source

Calculate pivottable’s data to cells.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1678
def post_worksheet_pivot_table_calculate( post_worksheet_pivot_table_calculate_request, opts = {})

   data, _status_code, _headers = post_worksheet_pivot_table_calculate_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_pivot_table_move( post_worksheet_pivot_table_move_request, opts = {}) click to toggle source

Move PivotTable in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1686
def post_worksheet_pivot_table_move( post_worksheet_pivot_table_move_request, opts = {})

   data, _status_code, _headers = post_worksheet_pivot_table_move_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_range_sort( post_worksheet_range_sort_request, opts = {}) click to toggle source

Sort a range in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2490
def post_worksheet_range_sort( post_worksheet_range_sort_request, opts = {})

   data, _status_code, _headers = post_worksheet_range_sort_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_shape( post_worksheet_shape_request, opts = {}) click to toggle source

Update a shape in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1998
def post_worksheet_shape( post_worksheet_shape_request, opts = {})

   data, _status_code, _headers = post_worksheet_shape_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_sparkline_group( post_worksheet_sparkline_group_request, opts = {}) click to toggle source

Update a sparkline group in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2062
def post_worksheet_sparkline_group( post_worksheet_sparkline_group_request, opts = {})

   data, _status_code, _headers = post_worksheet_sparkline_group_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_text_replace( post_worksheet_text_replace_request, opts = {}) click to toggle source

Replace old text with new text in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2482
def post_worksheet_text_replace( post_worksheet_text_replace_request, opts = {})

   data, _status_code, _headers = post_worksheet_text_replace_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_text_search( post_worksheet_text_search_request, opts = {}) click to toggle source

Search for text in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2474
def post_worksheet_text_search( post_worksheet_text_search_request, opts = {})

   data, _status_code, _headers = post_worksheet_text_search_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_ungroup_shape( post_worksheet_ungroup_shape_request, opts = {}) click to toggle source

Ungroup shapes in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2014
def post_worksheet_ungroup_shape( post_worksheet_ungroup_shape_request, opts = {})

   data, _status_code, _headers = post_worksheet_ungroup_shape_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_unmerge( post_worksheet_unmerge_request, opts = {}) click to toggle source

Unmerge cells in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 253
def post_worksheet_unmerge( post_worksheet_unmerge_request, opts = {})

   data, _status_code, _headers = post_worksheet_unmerge_request.create_http_request(@api_client,opts )
   return data
end
post_worksheet_validation( post_worksheet_validation_request, opts = {}) click to toggle source

Update a validation by index in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2634
def post_worksheet_validation( post_worksheet_validation_request, opts = {})

   data, _status_code, _headers = post_worksheet_validation_request.create_http_request(@api_client,opts )
   return data
end
put_active_worksheet( put_active_worksheet_request, opts = {}) click to toggle source

Set active worksheet index in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2322
def put_active_worksheet( put_active_worksheet_request, opts = {})

   data, _status_code, _headers = put_active_worksheet_request.create_http_request(@api_client,opts )
   return data
end
put_add_new_worksheet( put_add_new_worksheet_request, opts = {}) click to toggle source

Add a new worksheet in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2338
def put_add_new_worksheet( put_add_new_worksheet_request, opts = {})

   data, _status_code, _headers = put_add_new_worksheet_request.create_http_request(@api_client,opts )
   return data
end
put_change_visibility_worksheet( put_change_visibility_worksheet_request, opts = {}) click to toggle source

Change worksheet visibility in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2314
def put_change_visibility_worksheet( put_change_visibility_worksheet_request, opts = {})

   data, _status_code, _headers = put_change_visibility_worksheet_request.create_http_request(@api_client,opts )
   return data
end
put_convert_workbook( put_convert_workbook_request, opts = {}) click to toggle source

Convert the workbook from the requested content into files in different formats.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 853
def put_convert_workbook( put_convert_workbook_request, opts = {})

   data, _status_code, _headers = put_convert_workbook_request.create_http_request(@api_client,opts )
   return data
end
put_document_property( put_document_property_request, opts = {}) click to toggle source

Set or add an Excel property.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1742
def put_document_property( put_document_property_request, opts = {})

   data, _status_code, _headers = put_document_property_request.create_http_request(@api_client,opts )
   return data
end
put_document_protect_from_changes( put_document_protect_from_changes_request, opts = {}) click to toggle source

Excel file write protection.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1814
def put_document_protect_from_changes( put_document_protect_from_changes_request, opts = {})

   data, _status_code, _headers = put_document_protect_from_changes_request.create_http_request(@api_client,opts )
   return data
end
put_horizontal_page_break( put_horizontal_page_break_request, opts = {}) click to toggle source

Add a horizontal page breaks in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1406
def put_horizontal_page_break( put_horizontal_page_break_request, opts = {})

   data, _status_code, _headers = put_horizontal_page_break_request.create_http_request(@api_client,opts )
   return data
end
put_insert_new_worksheet( put_insert_new_worksheet_request, opts = {}) click to toggle source

Insert a new worksheet in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2330
def put_insert_new_worksheet( put_insert_new_worksheet_request, opts = {})

   data, _status_code, _headers = put_insert_new_worksheet_request.create_http_request(@api_client,opts )
   return data
end
put_insert_worksheet_columns( put_insert_worksheet_columns_request, opts = {}) click to toggle source

Insert worksheet columns in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 373
def put_insert_worksheet_columns( put_insert_worksheet_columns_request, opts = {})

   data, _status_code, _headers = put_insert_worksheet_columns_request.create_http_request(@api_client,opts )
   return data
end
put_insert_worksheet_row( put_insert_worksheet_row_request, opts = {}) click to toggle source

Insert a new row in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 477
def put_insert_worksheet_row( put_insert_worksheet_row_request, opts = {})

   data, _status_code, _headers = put_insert_worksheet_row_request.create_http_request(@api_client,opts )
   return data
end
put_insert_worksheet_rows( put_insert_worksheet_rows_request, opts = {}) click to toggle source

Insert several new rows in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 469
def put_insert_worksheet_rows( put_insert_worksheet_rows_request, opts = {})

   data, _status_code, _headers = put_insert_worksheet_rows_request.create_http_request(@api_client,opts )
   return data
end
put_pivot_table_field( put_pivot_table_field_request, opts = {}) click to toggle source

Add a pivot field in the PivotTable.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1614
def put_pivot_table_field( put_pivot_table_field_request, opts = {})

   data, _status_code, _headers = put_pivot_table_field_request.create_http_request(@api_client,opts )
   return data
end
put_protect_worksheet( put_protect_worksheet_request, opts = {}) click to toggle source

Protect worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2370
def put_protect_worksheet( put_protect_worksheet_request, opts = {})

   data, _status_code, _headers = put_protect_worksheet_request.create_http_request(@api_client,opts )
   return data
end
put_vertical_page_break( put_vertical_page_break_request, opts = {}) click to toggle source

Add a vertical page break in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1398
def put_vertical_page_break( put_vertical_page_break_request, opts = {})

   data, _status_code, _headers = put_vertical_page_break_request.create_http_request(@api_client,opts )
   return data
end
put_workbook_background( put_workbook_background_request, opts = {}) click to toggle source

Set background in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2266
def put_workbook_background( put_workbook_background_request, opts = {})

   data, _status_code, _headers = put_workbook_background_request.create_http_request(@api_client,opts )
   return data
end
put_workbook_create( put_workbook_create_request, opts = {}) click to toggle source

Create a new workbook using different methods.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2210
def put_workbook_create( put_workbook_create_request, opts = {})

   data, _status_code, _headers = put_workbook_create_request.create_http_request(@api_client,opts )
   return data
end
put_workbook_name( put_workbook_name_request, opts = {}) click to toggle source

Define a new name in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2130
def put_workbook_name( put_workbook_name_request, opts = {})

   data, _status_code, _headers = put_workbook_name_request.create_http_request(@api_client,opts )
   return data
end
put_workbook_water_marker( put_workbook_water_marker_request, opts = {}) click to toggle source

Set water marker in the workbook.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2282
def put_workbook_water_marker( put_workbook_water_marker_request, opts = {})

   data, _status_code, _headers = put_workbook_water_marker_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_add_picture( put_worksheet_add_picture_request, opts = {}) click to toggle source

Add a new picture in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1534
def put_worksheet_add_picture( put_worksheet_add_picture_request, opts = {})

   data, _status_code, _headers = put_worksheet_add_picture_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_background( put_worksheet_background_request, opts = {}) click to toggle source

Set background image in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2522
def put_worksheet_background( put_worksheet_background_request, opts = {})

   data, _status_code, _headers = put_worksheet_background_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_cells_range( put_worksheet_cells_range_request, opts = {}) click to toggle source

Insert a range of cells and shift existing cells based on the specified shift option.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1942
def put_worksheet_cells_range( put_worksheet_cells_range_request, opts = {})

   data, _status_code, _headers = put_worksheet_cells_range_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_chart( put_worksheet_chart_request, opts = {}) click to toggle source

Add a new chart in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 597
def put_worksheet_chart( put_worksheet_chart_request, opts = {})

   data, _status_code, _headers = put_worksheet_chart_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_chart_legend( put_worksheet_chart_legend_request, opts = {}) click to toggle source

Show chart legend in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 637
def put_worksheet_chart_legend( put_worksheet_chart_legend_request, opts = {})

   data, _status_code, _headers = put_worksheet_chart_legend_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_chart_title( put_worksheet_chart_title_request, opts = {}) click to toggle source

Set chart title in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 677
def put_worksheet_chart_title( put_worksheet_chart_title_request, opts = {})

   data, _status_code, _headers = put_worksheet_chart_title_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_color_filter( put_worksheet_color_filter_request, opts = {}) click to toggle source

Add a color filter in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 109
def put_worksheet_color_filter( put_worksheet_color_filter_request, opts = {})

   data, _status_code, _headers = put_worksheet_color_filter_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_comment( put_worksheet_comment_request, opts = {}) click to toggle source

Add cell comment in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2410
def put_worksheet_comment( put_worksheet_comment_request, opts = {})

   data, _status_code, _headers = put_worksheet_comment_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_conditional_formatting( put_worksheet_conditional_formatting_request, opts = {}) click to toggle source

Add conditional formatting in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 789
def put_worksheet_conditional_formatting( put_worksheet_conditional_formatting_request, opts = {})

   data, _status_code, _headers = put_worksheet_conditional_formatting_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_custom_filter( put_worksheet_custom_filter_request, opts = {}) click to toggle source

Filter a list with custom criteria in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 85
def put_worksheet_custom_filter( put_worksheet_custom_filter_request, opts = {})

   data, _status_code, _headers = put_worksheet_custom_filter_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_date_filter( put_worksheet_date_filter_request, opts = {}) click to toggle source

Apply a date filter in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 61
def put_worksheet_date_filter( put_worksheet_date_filter_request, opts = {})

   data, _status_code, _headers = put_worksheet_date_filter_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_dynamic_filter( put_worksheet_dynamic_filter_request, opts = {}) click to toggle source

Add a dynamic filter in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 93
def put_worksheet_dynamic_filter( put_worksheet_dynamic_filter_request, opts = {})

   data, _status_code, _headers = put_worksheet_dynamic_filter_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_filter( put_worksheet_filter_request, opts = {}) click to toggle source

Add a filter for a column in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 69
def put_worksheet_filter( put_worksheet_filter_request, opts = {})

   data, _status_code, _headers = put_worksheet_filter_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_filter_top10( put_worksheet_filter_top10_request, opts = {}) click to toggle source

Filter the top 10 items in the list in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 101
def put_worksheet_filter_top10( put_worksheet_filter_top10_request, opts = {})

   data, _status_code, _headers = put_worksheet_filter_top10_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_format_condition( put_worksheet_format_condition_request, opts = {}) click to toggle source

Add a format condition in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 797
def put_worksheet_format_condition( put_worksheet_format_condition_request, opts = {})

   data, _status_code, _headers = put_worksheet_format_condition_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_format_condition_area( put_worksheet_format_condition_area_request, opts = {}) click to toggle source

Add a cell area for the format condition in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 805
def put_worksheet_format_condition_area( put_worksheet_format_condition_area_request, opts = {})

   data, _status_code, _headers = put_worksheet_format_condition_area_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_format_condition_condition( put_worksheet_format_condition_condition_request, opts = {}) click to toggle source

Add a condition for the format condition in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 813
def put_worksheet_format_condition_condition( put_worksheet_format_condition_condition_request, opts = {})

   data, _status_code, _headers = put_worksheet_format_condition_condition_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_freeze_panes( put_worksheet_freeze_panes_request, opts = {}) click to toggle source

Set freeze panes in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2538
def put_worksheet_freeze_panes( put_worksheet_freeze_panes_request, opts = {})

   data, _status_code, _headers = put_worksheet_freeze_panes_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_icon_filter( put_worksheet_icon_filter_request, opts = {}) click to toggle source

Add an icon filter in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 77
def put_worksheet_icon_filter( put_worksheet_icon_filter_request, opts = {})

   data, _status_code, _headers = put_worksheet_icon_filter_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_list_object( put_worksheet_list_object_request, opts = {}) click to toggle source

Add a ListObject in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1230
def put_worksheet_list_object( put_worksheet_list_object_request, opts = {})

   data, _status_code, _headers = put_worksheet_list_object_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_ole_object( put_worksheet_ole_object_request, opts = {}) click to toggle source

Add an OLE object in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1358
def put_worksheet_ole_object( put_worksheet_ole_object_request, opts = {})

   data, _status_code, _headers = put_worksheet_ole_object_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_pivot_table( put_worksheet_pivot_table_request, opts = {}) click to toggle source

Add a PivotTable in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1606
def put_worksheet_pivot_table( put_worksheet_pivot_table_request, opts = {})

   data, _status_code, _headers = put_worksheet_pivot_table_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_pivot_table_filter( put_worksheet_pivot_table_filter_request, opts = {}) click to toggle source

Add a pivot filter to the PivotTable.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1622
def put_worksheet_pivot_table_filter( put_worksheet_pivot_table_filter_request, opts = {})

   data, _status_code, _headers = put_worksheet_pivot_table_filter_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_shape( put_worksheet_shape_request, opts = {}) click to toggle source

Add a shape in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 1974
def put_worksheet_shape( put_worksheet_shape_request, opts = {})

   data, _status_code, _headers = put_worksheet_shape_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_sparkline_group( put_worksheet_sparkline_group_request, opts = {}) click to toggle source

Add a sparkline group in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2054
def put_worksheet_sparkline_group( put_worksheet_sparkline_group_request, opts = {})

   data, _status_code, _headers = put_worksheet_sparkline_group_request.create_http_request(@api_client,opts )
   return data
end
put_worksheet_validation( put_worksheet_validation_request, opts = {}) click to toggle source

Add a validation at index in the worksheet.

# File lib/aspose_cells_cloud/api/cells_api.rb, line 2626
def put_worksheet_validation( put_worksheet_validation_request, opts = {})

   data, _status_code, _headers = put_worksheet_validation_request.create_http_request(@api_client,opts )
   return data
end
storage_exists( storage_exists_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2727
def storage_exists( storage_exists_request, opts = {})

   data, _status_code, _headers = storage_exists_request.create_http_request(@api_client,opts )
   return data
end
upload_file( upload_file_request, opts = {}) click to toggle source
# File lib/aspose_cells_cloud/api/cells_api.rb, line 2664
def upload_file( upload_file_request, opts = {})

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