Class: AsposeCellsCloud::CellsApi

Inherits:
Object
  • Object
show all
Defined in:
lib/aspose_cells_cloud/api/cells_api.rb

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

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

Returns a new instance of CellsApi.



35
36
37
38
39
40
41
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 35

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

Instance Attribute Details

#api_clientObject

Returns the value of attribute api_client.



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

def api_client
  @api_client
end

Instance Method Details

#copy_file(copy_file_request, opts = {}) ⇒ Object



2671
2672
2673
2674
2675
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2671

def copy_file( copy_file_request, opts = {})

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

#copy_folder(copy_folder_request, opts = {}) ⇒ Object



2706
2707
2708
2709
2710
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2706

def copy_folder( copy_folder_request, opts = {})

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

#create_folder(create_folder_request, opts = {}) ⇒ Object



2699
2700
2701
2702
2703
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2699

def create_folder( create_folder_request, opts = {})

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

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

Excel files decryption.



1790
1791
1792
1793
1794
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1790

def delete_decrypt_workbook( delete_decrypt_workbook_request, opts = {})

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

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

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



1766
1767
1768
1769
1770
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1766

def delete_document_properties( delete_document_properties_request, opts = {})

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

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

Delete an Excel property.



1758
1759
1760
1761
1762
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1758

def delete_document_property( delete_document_property_request, opts = {})

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

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

Excel file cancel write protection.



1822
1823
1824
1825
1826
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1822

def delete_document_un_protect_from_changes( delete_document_un_protect_from_changes_request, opts = {})

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

#delete_file(delete_file_request, opts = {}) ⇒ Object



2685
2686
2687
2688
2689
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2685

def delete_file( delete_file_request, opts = {})

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

#delete_folder(delete_folder_request, opts = {}) ⇒ Object



2720
2721
2722
2723
2724
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2720

def delete_folder( delete_folder_request, opts = {})

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

Clear header and footer in the worksheet.



1462
1463
1464
1465
1466
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1462

def delete_header_footer( delete_header_footer_request, opts = {})

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

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

Delete a horizontal page break in the worksheet.



1438
1439
1440
1441
1442
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1438

def delete_horizontal_page_break( delete_horizontal_page_break_request, opts = {})

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

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

Delete horizontal page breaks in the worksheet.



1422
1423
1424
1425
1426
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1422

def delete_horizontal_page_breaks( delete_horizontal_page_breaks_request, opts = {})

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

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

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



1206
1207
1208
1209
1210
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1206

def ( , opts = {})

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

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

Delete a pivot field in the PivotTable.



1710
1711
1712
1713
1714
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1710

def delete_pivot_table_field( delete_pivot_table_field_request, opts = {})

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

#delete_un_protect_workbook(delete_un_protect_workbook_request, opts = {}) ⇒ Object

Excel unprotection.



1806
1807
1808
1809
1810
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1806

def delete_un_protect_workbook( delete_un_protect_workbook_request, opts = {})

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

#delete_unprotect_worksheet(delete_unprotect_worksheet_request, opts = {}) ⇒ Object

Unprotect worksheet.



2378
2379
2380
2381
2382
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2378

def delete_unprotect_worksheet( delete_unprotect_worksheet_request, opts = {})

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

#delete_vertical_page_break(delete_vertical_page_break_request, opts = {}) ⇒ Object

Delete a vertical page break in the worksheet.



1430
1431
1432
1433
1434
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1430

def delete_vertical_page_break( delete_vertical_page_break_request, opts = {})

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

#delete_vertical_page_breaks(delete_vertical_page_breaks_request, opts = {}) ⇒ Object

Delete vertical page breaks in the worksheet.



1414
1415
1416
1417
1418
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1414

def delete_vertical_page_breaks( delete_vertical_page_breaks_request, opts = {})

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

#delete_workbook_background(delete_workbook_background_request, opts = {}) ⇒ Object

Delete background in the workbook.



2274
2275
2276
2277
2278
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2274

def delete_workbook_background( delete_workbook_background_request, opts = {})

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

#delete_workbook_name(delete_workbook_name_request, opts = {}) ⇒ Object

Delete a named range in the workbook.



2170
2171
2172
2173
2174
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2170

def delete_workbook_name( delete_workbook_name_request, opts = {})

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

#delete_workbook_names(delete_workbook_names_request, opts = {}) ⇒ Object

Delete all named ranges in the workbook.



2162
2163
2164
2165
2166
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2162

def delete_workbook_names( delete_workbook_names_request, opts = {})

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

#delete_worksheet(delete_worksheet_request, opts = {}) ⇒ Object

Delete a worksheet in the workbook.



2346
2347
2348
2349
2350
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2346

def delete_worksheet( delete_worksheet_request, opts = {})

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

#delete_worksheet_background(delete_worksheet_background_request, opts = {}) ⇒ Object

Delete background image in the worksheet.



2530
2531
2532
2533
2534
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2530

def delete_worksheet_background( delete_worksheet_background_request, opts = {})

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

#delete_worksheet_cells_range(delete_worksheet_cells_range_request, opts = {}) ⇒ Object

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



1950
1951
1952
1953
1954
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1950

def delete_worksheet_cells_range( delete_worksheet_cells_range_request, opts = {})

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

#delete_worksheet_chart(delete_worksheet_chart_request, opts = {}) ⇒ Object

Delete a chart by index in the worksheet.



605
606
607
608
609
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 605

def delete_worksheet_chart( delete_worksheet_chart_request, opts = {})

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

#delete_worksheet_chart_legend(delete_worksheet_chart_legend_request, opts = {}) ⇒ Object

Hides chart legend in the worksheet.



645
646
647
648
649
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 645

def delete_worksheet_chart_legend( delete_worksheet_chart_legend_request, opts = {})

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

#delete_worksheet_chart_title(delete_worksheet_chart_title_request, opts = {}) ⇒ Object

Hide chart title in the worksheet.



685
686
687
688
689
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 685

def delete_worksheet_chart_title( delete_worksheet_chart_title_request, opts = {})

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

#delete_worksheet_charts(delete_worksheet_charts_request, opts = {}) ⇒ Object

Clear the charts in the worksheets.



653
654
655
656
657
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 653

def delete_worksheet_charts( delete_worksheet_charts_request, opts = {})

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

#delete_worksheet_columns(delete_worksheet_columns_request, opts = {}) ⇒ Object

Delete worksheet columns in the worksheet.



381
382
383
384
385
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 381

def delete_worksheet_columns( delete_worksheet_columns_request, opts = {})

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

#delete_worksheet_comment(delete_worksheet_comment_request, opts = {}) ⇒ Object

Delete cell comment in the worksheet.



2426
2427
2428
2429
2430
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2426

def delete_worksheet_comment( delete_worksheet_comment_request, opts = {})

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

#delete_worksheet_comments(delete_worksheet_comments_request, opts = {}) ⇒ Object

Delete all comments in the worksheet.



2434
2435
2436
2437
2438
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2434

def delete_worksheet_comments( delete_worksheet_comments_request, opts = {})

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

#delete_worksheet_conditional_formatting(delete_worksheet_conditional_formatting_request, opts = {}) ⇒ Object

Remove a conditional formatting.



829
830
831
832
833
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 829

def delete_worksheet_conditional_formatting( delete_worksheet_conditional_formatting_request, opts = {})

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

#delete_worksheet_conditional_formatting_area(delete_worksheet_conditional_formatting_area_request, opts = {}) ⇒ Object

Remove cell area from conditional formatting.



837
838
839
840
841
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 837

def delete_worksheet_conditional_formatting_area( delete_worksheet_conditional_formatting_area_request, opts = {})

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

#delete_worksheet_conditional_formattings(delete_worksheet_conditional_formattings_request, opts = {}) ⇒ Object

Clear all conditional formattings in the worksheet.



821
822
823
824
825
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 821

def delete_worksheet_conditional_formattings( delete_worksheet_conditional_formattings_request, opts = {})

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

#delete_worksheet_date_filter(delete_worksheet_date_filter_request, opts = {}) ⇒ Object

Remove a date filter in the worksheet.



141
142
143
144
145
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 141

def delete_worksheet_date_filter( delete_worksheet_date_filter_request, opts = {})

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

#delete_worksheet_filter(delete_worksheet_filter_request, opts = {}) ⇒ Object

Delete a filter for a column in the worksheet.



149
150
151
152
153
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 149

def delete_worksheet_filter( delete_worksheet_filter_request, opts = {})

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

#delete_worksheet_freeze_panes(delete_worksheet_freeze_panes_request, opts = {}) ⇒ Object

Unfreeze panes in worksheet.



2546
2547
2548
2549
2550
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2546

def delete_worksheet_freeze_panes( delete_worksheet_freeze_panes_request, opts = {})

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

Delete hyperlink by index in the worksheet.



1062
1063
1064
1065
1066
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1062

def delete_worksheet_hyperlink( delete_worksheet_hyperlink_request, opts = {})

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

Delete all hyperlinks in the worksheet.



1086
1087
1088
1089
1090
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1086

def delete_worksheet_hyperlinks( delete_worksheet_hyperlinks_request, opts = {})

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

#delete_worksheet_list_object(delete_worksheet_list_object_request, opts = {}) ⇒ Object

Delete list object by index in the worksheet.



1246
1247
1248
1249
1250
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1246

def delete_worksheet_list_object( delete_worksheet_list_object_request, opts = {})

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

#delete_worksheet_list_objects(delete_worksheet_list_objects_request, opts = {}) ⇒ Object

Delete ListObjects in the worksheet.



1238
1239
1240
1241
1242
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1238

def delete_worksheet_list_objects( delete_worksheet_list_objects_request, opts = {})

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

#delete_worksheet_ole_object(delete_worksheet_ole_object_request, opts = {}) ⇒ Object

Delete an OLE object in the worksheet.



1342
1343
1344
1345
1346
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1342

def delete_worksheet_ole_object( delete_worksheet_ole_object_request, opts = {})

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

#delete_worksheet_ole_objects(delete_worksheet_ole_objects_request, opts = {}) ⇒ Object

Delete all OLE objects in the worksheet.



1334
1335
1336
1337
1338
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1334

def delete_worksheet_ole_objects( delete_worksheet_ole_objects_request, opts = {})

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

#delete_worksheet_picture(delete_worksheet_picture_request, opts = {}) ⇒ Object

Delete a picture object by index in the worksheet.



1550
1551
1552
1553
1554
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1550

def delete_worksheet_picture( delete_worksheet_picture_request, opts = {})

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

#delete_worksheet_pictures(delete_worksheet_pictures_request, opts = {}) ⇒ Object

Delete all pictures in the worksheet.



1558
1559
1560
1561
1562
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1558

def delete_worksheet_pictures( delete_worksheet_pictures_request, opts = {})

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

#delete_worksheet_pivot_table(delete_worksheet_pivot_table_request, opts = {}) ⇒ Object

Delete PivotTable by index in the worksheet.



1702
1703
1704
1705
1706
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1702

def delete_worksheet_pivot_table( delete_worksheet_pivot_table_request, opts = {})

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

#delete_worksheet_pivot_table_filter(delete_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object

Delete a pivot filter in the PivotTable.



1726
1727
1728
1729
1730
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1726

def delete_worksheet_pivot_table_filter( delete_worksheet_pivot_table_filter_request, opts = {})

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

#delete_worksheet_pivot_table_filters(delete_worksheet_pivot_table_filters_request, opts = {}) ⇒ Object

Delete all pivot filters in the PivotTable.



1718
1719
1720
1721
1722
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1718

def delete_worksheet_pivot_table_filters( delete_worksheet_pivot_table_filters_request, opts = {})

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

#delete_worksheet_pivot_tables(delete_worksheet_pivot_tables_request, opts = {}) ⇒ Object

Delete PivotTables in the worksheet.



1694
1695
1696
1697
1698
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1694

def delete_worksheet_pivot_tables( delete_worksheet_pivot_tables_request, opts = {})

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

#delete_worksheet_row(delete_worksheet_row_request, opts = {}) ⇒ Object

Delete a row in the worksheet.



453
454
455
456
457
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 453

def delete_worksheet_row( delete_worksheet_row_request, opts = {})

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

#delete_worksheet_rows(delete_worksheet_rows_request, opts = {}) ⇒ Object

Delete several rows in the worksheet.



461
462
463
464
465
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 461

def delete_worksheet_rows( delete_worksheet_rows_request, opts = {})

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

#delete_worksheet_shape(delete_worksheet_shape_request, opts = {}) ⇒ Object

Delete a shape in the worksheet.



1990
1991
1992
1993
1994
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1990

def delete_worksheet_shape( delete_worksheet_shape_request, opts = {})

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

#delete_worksheet_shapes(delete_worksheet_shapes_request, opts = {}) ⇒ Object

Delete all shapes in the worksheet.



1982
1983
1984
1985
1986
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1982

def delete_worksheet_shapes( delete_worksheet_shapes_request, opts = {})

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

#delete_worksheet_sparkline_group(delete_worksheet_sparkline_group_request, opts = {}) ⇒ Object

Delete a sparkline group in the worksheet.



2046
2047
2048
2049
2050
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2046

def delete_worksheet_sparkline_group( delete_worksheet_sparkline_group_request, opts = {})

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

#delete_worksheet_sparkline_groups(delete_worksheet_sparkline_groups_request, opts = {}) ⇒ Object

Delete sparkline groups in the worksheet.



2038
2039
2040
2041
2042
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2038

def delete_worksheet_sparkline_groups( delete_worksheet_sparkline_groups_request, opts = {})

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

#delete_worksheet_validation(delete_worksheet_validation_request, opts = {}) ⇒ Object

Delete a validation by index in worksheet.



2642
2643
2644
2645
2646
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2642

def delete_worksheet_validation( delete_worksheet_validation_request, opts = {})

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

#delete_worksheet_validations(delete_worksheet_validations_request, opts = {}) ⇒ Object

Delete all validations in the worksheet.



2650
2651
2652
2653
2654
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2650

def delete_worksheet_validations( delete_worksheet_validations_request, opts = {})

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

#delete_worksheets(delete_worksheets_request, opts = {}) ⇒ Object

Delete matched worksheets in the workbook.



2354
2355
2356
2357
2358
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2354

def delete_worksheets( delete_worksheets_request, opts = {})

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

#download_file(download_file_request, opts = {}) ⇒ Object



2657
2658
2659
2660
2661
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2657

def download_file( download_file_request, opts = {})

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

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

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



317
318
319
320
321
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 317

def get_cell_html_string( get_cell_html_string_request, opts = {})

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

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

Aspose.Cells Cloud service health status check.



549
550
551
552
553
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 549

def get_cells_cloud_service_status( get_cells_cloud_service_status_request, opts = {})

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

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

Retrieve cell descriptions in a specified format.



541
542
543
544
545
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 541

def get_cells_cloud_services_health_check( get_cells_cloud_services_health_check_request, opts = {})

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

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

Retrieve chart area description in the worksheet.



557
558
559
560
561
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 557

def get_chart_area( get_chart_area_request, opts = {})

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

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

Retrieve chart area border description.



573
574
575
576
577
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 573

def get_chart_area_border( get_chart_area_border_request, opts = {})

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

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

Retrieve chart area fill format description in the worksheet.



565
566
567
568
569
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 565

def get_chart_area_fill_format( get_chart_area_fill_format_request, opts = {})

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

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

Retrieve descriptions of chart series axis in the chart.



701
702
703
704
705
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 701

def get_chart_category_axis( get_chart_category_axis_request, opts = {})

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

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

Retrieve chart second category axis in the chart



717
718
719
720
721
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 717

def get_chart_second_category_axis( get_chart_second_category_axis_request, opts = {})

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

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

Retrieve chart second value axis in the chart.



725
726
727
728
729
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 725

def get_chart_second_value_axis( get_chart_second_value_axis_request, opts = {})

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

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

Retrieve descriptions of chart seriesaxis in the chart.



693
694
695
696
697
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 693

def get_chart_series_axis( get_chart_series_axis_request, opts = {})

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

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

Retrieve chart value axis in the chart.



709
710
711
712
713
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 709

def get_chart_value_axis( get_chart_value_axis_request, opts = {})

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

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



2741
2742
2743
2744
2745
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2741

def get_disc_usage( get_disc_usage_request, opts = {})

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

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

Retrieve descriptions of Excel file properties.



1734
1735
1736
1737
1738
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1734

def get_document_properties( get_document_properties_request, opts = {})

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

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

Get Excel property by name.



1750
1751
1752
1753
1754
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1750

def get_document_property( get_document_property_request, opts = {})

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

#get_file_versions(get_file_versions_request, opts = {}) ⇒ Object



2748
2749
2750
2751
2752
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2748

def get_file_versions( get_file_versions_request, opts = {})

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

#get_files_list(get_files_list_request, opts = {}) ⇒ Object



2692
2693
2694
2695
2696
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2692

def get_files_list( get_files_list_request, opts = {})

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

Retrieve page footer description in the worksheet.



1486
1487
1488
1489
1490
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1486

def get_footer( get_footer_request, opts = {})

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

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

Retrieve page header description in the worksheet.



1470
1471
1472
1473
1474
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1470

def get_header( get_header_request, opts = {})

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

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

Retrieve a horizontal page break descripton in the worksheet.



1390
1391
1392
1393
1394
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1390

def get_horizontal_page_break( get_horizontal_page_break_request, opts = {})

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

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

Retrieve descriptions of horizontal page breaks in the worksheet.



1374
1375
1376
1377
1378
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1374

def get_horizontal_page_breaks( get_horizontal_page_breaks_request, opts = {})

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

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

Get cells document properties.



1198
1199
1200
1201
1202
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1198

def ( , opts = {})

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

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

Retrieve values in range.



2586
2587
2588
2589
2590
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2586

def get_named_range_value( get_named_range_value_request, opts = {})

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

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

Retrieve descriptions of ranges in the worksheets.



2578
2579
2580
2581
2582
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2578

def get_named_ranges( get_named_ranges_request, opts = {})

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

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

Get page count in the workbook.



2290
2291
2292
2293
2294
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2290

def get_page_count( get_page_count_request, opts = {})

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

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

Retrieve page setup description in the worksheet.



1446
1447
1448
1449
1450
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1446

def get_page_setup( get_page_setup_request, opts = {})

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

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

Retrieve descriptions of pivot fields in the PivotTable.



1582
1583
1584
1585
1586
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1582

def get_pivot_table_field( get_pivot_table_field_request, opts = {})

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

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

Retrieve a vertical page break description in the worksheet.



1382
1383
1384
1385
1386
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1382

def get_vertical_page_break( get_vertical_page_break_request, opts = {})

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

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

Retrieve descriptions of vertical page breaks in the worksheet.



1366
1367
1368
1369
1370
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1366

def get_vertical_page_breaks( get_vertical_page_breaks_request, opts = {})

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

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

Retrieve workbooks in various formats.



845
846
847
848
849
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 845

def get_workbook( get_workbook_request, opts = {})

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

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

Retrieve the description of the default style for the workbook .



2106
2107
2108
2109
2110
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2106

def get_workbook_default_style( get_workbook_default_style_request, opts = {})

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

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

Retrieve description of a named range in the workbook.



2138
2139
2140
2141
2142
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2138

def get_workbook_name( get_workbook_name_request, opts = {})

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

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

Retrieve the value of a named range in the workbook.



2154
2155
2156
2157
2158
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2154

def get_workbook_name_value( get_workbook_name_value_request, opts = {})

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

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

Retrieve named ranges in the workbook.



2122
2123
2124
2125
2126
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2122

def get_workbook_names( get_workbook_names_request, opts = {})

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

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

Retrieve descriptions of workbook settings.



2250
2251
2252
2253
2254
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2250

def get_workbook_settings( get_workbook_settings_request, opts = {})

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

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

Retrieve text items in the workbook.



2114
2115
2116
2117
2118
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2114

def get_workbook_text_items( get_workbook_text_items_request, opts = {})

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

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

Retrieve the description of auto filters from a worksheet.



53
54
55
56
57
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 53

def get_worksheet_auto_filter( get_worksheet_auto_filter_request, opts = {})

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

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

Get autoshape description in some format.



165
166
167
168
169
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 165

def get_worksheet_autoshape_with_format( get_worksheet_autoshape_with_format_request, opts = {})

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

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

Get autoshapes description in worksheet.



157
158
159
160
161
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 157

def get_worksheet_autoshapes( get_worksheet_autoshapes_request, opts = {})

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

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

Calculate formula in the worksheet.



2458
2459
2460
2461
2462
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2458

def get_worksheet_calculate_formula( get_worksheet_calculate_formula_request, opts = {})

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

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

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



269
270
271
272
273
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 269

def get_worksheet_cell( get_worksheet_cell_request, opts = {})

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

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

Retrieve cell style descriptions in the worksheet.



277
278
279
280
281
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 277

def get_worksheet_cell_style( get_worksheet_cell_style_request, opts = {})

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

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

Retrieve cell descriptions in a specified format.



261
262
263
264
265
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 261

def get_worksheet_cells( get_worksheet_cells_request, opts = {})

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

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

Retrieve the values of cells within the specified range.



1886
1887
1888
1889
1890
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1886

def get_worksheet_cells_range_value( get_worksheet_cells_range_value_request, opts = {})

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

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

Retrieve the chart in a specified format.



589
590
591
592
593
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 589

def get_worksheet_chart( get_worksheet_chart_request, opts = {})

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

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

Retrieve chart legend description in the worksheet.



621
622
623
624
625
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 621

def get_worksheet_chart_legend( get_worksheet_chart_legend_request, opts = {})

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

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

Retrieve chart title description in the worksheet.



661
662
663
664
665
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 661

def get_worksheet_chart_title( get_worksheet_chart_title_request, opts = {})

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

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

Retrieve descriptions of charts in the worksheet.



581
582
583
584
585
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 581

def get_worksheet_charts( get_worksheet_charts_request, opts = {})

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

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

Retrieve worksheet column data by column index.



365
366
367
368
369
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 365

def get_worksheet_column( get_worksheet_column_request, opts = {})

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

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

Retrieve descriptions of worksheet columns.



349
350
351
352
353
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 349

def get_worksheet_columns( get_worksheet_columns_request, opts = {})

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

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

Retrieve the description of comment in the worksheet.



2402
2403
2404
2405
2406
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2402

def get_worksheet_comment( get_worksheet_comment_request, opts = {})

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

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

Retrieve the description of comments in the worksheet.



2394
2395
2396
2397
2398
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2394

def get_worksheet_comments( get_worksheet_comments_request, opts = {})

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

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

Retrieve conditional formatting descriptions in the worksheet.



781
782
783
784
785
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 781

def get_worksheet_conditional_formatting( get_worksheet_conditional_formatting_request, opts = {})

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

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

Retrieve descriptions of conditional formattings in a worksheet.



773
774
775
776
777
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 773

def get_worksheet_conditional_formattings( get_worksheet_conditional_formattings_request, opts = {})

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

Retrieve hyperlink description by index in the worksheet.



1054
1055
1056
1057
1058
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1054

def get_worksheet_hyperlink( get_worksheet_hyperlink_request, opts = {})

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

Retrieve descriptions of hyperlinks in the worksheet.



1046
1047
1048
1049
1050
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1046

def get_worksheet_hyperlinks( get_worksheet_hyperlinks_request, opts = {})

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

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

Retrieve list object description by index in the worksheet.



1222
1223
1224
1225
1226
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1222

def get_worksheet_list_object( get_worksheet_list_object_request, opts = {})

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

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

Retrieve descriptions of ListObjects in the worksheet.



1214
1215
1216
1217
1218
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1214

def get_worksheet_list_objects( get_worksheet_list_objects_request, opts = {})

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

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

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



2450
2451
2452
2453
2454
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2450

def get_worksheet_merged_cell( get_worksheet_merged_cell_request, opts = {})

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

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

Get worksheet merged cells.



2442
2443
2444
2445
2446
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2442

def get_worksheet_merged_cells( get_worksheet_merged_cells_request, opts = {})

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

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

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



1326
1327
1328
1329
1330
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1326

def get_worksheet_ole_object( get_worksheet_ole_object_request, opts = {})

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

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

Retrieve descriptions of OLE objects in the worksheet.



1318
1319
1320
1321
1322
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1318

def get_worksheet_ole_objects( get_worksheet_ole_objects_request, opts = {})

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

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

Get page count in the worksheet.



2602
2603
2604
2605
2606
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2602

def get_worksheet_page_count( get_worksheet_page_count_request, opts = {})

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

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

Retrieve a picture by number in the worksheet.



1526
1527
1528
1529
1530
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1526

def get_worksheet_picture_with_format( get_worksheet_picture_with_format_request, opts = {})

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

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

Retrieve descriptions of pictures in the worksheet.



1518
1519
1520
1521
1522
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1518

def get_worksheet_pictures( get_worksheet_pictures_request, opts = {})

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

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

Retrieve PivotTable information by index in the worksheet.



1574
1575
1576
1577
1578
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1574

def get_worksheet_pivot_table( get_worksheet_pivot_table_request, opts = {})

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

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

Retrieve PivotTable filters in the worksheet.



1598
1599
1600
1601
1602
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1598

def get_worksheet_pivot_table_filter( get_worksheet_pivot_table_filter_request, opts = {})

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

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

Gets PivotTable filters in worksheet.



1590
1591
1592
1593
1594
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1590

def get_worksheet_pivot_table_filters( get_worksheet_pivot_table_filters_request, opts = {})

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

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

Retrieve descriptions of pivottables in the worksheet.



1566
1567
1568
1569
1570
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1566

def get_worksheet_pivot_tables( get_worksheet_pivot_tables_request, opts = {})

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

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

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



445
446
447
448
449
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 445

def get_worksheet_row( get_worksheet_row_request, opts = {})

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

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

Retrieve descriptions of rows in the worksheet.



437
438
439
440
441
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 437

def get_worksheet_rows( get_worksheet_rows_request, opts = {})

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

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

Retrieve description of shape in the worksheet.



1966
1967
1968
1969
1970
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1966

def get_worksheet_shape( get_worksheet_shape_request, opts = {})

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

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

Retrieve descriptions of shapes in the worksheet.



1958
1959
1960
1961
1962
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1958

def get_worksheet_shapes( get_worksheet_shapes_request, opts = {})

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

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

Retrieve description of a sparkline group in the worksheet.



2030
2031
2032
2033
2034
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2030

def get_worksheet_sparkline_group( get_worksheet_sparkline_group_request, opts = {})

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

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

Retrieve descriptions of sparkline groups in the worksheet.



2022
2023
2024
2025
2026
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2022

def get_worksheet_sparkline_groups( get_worksheet_sparkline_groups_request, opts = {})

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

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

Retrieve text items in the worksheet.



2386
2387
2388
2389
2390
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2386

def get_worksheet_text_items( get_worksheet_text_items_request, opts = {})

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

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

Retrieve a validation by its index in the worksheet.



2618
2619
2620
2621
2622
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2618

def get_worksheet_validation( get_worksheet_validation_request, opts = {})

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

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

Retrieve descriptions of validations in the worksheet.



2610
2611
2612
2613
2614
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2610

def get_worksheet_validations( get_worksheet_validations_request, opts = {})

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

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

Retrieve the worksheet in a specified format from the workbook.



2306
2307
2308
2309
2310
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2306

def get_worksheet_with_format( get_worksheet_with_format_request, opts = {})

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

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

Retrieve the description of worksheets from a workbook.



2298
2299
2300
2301
2302
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2298

def get_worksheets( get_worksheets_request, opts = {})

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

#move_file(move_file_request, opts = {}) ⇒ Object



2678
2679
2680
2681
2682
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2678

def move_file( move_file_request, opts = {})

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

#move_folder(move_folder_request, opts = {}) ⇒ Object



2713
2714
2715
2716
2717
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2713

def move_folder( move_folder_request, opts = {})

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

#object_exists(object_exists_request, opts = {}) ⇒ Object



2734
2735
2736
2737
2738
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2734

def object_exists( object_exists_request, opts = {})

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

#post_access_token(post_access_token_request, opts = {}) ⇒ Object

Get Access Token Result



213
214
215
216
217
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 213

def post_access_token( post_access_token_request, opts = {})

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

#post_add_text_content(post_add_text_content_request, opts = {}) ⇒ Object



2077
2078
2079
2080
2081
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2077

def post_add_text_content( post_add_text_content_request, opts = {})

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

#post_analyze_excel(post_analyze_excel_request, opts = {}) ⇒ Object

Perform business analysis of data in Excel files.



45
46
47
48
49
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 45

def post_analyze_excel( post_analyze_excel_request, opts = {})

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

#post_assemble(post_assemble_request, opts = {}) ⇒ Object

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



1094
1095
1096
1097
1098
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1094

def post_assemble( post_assemble_request, opts = {})

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

#post_autofit_workbook_columns(post_autofit_workbook_columns_request, opts = {}) ⇒ Object

Autofit columns in the workbook.



2242
2243
2244
2245
2246
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2242

def post_autofit_workbook_columns( post_autofit_workbook_columns_request, opts = {})

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

#post_autofit_workbook_rows(post_autofit_workbook_rows_request, opts = {}) ⇒ Object

Autofit rows in the workbook.



2234
2235
2236
2237
2238
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2234

def post_autofit_workbook_rows( post_autofit_workbook_rows_request, opts = {})

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

#post_autofit_worksheet_columns(post_autofit_worksheet_columns_request, opts = {}) ⇒ Object

Autofit columns in the worksheet.



2514
2515
2516
2517
2518
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2514

def post_autofit_worksheet_columns( post_autofit_worksheet_columns_request, opts = {})

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

#post_autofit_worksheet_row(post_autofit_worksheet_row_request, opts = {}) ⇒ Object

Autofit a row in the worksheet.



2498
2499
2500
2501
2502
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2498

def post_autofit_worksheet_row( post_autofit_worksheet_row_request, opts = {})

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

#post_autofit_worksheet_rows(post_autofit_worksheet_rows_request, opts = {}) ⇒ Object

Autofit rows in the worksheet.



2506
2507
2508
2509
2510
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2506

def post_autofit_worksheet_rows( post_autofit_worksheet_rows_request, opts = {})

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

#post_batch_convert(post_batch_convert_request, opts = {}) ⇒ Object

Batch converting files that meet specific matching conditions.



173
174
175
176
177
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 173

def post_batch_convert( post_batch_convert_request, opts = {})

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

#post_batch_lock(post_batch_lock_request, opts = {}) ⇒ Object

Batch locking files that meet specific matching conditions.



189
190
191
192
193
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 189

def post_batch_lock( post_batch_lock_request, opts = {})

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

#post_batch_protect(post_batch_protect_request, opts = {}) ⇒ Object

Batch protecting files that meet specific matching conditions.



181
182
183
184
185
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 181

def post_batch_protect( post_batch_protect_request, opts = {})

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

#post_batch_split(post_batch_split_request, opts = {}) ⇒ Object

Batch splitting files that meet specific matching conditions.



205
206
207
208
209
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 205

def post_batch_split( post_batch_split_request, opts = {})

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

#post_batch_unlock(post_batch_unlock_request, opts = {}) ⇒ Object

Batch unlocking files that meet specific matching conditions.



197
198
199
200
201
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 197

def post_batch_unlock( post_batch_unlock_request, opts = {})

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

#post_cell_calculate(post_cell_calculate_request, opts = {}) ⇒ Object

Calculate cell formula in the worksheet.



333
334
335
336
337
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 333

def post_cell_calculate( post_cell_calculate_request, opts = {})

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

#post_cell_characters(post_cell_characters_request, opts = {}) ⇒ Object

Set cell characters in the worksheet.



341
342
343
344
345
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 341

def post_cell_characters( post_cell_characters_request, opts = {})

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

#post_chart_category_axis(post_chart_category_axis_request, opts = {}) ⇒ Object

Update chart category axis in the chart.



741
742
743
744
745
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 741

def post_chart_category_axis( post_chart_category_axis_request, opts = {})

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

#post_chart_second_category_axis(post_chart_second_category_axis_request, opts = {}) ⇒ Object

Update chart sencond category axis in the chart.



757
758
759
760
761
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 757

def post_chart_second_category_axis( post_chart_second_category_axis_request, opts = {})

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

#post_chart_second_value_axis(post_chart_second_value_axis_request, opts = {}) ⇒ Object

Update chart sencond value axis in the chart.



765
766
767
768
769
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 765

def post_chart_second_value_axis( post_chart_second_value_axis_request, opts = {})

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

#post_chart_series_axis(post_chart_series_axis_request, opts = {}) ⇒ Object

Update chart series axis in the chart.



733
734
735
736
737
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 733

def post_chart_series_axis( post_chart_series_axis_request, opts = {})

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

#post_chart_value_axis(post_chart_value_axis_request, opts = {}) ⇒ Object

Update chart value axis in the chart.



749
750
751
752
753
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 749

def post_chart_value_axis( post_chart_value_axis_request, opts = {})

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

#post_clear_contents(post_clear_contents_request, opts = {}) ⇒ Object

Clear cell area contents in the worksheet.



221
222
223
224
225
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 221

def post_clear_contents( post_clear_contents_request, opts = {})

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

#post_clear_formats(post_clear_formats_request, opts = {}) ⇒ Object

Clear cell formats in the worksheet.



229
230
231
232
233
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 229

def post_clear_formats( post_clear_formats_request, opts = {})

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

#post_clear_objects(post_clear_objects_request, opts = {}) ⇒ Object

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



1158
1159
1160
1161
1162
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1158

def post_clear_objects( post_clear_objects_request, opts = {})

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

#post_column_style(post_column_style_request, opts = {}) ⇒ Object

Set column style in the worksheet.



429
430
431
432
433
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 429

def post_column_style( post_column_style_request, opts = {})

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

#post_compress(post_compress_request, opts = {}) ⇒ Object

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



1102
1103
1104
1105
1106
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1102

def post_compress( post_compress_request, opts = {})

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

#post_convert_workbook_to_csv(post_convert_workbook_to_csv_request, opts = {}) ⇒ Object

Convert Excel file to Csv files.



933
934
935
936
937
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 933

def post_convert_workbook_to_csv( post_convert_workbook_to_csv_request, opts = {})

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

#post_convert_workbook_to_docx(post_convert_workbook_to_docx_request, opts = {}) ⇒ Object

Convert Excel file to Docx files.



885
886
887
888
889
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 885

def post_convert_workbook_to_docx( post_convert_workbook_to_docx_request, opts = {})

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

#post_convert_workbook_to_html(post_convert_workbook_to_html_request, opts = {}) ⇒ Object

Convert Excel file to HTML files.



901
902
903
904
905
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 901

def post_convert_workbook_to_html( post_convert_workbook_to_html_request, opts = {})

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

#post_convert_workbook_to_json(post_convert_workbook_to_json_request, opts = {}) ⇒ Object

Convert Excel file to Json files.



917
918
919
920
921
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 917

def post_convert_workbook_to_json( post_convert_workbook_to_json_request, opts = {})

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

#post_convert_workbook_to_markdown(post_convert_workbook_to_markdown_request, opts = {}) ⇒ Object

Convert Excel file to Markdown files.



909
910
911
912
913
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 909

def post_convert_workbook_to_markdown( post_convert_workbook_to_markdown_request, opts = {})

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

#post_convert_workbook_to_pdf(post_convert_workbook_to_pdf_request, opts = {}) ⇒ Object

Convert Excel file to PDF files.



869
870
871
872
873
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 869

def post_convert_workbook_to_pdf( post_convert_workbook_to_pdf_request, opts = {})

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

#post_convert_workbook_to_png(post_convert_workbook_to_png_request, opts = {}) ⇒ Object

Convert Excel file to PNG files.



877
878
879
880
881
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 877

def post_convert_workbook_to_png( post_convert_workbook_to_png_request, opts = {})

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

#post_convert_workbook_to_pptx(post_convert_workbook_to_pptx_request, opts = {}) ⇒ Object

Convert Excel file to Pptx files.



893
894
895
896
897
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 893

def post_convert_workbook_to_pptx( post_convert_workbook_to_pptx_request, opts = {})

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

#post_convert_workbook_to_sql(post_convert_workbook_to_sql_request, opts = {}) ⇒ Object

Convert Excel file to SQL Script files.



925
926
927
928
929
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 925

def post_convert_workbook_to_sql( post_convert_workbook_to_sql_request, opts = {})

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

#post_copy_cell_into_cell(post_copy_cell_into_cell_request, opts = {}) ⇒ Object

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



309
310
311
312
313
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 309

def post_copy_cell_into_cell( post_copy_cell_into_cell_request, opts = {})

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

#post_copy_worksheet(post_copy_worksheet_request, opts = {}) ⇒ Object

Copy contents and formats from another worksheet.



2554
2555
2556
2557
2558
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2554

def post_copy_worksheet( post_copy_worksheet_request, opts = {})

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

#post_copy_worksheet_columns(post_copy_worksheet_columns_request, opts = {}) ⇒ Object

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



421
422
423
424
425
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 421

def post_copy_worksheet_columns( post_copy_worksheet_columns_request, opts = {})

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

#post_copy_worksheet_rows(post_copy_worksheet_rows_request, opts = {}) ⇒ Object

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



525
526
527
528
529
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 525

def post_copy_worksheet_rows( post_copy_worksheet_rows_request, opts = {})

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

#post_data_cleansing(post_data_cleansing_request, opts = {}) ⇒ Object

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



990
991
992
993
994
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 990

def post_data_cleansing( post_data_cleansing_request, opts = {})

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

#post_data_deduplication(post_data_deduplication_request, opts = {}) ⇒ Object

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



1006
1007
1008
1009
1010
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1006

def post_data_deduplication( post_data_deduplication_request, opts = {})

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

#post_data_fill(post_data_fill_request, opts = {}) ⇒ Object

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



1022
1023
1024
1025
1026
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1022

def post_data_fill( post_data_fill_request, opts = {})

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

#post_data_transformation(post_data_transformation_request, opts = {}) ⇒ Object

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



1038
1039
1040
1041
1042
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1038

def post_data_transformation( post_data_transformation_request, opts = {})

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

#post_delete_incomplete_rows(post_delete_incomplete_rows_request, opts = {}) ⇒ Object

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



1030
1031
1032
1033
1034
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1030

def post_delete_incomplete_rows( post_delete_incomplete_rows_request, opts = {})

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

#post_digital_signature(post_digital_signature_request, opts = {}) ⇒ Object

Excel file digital signature.



1774
1775
1776
1777
1778
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1774

def post_digital_signature( post_digital_signature_request, opts = {})

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

#post_encrypt_workbook(post_encrypt_workbook_request, opts = {}) ⇒ Object

Excel Encryption.



1782
1783
1784
1785
1786
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1782

def post_encrypt_workbook( post_encrypt_workbook_request, opts = {})

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

#post_export(post_export_request, opts = {}) ⇒ Object

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



941
942
943
944
945
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 941

def post_export( post_export_request, opts = {})

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

#post_fit_tall_to_pages(post_fit_tall_to_pages_request, opts = {}) ⇒ Object

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



1510
1511
1512
1513
1514
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1510

def post_fit_tall_to_pages( post_fit_tall_to_pages_request, opts = {})

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

#post_fit_wide_to_pages(post_fit_wide_to_pages_request, opts = {}) ⇒ Object

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



1502
1503
1504
1505
1506
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1502

def post_fit_wide_to_pages( post_fit_wide_to_pages_request, opts = {})

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

#post_footer(post_footer_request, opts = {}) ⇒ Object

Update page footer in the worksheet.



1494
1495
1496
1497
1498
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1494

def ( , opts = {})

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

#post_group_worksheet_columns(post_group_worksheet_columns_request, opts = {}) ⇒ Object

Group worksheet columns in the worksheet.



405
406
407
408
409
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 405

def post_group_worksheet_columns( post_group_worksheet_columns_request, opts = {})

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

#post_group_worksheet_rows(post_group_worksheet_rows_request, opts = {}) ⇒ Object

Group rows in the worksheet.



509
510
511
512
513
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 509

def post_group_worksheet_rows( post_group_worksheet_rows_request, opts = {})

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

#post_header(post_header_request, opts = {}) ⇒ Object

Update page header in the worksheet.



1478
1479
1480
1481
1482
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1478

def post_header( post_header_request, opts = {})

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

#post_hide_worksheet_columns(post_hide_worksheet_columns_request, opts = {}) ⇒ Object

Hide worksheet columns in the worksheet.



389
390
391
392
393
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 389

def post_hide_worksheet_columns( post_hide_worksheet_columns_request, opts = {})

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

#post_hide_worksheet_rows(post_hide_worksheet_rows_request, opts = {}) ⇒ Object

Hide rows in worksheet.



493
494
495
496
497
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 493

def post_hide_worksheet_rows( post_hide_worksheet_rows_request, opts = {})

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

#post_import(post_import_request, opts = {}) ⇒ Object

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



1142
1143
1144
1145
1146
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1142

def post_import( post_import_request, opts = {})

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

#post_import_data(post_import_data_request, opts = {}) ⇒ Object

Import data into the Excel file.



974
975
976
977
978
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 974

def post_import_data( post_import_data_request, opts = {})

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

#post_lock(post_lock_request, opts = {}) ⇒ Object

Lock Excel files.



1838
1839
1840
1841
1842
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1838

def post_lock( post_lock_request, opts = {})

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

#post_merge(post_merge_request, opts = {}) ⇒ Object

Merge cells in the worksheet.



1110
1111
1112
1113
1114
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1110

def post_merge( post_merge_request, opts = {})

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

#post_metadata(post_metadata_request, opts = {}) ⇒ Object

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



1190
1191
1192
1193
1194
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1190

def ( , opts = {})

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

#post_move_worksheet(post_move_worksheet_request, opts = {}) ⇒ Object

Move worksheet in the workbook.



2362
2363
2364
2365
2366
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2362

def post_move_worksheet( post_move_worksheet_request, opts = {})

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

#post_page_setup(post_page_setup_request, opts = {}) ⇒ Object

Update page setup in the worksheet.



1454
1455
1456
1457
1458
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1454

def post_page_setup( post_page_setup_request, opts = {})

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

#post_pivot_table_cell_style(post_pivot_table_cell_style_request, opts = {}) ⇒ Object

Update cell style in the PivotTable.



1646
1647
1648
1649
1650
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1646

def post_pivot_table_cell_style( post_pivot_table_cell_style_request, opts = {})

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

#post_pivot_table_field_hide_item(post_pivot_table_field_hide_item_request, opts = {}) ⇒ Object

Hide a pivot field item in the PivotTable.



1630
1631
1632
1633
1634
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1630

def post_pivot_table_field_hide_item( post_pivot_table_field_hide_item_request, opts = {})

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

#post_pivot_table_field_move_to(post_pivot_table_field_move_to_request, opts = {}) ⇒ Object

Move a pivot field in the PivotTable.



1638
1639
1640
1641
1642
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1638

def post_pivot_table_field_move_to( post_pivot_table_field_move_to_request, opts = {})

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

#post_pivot_table_style(post_pivot_table_style_request, opts = {}) ⇒ Object

Update style in the PivotTable.



1654
1655
1656
1657
1658
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1654

def post_pivot_table_style( post_pivot_table_style_request, opts = {})

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

#post_pivot_table_update_pivot_field(post_pivot_table_update_pivot_field_request, opts = {}) ⇒ Object

Update pivot field in the PivotTable.



1670
1671
1672
1673
1674
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1670

def post_pivot_table_update_pivot_field( post_pivot_table_update_pivot_field_request, opts = {})

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

#post_pivot_table_update_pivot_fields(post_pivot_table_update_pivot_fields_request, opts = {}) ⇒ Object

Update pivot fields in the PivotTable.



1662
1663
1664
1665
1666
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1662

def post_pivot_table_update_pivot_fields( post_pivot_table_update_pivot_fields_request, opts = {})

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

#post_protect(post_protect_request, opts = {}) ⇒ Object

Excel files encryption.



1846
1847
1848
1849
1850
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1846

def post_protect( post_protect_request, opts = {})

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

#post_protect_workbook(post_protect_workbook_request, opts = {}) ⇒ Object

Excel protection.



1798
1799
1800
1801
1802
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1798

def post_protect_workbook( post_protect_workbook_request, opts = {})

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

#post_remove_characters(post_remove_characters_request, opts = {}) ⇒ Object



2098
2099
2100
2101
2102
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2098

def post_remove_characters( post_remove_characters_request, opts = {})

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

#post_rename_worksheet(post_rename_worksheet_request, opts = {}) ⇒ Object

Rename worksheet in the workbook.



2562
2563
2564
2565
2566
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2562

def post_rename_worksheet( post_rename_worksheet_request, opts = {})

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

#post_repair(post_repair_request, opts = {}) ⇒ Object

Repair abnormal files and generate files in various formats.



1174
1175
1176
1177
1178
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1174

def post_repair( post_repair_request, opts = {})

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

#post_replace(post_replace_request, opts = {}) ⇒ Object

Replace specified text with new text in Excel files.



1134
1135
1136
1137
1138
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1134

def post_replace( post_replace_request, opts = {})

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

#post_reverse(post_reverse_request, opts = {}) ⇒ Object

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



1166
1167
1168
1169
1170
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1166

def post_reverse( post_reverse_request, opts = {})

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

#post_rotate(post_rotate_request, opts = {}) ⇒ Object

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



1182
1183
1184
1185
1186
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1182

def post_rotate( post_rotate_request, opts = {})

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

#post_row_style(post_row_style_request, opts = {}) ⇒ Object

Apply formats to an entire row in the worksheet.



533
534
535
536
537
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 533

def post_row_style( post_row_style_request, opts = {})

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

#post_run_task(post_run_task_request, opts = {}) ⇒ Object

Run tasks.



2070
2071
2072
2073
2074
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2070

def post_run_task( post_run_task_request, opts = {})

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

#post_search(post_search_request, opts = {}) ⇒ Object

Search for specified text within Excel files.



1126
1127
1128
1129
1130
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1126

def post_search( post_search_request, opts = {})

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

#post_set_cell_html_string(post_set_cell_html_string_request, opts = {}) ⇒ Object

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



325
326
327
328
329
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 325

def post_set_cell_html_string( post_set_cell_html_string_request, opts = {})

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

#post_set_cell_range_value(post_set_cell_range_value_request, opts = {}) ⇒ Object

Set the value of the range in the worksheet.



301
302
303
304
305
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 301

def post_set_cell_range_value( post_set_cell_range_value_request, opts = {})

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

#post_set_worksheet_column_width(post_set_worksheet_column_width_request, opts = {}) ⇒ Object

Set worksheet column width.



357
358
359
360
361
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 357

def post_set_worksheet_column_width( post_set_worksheet_column_width_request, opts = {})

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

#post_split(post_split_request, opts = {}) ⇒ Object

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



1118
1119
1120
1121
1122
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1118

def post_split( post_split_request, opts = {})

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

#post_trim_content(post_trim_content_request, opts = {}) ⇒ Object



2084
2085
2086
2087
2088
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2084

def post_trim_content( post_trim_content_request, opts = {})

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

#post_ungroup_worksheet_columns(post_ungroup_worksheet_columns_request, opts = {}) ⇒ Object

Ungroup worksheet columns.



413
414
415
416
417
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 413

def post_ungroup_worksheet_columns( post_ungroup_worksheet_columns_request, opts = {})

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

#post_ungroup_worksheet_rows(post_ungroup_worksheet_rows_request, opts = {}) ⇒ Object

Ungroup rows in the worksheet.



517
518
519
520
521
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 517

def post_ungroup_worksheet_rows( post_ungroup_worksheet_rows_request, opts = {})

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

#post_unhide_worksheet_columns(post_unhide_worksheet_columns_request, opts = {}) ⇒ Object

Unhide worksheet columns in the worksheet.



397
398
399
400
401
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 397

def post_unhide_worksheet_columns( post_unhide_worksheet_columns_request, opts = {})

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

#post_unhide_worksheet_rows(post_unhide_worksheet_rows_request, opts = {}) ⇒ Object

Unhide rows in the worksheet.



501
502
503
504
505
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 501

def post_unhide_worksheet_rows( post_unhide_worksheet_rows_request, opts = {})

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

#post_unlock(post_unlock_request, opts = {}) ⇒ Object

Unlock Excel files.



1830
1831
1832
1833
1834
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1830

def post_unlock( post_unlock_request, opts = {})

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

#post_update_word_case(post_update_word_case_request, opts = {}) ⇒ Object



2091
2092
2093
2094
2095
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2091

def post_update_word_case( post_update_word_case_request, opts = {})

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

#post_update_worksheet_cell_style(post_update_worksheet_cell_style_request, opts = {}) ⇒ Object

Set cell style using cell name in the worksheet.



293
294
295
296
297
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 293

def post_update_worksheet_cell_style( post_update_worksheet_cell_style_request, opts = {})

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

#post_update_worksheet_ole_object(post_update_worksheet_ole_object_request, opts = {}) ⇒ Object

Update an OLE object in worksheet.



1350
1351
1352
1353
1354
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1350

def post_update_worksheet_ole_object( post_update_worksheet_ole_object_request, opts = {})

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

#post_update_worksheet_property(post_update_worksheet_property_request, opts = {}) ⇒ Object

Update worksheet properties in the workbook.



2570
2571
2572
2573
2574
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2570

def post_update_worksheet_property( post_update_worksheet_property_request, opts = {})

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

#post_update_worksheet_range_style(post_update_worksheet_range_style_request, opts = {}) ⇒ Object

Update cell range styles in the worksheet.



237
238
239
240
241
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 237

def post_update_worksheet_range_style( post_update_worksheet_range_style_request, opts = {})

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

#post_update_worksheet_row(post_update_worksheet_row_request, opts = {}) ⇒ Object

Update height of rows in the worksheet.



485
486
487
488
489
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 485

def post_update_worksheet_row( post_update_worksheet_row_request, opts = {})

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

#post_update_worksheet_zoom(post_update_worksheet_zoom_request, opts = {}) ⇒ Object

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



2594
2595
2596
2597
2598
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2594

def post_update_worksheet_zoom( post_update_worksheet_zoom_request, opts = {})

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

#post_watermark(post_watermark_request, opts = {}) ⇒ Object

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



1150
1151
1152
1153
1154
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1150

def post_watermark( post_watermark_request, opts = {})

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

#post_workbook_calculate_formula(post_workbook_calculate_formula_request, opts = {}) ⇒ Object

Calculate all formulas in the workbook.



2226
2227
2228
2229
2230
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2226

def post_workbook_calculate_formula( post_workbook_calculate_formula_request, opts = {})

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

#post_workbook_data_cleansing(post_workbook_data_cleansing_request, opts = {}) ⇒ Object

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



982
983
984
985
986
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 982

def post_workbook_data_cleansing( post_workbook_data_cleansing_request, opts = {})

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

#post_workbook_data_deduplication(post_workbook_data_deduplication_request, opts = {}) ⇒ Object

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



998
999
1000
1001
1002
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 998

def post_workbook_data_deduplication( post_workbook_data_deduplication_request, opts = {})

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

#post_workbook_data_fill(post_workbook_data_fill_request, opts = {}) ⇒ Object

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



1014
1015
1016
1017
1018
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1014

def post_workbook_data_fill( post_workbook_data_fill_request, opts = {})

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

#post_workbook_export_xml(post_workbook_export_xml_request, opts = {}) ⇒ Object

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



950
951
952
953
954
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 950

def post_workbook_export_xml( post_workbook_export_xml_request, opts = {})

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

#post_workbook_get_smart_marker_result(post_workbook_get_smart_marker_result_request, opts = {}) ⇒ Object

Smart marker processing.



2202
2203
2204
2205
2206
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2202

def post_workbook_get_smart_marker_result( post_workbook_get_smart_marker_result_request, opts = {})

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

#post_workbook_import_json(post_workbook_import_json_request, opts = {}) ⇒ Object

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



958
959
960
961
962
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 958

def post_workbook_import_json( post_workbook_import_json_request, opts = {})

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

#post_workbook_import_xml(post_workbook_import_xml_request, opts = {}) ⇒ Object

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



966
967
968
969
970
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 966

def post_workbook_import_xml( post_workbook_import_xml_request, opts = {})

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

#post_workbook_name(post_workbook_name_request, opts = {}) ⇒ Object

Update a named range in the workbook.



2146
2147
2148
2149
2150
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2146

def post_workbook_name( post_workbook_name_request, opts = {})

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

#post_workbook_save_as(post_workbook_save_as_request, opts = {}) ⇒ Object

Save an Excel file in various formats.



861
862
863
864
865
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 861

def post_workbook_save_as( post_workbook_save_as_request, opts = {})

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

#post_workbook_settings(post_workbook_settings_request, opts = {}) ⇒ Object

Update setting in the workbook.



2258
2259
2260
2261
2262
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2258

def post_workbook_settings( post_workbook_settings_request, opts = {})

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

#post_workbook_split(post_workbook_split_request, opts = {}) ⇒ Object

Split the workbook with a specific format.



2218
2219
2220
2221
2222
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2218

def post_workbook_split( post_workbook_split_request, opts = {})

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

#post_workbook_text_replace(post_workbook_text_replace_request, opts = {}) ⇒ Object

Replace text in the workbook.



2194
2195
2196
2197
2198
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2194

def post_workbook_text_replace( post_workbook_text_replace_request, opts = {})

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

#post_workbooks_merge(post_workbooks_merge_request, opts = {}) ⇒ Object

Merge a workbook into the existing workbook.



2178
2179
2180
2181
2182
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2178

def post_workbooks_merge( post_workbooks_merge_request, opts = {})

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

#post_workbooks_text_search(post_workbooks_text_search_request, opts = {}) ⇒ Object

Search for text in the workbook.



2186
2187
2188
2189
2190
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2186

def post_workbooks_text_search( post_workbooks_text_search_request, opts = {})

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

#post_worksheet_auto_filter_refresh(post_worksheet_auto_filter_refresh_request, opts = {}) ⇒ Object

Refresh auto filters in the worksheet.



133
134
135
136
137
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 133

def post_worksheet_auto_filter_refresh( post_worksheet_auto_filter_refresh_request, opts = {})

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

#post_worksheet_calculate_formula(post_worksheet_calculate_formula_request, opts = {}) ⇒ Object

Calculate formula in the worksheet.



2466
2467
2468
2469
2470
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2466

def post_worksheet_calculate_formula( post_worksheet_calculate_formula_request, opts = {})

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

#post_worksheet_cell_set_value(post_worksheet_cell_set_value_request, opts = {}) ⇒ Object

Set cell value using cell name in the worksheet.



285
286
287
288
289
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 285

def post_worksheet_cell_set_value( post_worksheet_cell_set_value_request, opts = {})

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

#post_worksheet_cells_range_column_width(post_worksheet_cells_range_column_width_request, opts = {}) ⇒ Object

Set the column width of the specified range.



1926
1927
1928
1929
1930
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1926

def post_worksheet_cells_range_column_width( post_worksheet_cells_range_column_width_request, opts = {})

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

#post_worksheet_cells_range_merge(post_worksheet_cells_range_merge_request, opts = {}) ⇒ Object

Merge a range of cells into a single cell.



1862
1863
1864
1865
1866
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1862

def post_worksheet_cells_range_merge( post_worksheet_cells_range_merge_request, opts = {})

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

#post_worksheet_cells_range_move_to(post_worksheet_cells_range_move_to_request, opts = {}) ⇒ Object

Move the current range to the destination range.



1902
1903
1904
1905
1906
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1902

def post_worksheet_cells_range_move_to( post_worksheet_cells_range_move_to_request, opts = {})

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

#post_worksheet_cells_range_outline_border(post_worksheet_cells_range_outline_border_request, opts = {}) ⇒ Object

Apply an outline border around a range of cells.



1918
1919
1920
1921
1922
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1918

def post_worksheet_cells_range_outline_border( post_worksheet_cells_range_outline_border_request, opts = {})

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

#post_worksheet_cells_range_row_height(post_worksheet_cells_range_row_height_request, opts = {}) ⇒ Object

Sets row height of range.



1934
1935
1936
1937
1938
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1934

def post_worksheet_cells_range_row_height( post_worksheet_cells_range_row_height_request, opts = {})

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

#post_worksheet_cells_range_sort(post_worksheet_cells_range_sort_request, opts = {}) ⇒ Object

Perform data sorting around a range of cells.



1910
1911
1912
1913
1914
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1910

def post_worksheet_cells_range_sort( post_worksheet_cells_range_sort_request, opts = {})

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

#post_worksheet_cells_range_style(post_worksheet_cells_range_style_request, opts = {}) ⇒ Object

Set the style for the specified range.



1878
1879
1880
1881
1882
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1878

def post_worksheet_cells_range_style( post_worksheet_cells_range_style_request, opts = {})

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

#post_worksheet_cells_range_un_merge(post_worksheet_cells_range_un_merge_request, opts = {}) ⇒ Object

Unmerge merged cells within this range.



1870
1871
1872
1873
1874
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1870

def post_worksheet_cells_range_un_merge( post_worksheet_cells_range_un_merge_request, opts = {})

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

#post_worksheet_cells_range_value(post_worksheet_cells_range_value_request, opts = {}) ⇒ Object

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



1894
1895
1896
1897
1898
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1894

def post_worksheet_cells_range_value( post_worksheet_cells_range_value_request, opts = {})

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

#post_worksheet_cells_ranges_copy(post_worksheet_cells_ranges_copy_request, opts = {}) ⇒ Object

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



1854
1855
1856
1857
1858
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1854

def post_worksheet_cells_ranges_copy( post_worksheet_cells_ranges_copy_request, opts = {})

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

#post_worksheet_chart(post_worksheet_chart_request, opts = {}) ⇒ Object

Update chart properties in the worksheet.



613
614
615
616
617
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 613

def post_worksheet_chart( post_worksheet_chart_request, opts = {})

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

#post_worksheet_chart_legend(post_worksheet_chart_legend_request, opts = {}) ⇒ Object

Update chart legend in the worksheet.



629
630
631
632
633
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 629

def post_worksheet_chart_legend( post_worksheet_chart_legend_request, opts = {})

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

#post_worksheet_chart_title(post_worksheet_chart_title_request, opts = {}) ⇒ Object

Update chart title in the worksheet.



669
670
671
672
673
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 669

def post_worksheet_chart_title( post_worksheet_chart_title_request, opts = {})

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

#post_worksheet_comment(post_worksheet_comment_request, opts = {}) ⇒ Object

Update cell comment in the worksheet.



2418
2419
2420
2421
2422
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2418

def post_worksheet_comment( post_worksheet_comment_request, opts = {})

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

#post_worksheet_group_shape(post_worksheet_group_shape_request, opts = {}) ⇒ Object

Group shapes in the worksheet.



2006
2007
2008
2009
2010
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2006

def post_worksheet_group_shape( post_worksheet_group_shape_request, opts = {})

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

#post_worksheet_hyperlink(post_worksheet_hyperlink_request, opts = {}) ⇒ Object

Update hyperlink by index in the worksheet.



1070
1071
1072
1073
1074
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1070

def post_worksheet_hyperlink( post_worksheet_hyperlink_request, opts = {})

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

#post_worksheet_list_column(post_worksheet_list_column_request, opts = {}) ⇒ Object

Update list column in list object.



1302
1303
1304
1305
1306
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1302

def post_worksheet_list_column( post_worksheet_list_column_request, opts = {})

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

#post_worksheet_list_columns_total(post_worksheet_list_columns_total_request, opts = {}) ⇒ Object

Update total of list columns in the table.



1310
1311
1312
1313
1314
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1310

def post_worksheet_list_columns_total( post_worksheet_list_columns_total_request, opts = {})

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

#post_worksheet_list_object(post_worksheet_list_object_request, opts = {}) ⇒ Object

Update list object by index in the worksheet.



1254
1255
1256
1257
1258
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1254

def post_worksheet_list_object( post_worksheet_list_object_request, opts = {})

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

#post_worksheet_list_object_convert_to_range(post_worksheet_list_object_convert_to_range_request, opts = {}) ⇒ Object

Convert list object to range in the worksheet.



1262
1263
1264
1265
1266
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1262

def post_worksheet_list_object_convert_to_range( post_worksheet_list_object_convert_to_range_request, opts = {})

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

#post_worksheet_list_object_insert_slicer(post_worksheet_list_object_insert_slicer_request, opts = {}) ⇒ Object

Insert slicer for list object.



1294
1295
1296
1297
1298
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1294

def post_worksheet_list_object_insert_slicer( post_worksheet_list_object_insert_slicer_request, opts = {})

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

#post_worksheet_list_object_remove_duplicates(post_worksheet_list_object_remove_duplicates_request, opts = {}) ⇒ Object

Remove duplicates in list object.



1286
1287
1288
1289
1290
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1286

def post_worksheet_list_object_remove_duplicates( post_worksheet_list_object_remove_duplicates_request, opts = {})

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

#post_worksheet_list_object_sort_table(post_worksheet_list_object_sort_table_request, opts = {}) ⇒ Object

Sort list object in the worksheet.



1278
1279
1280
1281
1282
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1278

def post_worksheet_list_object_sort_table( post_worksheet_list_object_sort_table_request, opts = {})

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

#post_worksheet_list_object_summarize_with_pivot_table(post_worksheet_list_object_summarize_with_pivot_table_request, opts = {}) ⇒ Object

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



1270
1271
1272
1273
1274
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1270

def post_worksheet_list_object_summarize_with_pivot_table( post_worksheet_list_object_summarize_with_pivot_table_request, opts = {})

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

#post_worksheet_match_blanks(post_worksheet_match_blanks_request, opts = {}) ⇒ Object

Match all blank cells in the list.



117
118
119
120
121
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 117

def post_worksheet_match_blanks( post_worksheet_match_blanks_request, opts = {})

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

#post_worksheet_match_non_blanks(post_worksheet_match_non_blanks_request, opts = {}) ⇒ Object

Match all not blank cells in the list.



125
126
127
128
129
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 125

def post_worksheet_match_non_blanks( post_worksheet_match_non_blanks_request, opts = {})

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

#post_worksheet_merge(post_worksheet_merge_request, opts = {}) ⇒ Object

Merge cells in the worksheet.



245
246
247
248
249
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 245

def post_worksheet_merge( post_worksheet_merge_request, opts = {})

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

#post_worksheet_picture(post_worksheet_picture_request, opts = {}) ⇒ Object

Update a picture by index in the worksheet.



1542
1543
1544
1545
1546
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1542

def post_worksheet_picture( post_worksheet_picture_request, opts = {})

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

#post_worksheet_pivot_table_calculate(post_worksheet_pivot_table_calculate_request, opts = {}) ⇒ Object

Calculate pivottable’s data to cells.



1678
1679
1680
1681
1682
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1678

def post_worksheet_pivot_table_calculate( post_worksheet_pivot_table_calculate_request, opts = {})

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

#post_worksheet_pivot_table_move(post_worksheet_pivot_table_move_request, opts = {}) ⇒ Object

Move PivotTable in the worksheet.



1686
1687
1688
1689
1690
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1686

def post_worksheet_pivot_table_move( post_worksheet_pivot_table_move_request, opts = {})

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

#post_worksheet_range_sort(post_worksheet_range_sort_request, opts = {}) ⇒ Object

Sort a range in the worksheet.



2490
2491
2492
2493
2494
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2490

def post_worksheet_range_sort( post_worksheet_range_sort_request, opts = {})

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

#post_worksheet_shape(post_worksheet_shape_request, opts = {}) ⇒ Object

Update a shape in the worksheet.



1998
1999
2000
2001
2002
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1998

def post_worksheet_shape( post_worksheet_shape_request, opts = {})

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

#post_worksheet_sparkline_group(post_worksheet_sparkline_group_request, opts = {}) ⇒ Object

Update a sparkline group in the worksheet.



2062
2063
2064
2065
2066
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2062

def post_worksheet_sparkline_group( post_worksheet_sparkline_group_request, opts = {})

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

#post_worksheet_text_replace(post_worksheet_text_replace_request, opts = {}) ⇒ Object

Replace old text with new text in the worksheet.



2482
2483
2484
2485
2486
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2482

def post_worksheet_text_replace( post_worksheet_text_replace_request, opts = {})

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

#post_worksheet_text_search(post_worksheet_text_search_request, opts = {}) ⇒ Object

Search for text in the worksheet.



2474
2475
2476
2477
2478
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2474

def post_worksheet_text_search( post_worksheet_text_search_request, opts = {})

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

#post_worksheet_ungroup_shape(post_worksheet_ungroup_shape_request, opts = {}) ⇒ Object

Ungroup shapes in the worksheet.



2014
2015
2016
2017
2018
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2014

def post_worksheet_ungroup_shape( post_worksheet_ungroup_shape_request, opts = {})

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

#post_worksheet_unmerge(post_worksheet_unmerge_request, opts = {}) ⇒ Object

Unmerge cells in the worksheet.



253
254
255
256
257
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 253

def post_worksheet_unmerge( post_worksheet_unmerge_request, opts = {})

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

#post_worksheet_validation(post_worksheet_validation_request, opts = {}) ⇒ Object

Update a validation by index in the worksheet.



2634
2635
2636
2637
2638
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2634

def post_worksheet_validation( post_worksheet_validation_request, opts = {})

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

#put_active_worksheet(put_active_worksheet_request, opts = {}) ⇒ Object

Set active worksheet index in the workbook.



2322
2323
2324
2325
2326
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2322

def put_active_worksheet( put_active_worksheet_request, opts = {})

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

#put_add_new_worksheet(put_add_new_worksheet_request, opts = {}) ⇒ Object

Add a new worksheet in the workbook.



2338
2339
2340
2341
2342
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2338

def put_add_new_worksheet( put_add_new_worksheet_request, opts = {})

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

#put_change_visibility_worksheet(put_change_visibility_worksheet_request, opts = {}) ⇒ Object

Change worksheet visibility in the workbook.



2314
2315
2316
2317
2318
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2314

def put_change_visibility_worksheet( put_change_visibility_worksheet_request, opts = {})

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

#put_convert_workbook(put_convert_workbook_request, opts = {}) ⇒ Object

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



853
854
855
856
857
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 853

def put_convert_workbook( put_convert_workbook_request, opts = {})

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

#put_document_property(put_document_property_request, opts = {}) ⇒ Object

Set or add an Excel property.



1742
1743
1744
1745
1746
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1742

def put_document_property( put_document_property_request, opts = {})

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

#put_document_protect_from_changes(put_document_protect_from_changes_request, opts = {}) ⇒ Object

Excel file write protection.



1814
1815
1816
1817
1818
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1814

def put_document_protect_from_changes( put_document_protect_from_changes_request, opts = {})

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

#put_horizontal_page_break(put_horizontal_page_break_request, opts = {}) ⇒ Object

Add a horizontal page breaks in the worksheet.



1406
1407
1408
1409
1410
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1406

def put_horizontal_page_break( put_horizontal_page_break_request, opts = {})

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

#put_insert_new_worksheet(put_insert_new_worksheet_request, opts = {}) ⇒ Object

Insert a new worksheet in the workbook.



2330
2331
2332
2333
2334
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2330

def put_insert_new_worksheet( put_insert_new_worksheet_request, opts = {})

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

#put_insert_worksheet_columns(put_insert_worksheet_columns_request, opts = {}) ⇒ Object

Insert worksheet columns in the worksheet.



373
374
375
376
377
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 373

def put_insert_worksheet_columns( put_insert_worksheet_columns_request, opts = {})

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

#put_insert_worksheet_row(put_insert_worksheet_row_request, opts = {}) ⇒ Object

Insert a new row in the worksheet.



477
478
479
480
481
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 477

def put_insert_worksheet_row( put_insert_worksheet_row_request, opts = {})

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

#put_insert_worksheet_rows(put_insert_worksheet_rows_request, opts = {}) ⇒ Object

Insert several new rows in the worksheet.



469
470
471
472
473
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 469

def put_insert_worksheet_rows( put_insert_worksheet_rows_request, opts = {})

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

#put_pivot_table_field(put_pivot_table_field_request, opts = {}) ⇒ Object

Add a pivot field in the PivotTable.



1614
1615
1616
1617
1618
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1614

def put_pivot_table_field( put_pivot_table_field_request, opts = {})

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

#put_protect_worksheet(put_protect_worksheet_request, opts = {}) ⇒ Object

Protect worksheet.



2370
2371
2372
2373
2374
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2370

def put_protect_worksheet( put_protect_worksheet_request, opts = {})

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

#put_vertical_page_break(put_vertical_page_break_request, opts = {}) ⇒ Object

Add a vertical page break in the worksheet.



1398
1399
1400
1401
1402
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1398

def put_vertical_page_break( put_vertical_page_break_request, opts = {})

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

#put_workbook_background(put_workbook_background_request, opts = {}) ⇒ Object

Set background in the workbook.



2266
2267
2268
2269
2270
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2266

def put_workbook_background( put_workbook_background_request, opts = {})

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

#put_workbook_create(put_workbook_create_request, opts = {}) ⇒ Object

Create a new workbook using different methods.



2210
2211
2212
2213
2214
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2210

def put_workbook_create( put_workbook_create_request, opts = {})

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

#put_workbook_name(put_workbook_name_request, opts = {}) ⇒ Object

Define a new name in the workbook.



2130
2131
2132
2133
2134
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2130

def put_workbook_name( put_workbook_name_request, opts = {})

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

#put_workbook_water_marker(put_workbook_water_marker_request, opts = {}) ⇒ Object

Set water marker in the workbook.



2282
2283
2284
2285
2286
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2282

def put_workbook_water_marker( put_workbook_water_marker_request, opts = {})

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

#put_worksheet_add_picture(put_worksheet_add_picture_request, opts = {}) ⇒ Object

Add a new picture in the worksheet.



1534
1535
1536
1537
1538
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1534

def put_worksheet_add_picture( put_worksheet_add_picture_request, opts = {})

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

#put_worksheet_background(put_worksheet_background_request, opts = {}) ⇒ Object

Set background image in the worksheet.



2522
2523
2524
2525
2526
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2522

def put_worksheet_background( put_worksheet_background_request, opts = {})

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

#put_worksheet_cells_range(put_worksheet_cells_range_request, opts = {}) ⇒ Object

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



1942
1943
1944
1945
1946
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1942

def put_worksheet_cells_range( put_worksheet_cells_range_request, opts = {})

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

#put_worksheet_chart(put_worksheet_chart_request, opts = {}) ⇒ Object

Add a new chart in the worksheet.



597
598
599
600
601
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 597

def put_worksheet_chart( put_worksheet_chart_request, opts = {})

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

#put_worksheet_chart_legend(put_worksheet_chart_legend_request, opts = {}) ⇒ Object

Show chart legend in the worksheet.



637
638
639
640
641
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 637

def put_worksheet_chart_legend( put_worksheet_chart_legend_request, opts = {})

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

#put_worksheet_chart_title(put_worksheet_chart_title_request, opts = {}) ⇒ Object

Set chart title in the worksheet.



677
678
679
680
681
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 677

def put_worksheet_chart_title( put_worksheet_chart_title_request, opts = {})

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

#put_worksheet_color_filter(put_worksheet_color_filter_request, opts = {}) ⇒ Object

Add a color filter in the worksheet.



109
110
111
112
113
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 109

def put_worksheet_color_filter( put_worksheet_color_filter_request, opts = {})

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

#put_worksheet_comment(put_worksheet_comment_request, opts = {}) ⇒ Object

Add cell comment in the worksheet.



2410
2411
2412
2413
2414
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2410

def put_worksheet_comment( put_worksheet_comment_request, opts = {})

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

#put_worksheet_conditional_formatting(put_worksheet_conditional_formatting_request, opts = {}) ⇒ Object

Add conditional formatting in the worksheet.



789
790
791
792
793
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 789

def put_worksheet_conditional_formatting( put_worksheet_conditional_formatting_request, opts = {})

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

#put_worksheet_custom_filter(put_worksheet_custom_filter_request, opts = {}) ⇒ Object

Filter a list with custom criteria in the worksheet.



85
86
87
88
89
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 85

def put_worksheet_custom_filter( put_worksheet_custom_filter_request, opts = {})

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

#put_worksheet_date_filter(put_worksheet_date_filter_request, opts = {}) ⇒ Object

Apply a date filter in the worksheet.



61
62
63
64
65
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 61

def put_worksheet_date_filter( put_worksheet_date_filter_request, opts = {})

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

#put_worksheet_dynamic_filter(put_worksheet_dynamic_filter_request, opts = {}) ⇒ Object

Add a dynamic filter in the worksheet.



93
94
95
96
97
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 93

def put_worksheet_dynamic_filter( put_worksheet_dynamic_filter_request, opts = {})

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

#put_worksheet_filter(put_worksheet_filter_request, opts = {}) ⇒ Object

Add a filter for a column in the worksheet.



69
70
71
72
73
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 69

def put_worksheet_filter( put_worksheet_filter_request, opts = {})

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

#put_worksheet_filter_top10(put_worksheet_filter_top10_request, opts = {}) ⇒ Object

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



101
102
103
104
105
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 101

def put_worksheet_filter_top10( put_worksheet_filter_top10_request, opts = {})

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

#put_worksheet_format_condition(put_worksheet_format_condition_request, opts = {}) ⇒ Object

Add a format condition in the worksheet.



797
798
799
800
801
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 797

def put_worksheet_format_condition( put_worksheet_format_condition_request, opts = {})

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

#put_worksheet_format_condition_area(put_worksheet_format_condition_area_request, opts = {}) ⇒ Object

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



805
806
807
808
809
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 805

def put_worksheet_format_condition_area( put_worksheet_format_condition_area_request, opts = {})

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

#put_worksheet_format_condition_condition(put_worksheet_format_condition_condition_request, opts = {}) ⇒ Object

Add a condition for the format condition in the worksheet.



813
814
815
816
817
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 813

def put_worksheet_format_condition_condition( put_worksheet_format_condition_condition_request, opts = {})

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

#put_worksheet_freeze_panes(put_worksheet_freeze_panes_request, opts = {}) ⇒ Object

Set freeze panes in the worksheet.



2538
2539
2540
2541
2542
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2538

def put_worksheet_freeze_panes( put_worksheet_freeze_panes_request, opts = {})

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

Add hyperlink in the worksheet.



1078
1079
1080
1081
1082
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1078

def put_worksheet_hyperlink( put_worksheet_hyperlink_request, opts = {})

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

#put_worksheet_icon_filter(put_worksheet_icon_filter_request, opts = {}) ⇒ Object

Add an icon filter in the worksheet.



77
78
79
80
81
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 77

def put_worksheet_icon_filter( put_worksheet_icon_filter_request, opts = {})

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

#put_worksheet_list_object(put_worksheet_list_object_request, opts = {}) ⇒ Object

Add a ListObject in the worksheet.



1230
1231
1232
1233
1234
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1230

def put_worksheet_list_object( put_worksheet_list_object_request, opts = {})

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

#put_worksheet_ole_object(put_worksheet_ole_object_request, opts = {}) ⇒ Object

Add an OLE object in the worksheet.



1358
1359
1360
1361
1362
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1358

def put_worksheet_ole_object( put_worksheet_ole_object_request, opts = {})

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

#put_worksheet_pivot_table(put_worksheet_pivot_table_request, opts = {}) ⇒ Object

Add a PivotTable in the worksheet.



1606
1607
1608
1609
1610
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1606

def put_worksheet_pivot_table( put_worksheet_pivot_table_request, opts = {})

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

#put_worksheet_pivot_table_filter(put_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object

Add a pivot filter to the PivotTable.



1622
1623
1624
1625
1626
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1622

def put_worksheet_pivot_table_filter( put_worksheet_pivot_table_filter_request, opts = {})

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

#put_worksheet_shape(put_worksheet_shape_request, opts = {}) ⇒ Object

Add a shape in the worksheet.



1974
1975
1976
1977
1978
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1974

def put_worksheet_shape( put_worksheet_shape_request, opts = {})

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

#put_worksheet_sparkline_group(put_worksheet_sparkline_group_request, opts = {}) ⇒ Object

Add a sparkline group in the worksheet.



2054
2055
2056
2057
2058
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2054

def put_worksheet_sparkline_group( put_worksheet_sparkline_group_request, opts = {})

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

#put_worksheet_validation(put_worksheet_validation_request, opts = {}) ⇒ Object

Add a validation at index in the worksheet.



2626
2627
2628
2629
2630
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2626

def put_worksheet_validation( put_worksheet_validation_request, opts = {})

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

#storage_exists(storage_exists_request, opts = {}) ⇒ Object



2727
2728
2729
2730
2731
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2727

def storage_exists( storage_exists_request, opts = {})

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

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



2664
2665
2666
2667
2668
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2664

def upload_file( upload_file_request, opts = {})

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