aspose_cells_cloud

AsposeCellsCloud - the Ruby gem for the Web API Swagger specification

No description provided (generated by Swagger Codegen https://github.com/swagger-api/swagger-codegen)

This SDK is automatically generated by the Swagger Codegen project:

  • API version: 1.0
  • Package version: 19.6
  • Build package: io.swagger.codegen.languages.RubyClientCodegen

Installation

Build a gem

To build the Ruby code into a gem:

gem build aspose_cells_cloud.gemspec

Then either install the gem locally:

gem install ./aspose_cells_cloud-19.2.gem

(for development, run gem install --dev ./aspose_cells_cloud-19.2.gem to install the development dependencies)

or publish the gem to a gem hosting service, e.g. RubyGems.

Finally add this to the Gemfile:

gem 'aspose_cells_cloud', '~> 19.2'

Install from Git

If the Ruby gem is hosted at a git repository: https://github.com/GIT_USER_ID/GIT_REPO_ID, then add the following in the Gemfile:

gem 'aspose_cells_cloud', :git => 'https://github.com/GIT_USER_ID/GIT_REPO_ID.git'

Include the Ruby code directly

Include the Ruby code directly using -I as follows:

ruby -Ilib script.rb

Getting Started

Please follow the installation procedure and then run the following code:

# Load the gem
require 'aspose_cells_cloud'

api_instance = AsposeCellsCloud::CellsApi.new

name = "name_example" # String | The workbook name.

sheet_name = "sheet_name_example" # String | The worksheet name.

column_index = 56 # Integer | The column index.

columns = 56 # Integer | The columns.

update_reference = true # BOOLEAN | The update reference.

opts = { 
  folder: "folder_example", # String | The workbook folder.
  storage: "storage_example" # String | storage name.
}

begin
  #Delete worksheet columns.
  result = api_instance.cells_delete_worksheet_columns(name, sheet_name, column_index, columns, update_reference, opts)
  p result
rescue AsposeCellsCloud::ApiError => e
  puts "Exception when calling CellsApi->cells_delete_worksheet_columns: #{e}"
end

Documentation for API Endpoints

All URIs are relative to https://api.aspose.cloud/v1.1/

Class Method HTTP request Description
AsposeCellsCloud::CellsApi cells_delete_worksheet_columns DELETE /cells/name/worksheets/sheetName/cells/columns/columnIndex Delete worksheet columns.
AsposeCellsCloud::CellsApi cells_delete_worksheet_row DELETE /cells/name/worksheets/sheetName/cells/rows/rowIndex Delete worksheet row.
AsposeCellsCloud::CellsApi cells_delete_worksheet_rows DELETE /cells/name/worksheets/sheetName/cells/rows Delete several worksheet rows.
AsposeCellsCloud::CellsApi cells_get_cell_html_string GET /cells/name/worksheets/sheetName/cells/cellName/htmlstring Read cell data by cell's name.
AsposeCellsCloud::CellsApi cells_get_worksheet_cell GET /cells/name/worksheets/sheetName/cells/cellOrMethodName Read cell data by cell's name.
AsposeCellsCloud::CellsApi cells_get_worksheet_cell_style GET /cells/name/worksheets/sheetName/cells/cellName/style Read cell's style info.
AsposeCellsCloud::CellsApi cells_get_worksheet_cells GET /cells/name/worksheets/sheetName/cells Get cells info.
AsposeCellsCloud::CellsApi cells_get_worksheet_column GET /cells/name/worksheets/sheetName/cells/columns/columnIndex Read worksheet column data by column's index.
AsposeCellsCloud::CellsApi cells_get_worksheet_columns GET /cells/name/worksheets/sheetName/cells/columns Read worksheet columns info.
AsposeCellsCloud::CellsApi cells_get_worksheet_row GET /cells/name/worksheets/sheetName/cells/rows/rowIndex Read worksheet row data by row's index.
AsposeCellsCloud::CellsApi cells_get_worksheet_rows GET /cells/name/worksheets/sheetName/cells/rows Read worksheet rows info.
AsposeCellsCloud::CellsApi cells_post_cell_calculate POST /cells/name/worksheets/sheetName/cells/cellName/calculate Cell calculate formula
AsposeCellsCloud::CellsApi cells_post_cell_characters POST /cells/name/worksheets/sheetName/cells/cellName/characters Set cell characters
AsposeCellsCloud::CellsApi cells_post_clear_contents POST /cells/name/worksheets/sheetName/cells/clearcontents Clear cells contents.
AsposeCellsCloud::CellsApi cells_post_clear_formats POST /cells/name/worksheets/sheetName/cells/clearformats Clear cells contents.
AsposeCellsCloud::CellsApi cells_post_column_style POST /cells/name/worksheets/sheetName/cells/columns/columnIndex/style Set column style
AsposeCellsCloud::CellsApi cells_post_copy_cell_into_cell POST /cells/name/worksheets/sheetName/cells/destCellName/copy Copy cell into cell
AsposeCellsCloud::CellsApi cells_post_copy_worksheet_columns POST /cells/name/worksheets/sheetName/cells/columns/copy Copy worksheet columns.
AsposeCellsCloud::CellsApi cells_post_copy_worksheet_rows POST /cells/name/worksheets/sheetName/cells/rows/copy Copy worksheet rows.
AsposeCellsCloud::CellsApi cells_post_group_worksheet_columns POST /cells/name/worksheets/sheetName/cells/columns/group Group worksheet columns.
AsposeCellsCloud::CellsApi cells_post_group_worksheet_rows POST /cells/name/worksheets/sheetName/cells/rows/group Group worksheet rows.
AsposeCellsCloud::CellsApi cells_post_hide_worksheet_columns POST /cells/name/worksheets/sheetName/cells/columns/hide Hide worksheet columns.
AsposeCellsCloud::CellsApi cells_post_hide_worksheet_rows POST /cells/name/worksheets/sheetName/cells/rows/hide Hide worksheet rows.
AsposeCellsCloud::CellsApi cells_post_row_style POST /cells/name/worksheets/sheetName/cells/rows/rowIndex/style Set row style.
AsposeCellsCloud::CellsApi cells_post_set_cell_html_string POST /cells/name/worksheets/sheetName/cells/cellName/htmlstring Set htmlstring value into cell
AsposeCellsCloud::CellsApi cells_post_set_cell_range_value POST /cells/name/worksheets/sheetName/cells Set cell range value
AsposeCellsCloud::CellsApi cells_post_set_worksheet_column_width POST /cells/name/worksheets/sheetName/cells/columns/columnIndex Set worksheet column width.
AsposeCellsCloud::CellsApi cells_post_ungroup_worksheet_columns POST /cells/name/worksheets/sheetName/cells/columns/ungroup Ungroup worksheet columns.
AsposeCellsCloud::CellsApi cells_post_ungroup_worksheet_rows POST /cells/name/worksheets/sheetName/cells/rows/ungroup Ungroup worksheet rows.
AsposeCellsCloud::CellsApi cells_post_unhide_worksheet_columns POST /cells/name/worksheets/sheetName/cells/columns/unhide Unhide worksheet columns.
AsposeCellsCloud::CellsApi cells_post_unhide_worksheet_rows POST /cells/name/worksheets/sheetName/cells/rows/unhide Unhide worksheet rows.
AsposeCellsCloud::CellsApi cells_post_update_worksheet_cell_style POST /cells/name/worksheets/sheetName/cells/cellName/style Update cell's style.
AsposeCellsCloud::CellsApi cells_post_update_worksheet_range_style POST /cells/name/worksheets/sheetName/cells/style Update cell's range style.
AsposeCellsCloud::CellsApi cells_post_update_worksheet_row POST /cells/name/worksheets/sheetName/cells/rows/rowIndex Update worksheet row.
AsposeCellsCloud::CellsApi cells_post_worksheet_cell_set_value POST /cells/name/worksheets/sheetName/cells/cellName Set cell value.
AsposeCellsCloud::CellsApi cells_post_worksheet_merge POST /cells/name/worksheets/sheetName/cells/merge Merge cells.
AsposeCellsCloud::CellsApi cells_post_worksheet_unmerge POST /cells/name/worksheets/sheetName/cells/unmerge Unmerge cells.
AsposeCellsCloud::CellsApi cells_put_insert_worksheet_columns PUT /cells/name/worksheets/sheetName/cells/columns/columnIndex Insert worksheet columns.
AsposeCellsCloud::CellsApi cells_put_insert_worksheet_row PUT /cells/name/worksheets/sheetName/cells/rows/rowIndex Insert new worksheet row.
AsposeCellsCloud::CellsApi cells_put_insert_worksheet_rows PUT /cells/name/worksheets/sheetName/cells/rows Insert several new worksheet rows.
AsposeCellsCloud::CellsAutoFilterApi cells_auto_filter_delete_worksheet_date_filter DELETE /cells/name/worksheets/sheetName/autoFilter/dateFilter Removes a date filter.
AsposeCellsCloud::CellsAutoFilterApi cells_auto_filter_delete_worksheet_filter DELETE /cells/name/worksheets/sheetName/autoFilter/filter Delete a filter for a filter column.
AsposeCellsCloud::CellsAutoFilterApi cells_auto_filter_get_worksheet_auto_filter GET /cells/name/worksheets/sheetName/autoFilter Get Auto filter Description
AsposeCellsCloud::CellsAutoFilterApi cells_auto_filter_post_worksheet_auto_filter_refresh POST /cells/name/worksheets/sheetName/autoFilter/refresh
AsposeCellsCloud::CellsAutoFilterApi cells_auto_filter_post_worksheet_match_blanks POST /cells/name/worksheets/sheetName/autoFilter/matchBlanks Match all blank cell in the list.
AsposeCellsCloud::CellsAutoFilterApi cells_auto_filter_post_worksheet_match_non_blanks POST /cells/name/worksheets/sheetName/autoFilter/matchNonBlanks Match all not blank cell in the list.
AsposeCellsCloud::CellsAutoFilterApi cells_auto_filter_put_worksheet_color_filter PUT /cells/name/worksheets/sheetName/autoFilter/colorFilter
AsposeCellsCloud::CellsAutoFilterApi cells_auto_filter_put_worksheet_custom_filter PUT /cells/name/worksheets/sheetName/autoFilter/custom Filters a list with a custom criteria.
AsposeCellsCloud::CellsAutoFilterApi cells_auto_filter_put_worksheet_date_filter PUT /cells/name/worksheets/sheetName/autoFilter/dateFilter add date filter in worksheet
AsposeCellsCloud::CellsAutoFilterApi cells_auto_filter_put_worksheet_dynamic_filter PUT /cells/name/worksheets/sheetName/autoFilter/dynamicFilter
AsposeCellsCloud::CellsAutoFilterApi cells_auto_filter_put_worksheet_filter PUT /cells/name/worksheets/sheetName/autoFilter/filter Adds a filter for a filter column.
AsposeCellsCloud::CellsAutoFilterApi cells_auto_filter_put_worksheet_filter_top10 PUT /cells/name/worksheets/sheetName/autoFilter/filterTop10 Filter the top 10 item in the list
AsposeCellsCloud::CellsAutoFilterApi cells_auto_filter_put_worksheet_icon_filter PUT /cells/name/worksheets/sheetName/autoFilter/iconFilter Adds an icon filter.
AsposeCellsCloud::CellsAutoshapesApi cells_autoshapes_get_worksheet_autoshape GET /cells/name/worksheets/sheetName/autoshapes/autoshapeNumber Get autoshape info.
AsposeCellsCloud::CellsAutoshapesApi cells_autoshapes_get_worksheet_autoshapes GET /cells/name/worksheets/sheetName/autoshapes Get worksheet autoshapes info.
AsposeCellsCloud::CellsChartAreaApi cells_chart_area_get_chart_area GET /cells/name/worksheets/sheetName/charts/chartIndex/chartArea Get chart area info.
AsposeCellsCloud::CellsChartAreaApi cells_chart_area_get_chart_area_border GET /cells/name/worksheets/sheetName/charts/chartIndex/chartArea/border Get chart area border info.
AsposeCellsCloud::CellsChartAreaApi cells_chart_area_get_chart_area_fill_format GET /cells/name/worksheets/sheetName/charts/chartIndex/chartArea/fillFormat Get chart area fill format info.
AsposeCellsCloud::CellsChartsApi cells_charts_delete_worksheet_chart_legend DELETE /cells/name/worksheets/sheetName/charts/chartIndex/legend Hide legend in chart
AsposeCellsCloud::CellsChartsApi cells_charts_delete_worksheet_chart_title DELETE /cells/name/worksheets/sheetName/charts/chartIndex/title Hide title in chart
AsposeCellsCloud::CellsChartsApi cells_charts_delete_worksheet_clear_charts DELETE /cells/name/worksheets/sheetName/charts Clear the charts.
AsposeCellsCloud::CellsChartsApi cells_charts_delete_worksheet_delete_chart DELETE /cells/name/worksheets/sheetName/charts/chartIndex Delete worksheet chart by index.
AsposeCellsCloud::CellsChartsApi cells_charts_get_worksheet_chart GET /cells/name/worksheets/sheetName/charts/chartNumber Get chart info.
AsposeCellsCloud::CellsChartsApi cells_charts_get_worksheet_chart_legend GET /cells/name/worksheets/sheetName/charts/chartIndex/legend Get chart legend
AsposeCellsCloud::CellsChartsApi cells_charts_get_worksheet_chart_title GET /cells/name/worksheets/sheetName/charts/chartIndex/title Get chart title
AsposeCellsCloud::CellsChartsApi cells_charts_get_worksheet_charts GET /cells/name/worksheets/sheetName/charts Get worksheet charts info.
AsposeCellsCloud::CellsChartsApi cells_charts_post_worksheet_chart POST /cells/name/worksheets/sheetName/charts/chartIndex Update chart propreties
AsposeCellsCloud::CellsChartsApi cells_charts_post_worksheet_chart_legend POST /cells/name/worksheets/sheetName/charts/chartIndex/legend Update chart legend
AsposeCellsCloud::CellsChartsApi cells_charts_post_worksheet_chart_title POST /cells/name/worksheets/sheetName/charts/chartIndex/title Update chart title
AsposeCellsCloud::CellsChartsApi cells_charts_put_worksheet_add_chart PUT /cells/name/worksheets/sheetName/charts Add new chart to worksheet.
AsposeCellsCloud::CellsChartsApi cells_charts_put_worksheet_chart_legend PUT /cells/name/worksheets/sheetName/charts/chartIndex/legend Show legend in chart
AsposeCellsCloud::CellsChartsApi cells_charts_put_worksheet_chart_title PUT /cells/name/worksheets/sheetName/charts/chartIndex/title Add chart title / Set chart title visible
AsposeCellsCloud::CellsConditionalFormattingsApi cells_conditional_formattings_delete_worksheet_conditional_formatting DELETE /cells/name/worksheets/sheetName/conditionalFormattings/index Remove conditional formatting
AsposeCellsCloud::CellsConditionalFormattingsApi cells_conditional_formattings_delete_worksheet_conditional_formatting_area DELETE /cells/name/worksheets/sheetName/conditionalFormattings/area Remove cell area from conditional formatting.
AsposeCellsCloud::CellsConditionalFormattingsApi cells_conditional_formattings_delete_worksheet_conditional_formattings DELETE /cells/name/worksheets/sheetName/conditionalFormattings Clear all condition formattings
AsposeCellsCloud::CellsConditionalFormattingsApi cells_conditional_formattings_get_worksheet_conditional_formatting GET /cells/name/worksheets/sheetName/conditionalFormattings/index Get conditional formatting
AsposeCellsCloud::CellsConditionalFormattingsApi cells_conditional_formattings_get_worksheet_conditional_formattings GET /cells/name/worksheets/sheetName/conditionalFormattings Get conditional formattings
AsposeCellsCloud::CellsConditionalFormattingsApi cells_conditional_formattings_put_worksheet_conditional_formatting PUT /cells/name/worksheets/sheetName/conditionalFormattings Add a condition formatting.
AsposeCellsCloud::CellsConditionalFormattingsApi cells_conditional_formattings_put_worksheet_format_condition PUT /cells/name/worksheets/sheetName/conditionalFormattings/index Add a format condition.
AsposeCellsCloud::CellsConditionalFormattingsApi cells_conditional_formattings_put_worksheet_format_condition_area PUT /cells/name/worksheets/sheetName/conditionalFormattings/index/area add a cell area for format condition
AsposeCellsCloud::CellsConditionalFormattingsApi cells_conditional_formattings_put_worksheet_format_condition_condition PUT /cells/name/worksheets/sheetName/conditionalFormattings/index/condition Add a condition for format condition.
AsposeCellsCloud::CellsHypelinksApi cells_hypelinks_delete_worksheet_hyperlink DELETE /cells/name/worksheets/sheetName/hyperlinks/hyperlinkIndex Delete worksheet hyperlink by index.
AsposeCellsCloud::CellsHypelinksApi cells_hypelinks_delete_worksheet_hyperlinks DELETE /cells/name/worksheets/sheetName/hyperlinks Delete all hyperlinks in worksheet.
AsposeCellsCloud::CellsHypelinksApi cells_hypelinks_get_worksheet_hyperlink GET /cells/name/worksheets/sheetName/hyperlinks/hyperlinkIndex Get worksheet hyperlink by index.
AsposeCellsCloud::CellsHypelinksApi cells_hypelinks_get_worksheet_hyperlinks GET /cells/name/worksheets/sheetName/hyperlinks Get worksheet hyperlinks.
AsposeCellsCloud::CellsHypelinksApi cells_hypelinks_post_worksheet_hyperlink POST /cells/name/worksheets/sheetName/hyperlinks/hyperlinkIndex Update worksheet hyperlink by index.
AsposeCellsCloud::CellsHypelinksApi cells_hypelinks_put_worksheet_hyperlink PUT /cells/name/worksheets/sheetName/hyperlinks Add worksheet hyperlink.
AsposeCellsCloud::CellsListObjectsApi cells_list_objects_delete_worksheet_list_object DELETE /cells/name/worksheets/sheetName/listobjects/listObjectIndex Delete worksheet list object by index
AsposeCellsCloud::CellsListObjectsApi cells_list_objects_delete_worksheet_list_objects DELETE /cells/name/worksheets/sheetName/listobjects Delete worksheet list objects
AsposeCellsCloud::CellsListObjectsApi cells_list_objects_get_worksheet_list_object GET /cells/name/worksheets/sheetName/listobjects/listobjectindex Get worksheet list object info by index.
AsposeCellsCloud::CellsListObjectsApi cells_list_objects_get_worksheet_list_objects GET /cells/name/worksheets/sheetName/listobjects Get worksheet listobjects info.
AsposeCellsCloud::CellsListObjectsApi cells_list_objects_post_worksheet_list_object POST /cells/name/worksheets/sheetName/listobjects/listObjectIndex Update list object
AsposeCellsCloud::CellsListObjectsApi cells_list_objects_post_worksheet_list_object_convert_to_range POST /cells/name/worksheets/sheetName/listobjects/listObjectIndex/ConvertToRange
AsposeCellsCloud::CellsListObjectsApi cells_list_objects_post_worksheet_list_object_sort_table POST /cells/name/worksheets/sheetName/listobjects/listObjectIndex/sort
AsposeCellsCloud::CellsListObjectsApi cells_list_objects_post_worksheet_list_object_summarize_with_pivot_table POST /cells/name/worksheets/sheetName/listobjects/listObjectIndex/SummarizeWithPivotTable
AsposeCellsCloud::CellsListObjectsApi cells_list_objects_put_worksheet_list_object PUT /cells/name/worksheets/sheetName/listobjects Add a list object into worksheet.
AsposeCellsCloud::CellsOleObjectsApi cells_ole_objects_delete_worksheet_ole_object DELETE /cells/name/worksheets/sheetName/oleobjects/oleObjectIndex Delete OLE object.
AsposeCellsCloud::CellsOleObjectsApi cells_ole_objects_delete_worksheet_ole_objects DELETE /cells/name/worksheets/sheetName/oleobjects Delete all OLE objects.
AsposeCellsCloud::CellsOleObjectsApi cells_ole_objects_get_worksheet_ole_object GET /cells/name/worksheets/sheetName/oleobjects/objectNumber Get OLE object info.
AsposeCellsCloud::CellsOleObjectsApi cells_ole_objects_get_worksheet_ole_objects GET /cells/name/worksheets/sheetName/oleobjects Get worksheet OLE objects info.
AsposeCellsCloud::CellsOleObjectsApi cells_ole_objects_post_update_worksheet_ole_object POST /cells/name/worksheets/sheetName/oleobjects/oleObjectIndex Update OLE object.
AsposeCellsCloud::CellsOleObjectsApi cells_ole_objects_put_worksheet_ole_object PUT /cells/name/worksheets/sheetName/oleobjects Add OLE object
AsposeCellsCloud::CellsPageBreaksApi cells_page_breaks_delete_horizontal_page_break DELETE /cells/name/worksheets/sheetName/horizontalpagebreaks/index
AsposeCellsCloud::CellsPageBreaksApi cells_page_breaks_delete_horizontal_page_breaks DELETE /cells/name/worksheets/sheetName/horizontalpagebreaks
AsposeCellsCloud::CellsPageBreaksApi cells_page_breaks_delete_vertical_page_break DELETE /cells/name/worksheets/sheetName/verticalpagebreaks/index
AsposeCellsCloud::CellsPageBreaksApi cells_page_breaks_delete_vertical_page_breaks DELETE /cells/name/worksheets/sheetName/verticalpagebreaks
AsposeCellsCloud::CellsPageBreaksApi cells_page_breaks_get_horizontal_page_break GET /cells/name/worksheets/sheetName/horizontalpagebreaks/index
AsposeCellsCloud::CellsPageBreaksApi cells_page_breaks_get_horizontal_page_breaks GET /cells/name/worksheets/sheetName/horizontalpagebreaks
AsposeCellsCloud::CellsPageBreaksApi cells_page_breaks_get_vertical_page_break GET /cells/name/worksheets/sheetName/verticalpagebreaks/index
AsposeCellsCloud::CellsPageBreaksApi cells_page_breaks_get_vertical_page_breaks GET /cells/name/worksheets/sheetName/verticalpagebreaks
AsposeCellsCloud::CellsPageBreaksApi cells_page_breaks_put_horizontal_page_break PUT /cells/name/worksheets/sheetName/horizontalpagebreaks
AsposeCellsCloud::CellsPageBreaksApi cells_page_breaks_put_vertical_page_break PUT /cells/name/worksheets/sheetName/verticalpagebreaks
AsposeCellsCloud::CellsPageSetupApi cells_page_setup_delete_header_footer DELETE /cells/name/worksheets/sheetName/pagesetup/clearheaderfooter clear header footer
AsposeCellsCloud::CellsPageSetupApi cells_page_setup_get_footer GET /cells/name/worksheets/sheetName/pagesetup/footer get page footer information
AsposeCellsCloud::CellsPageSetupApi cells_page_setup_get_header GET /cells/name/worksheets/sheetName/pagesetup/header get page header information
AsposeCellsCloud::CellsPageSetupApi cells_page_setup_get_page_setup GET /cells/name/worksheets/sheetName/pagesetup Get Page Setup information.
AsposeCellsCloud::CellsPageSetupApi cells_page_setup_post_footer POST /cells/name/worksheets/sheetName/pagesetup/footer update page footer information
AsposeCellsCloud::CellsPageSetupApi cells_page_setup_post_header POST /cells/name/worksheets/sheetName/pagesetup/header update page header information
AsposeCellsCloud::CellsPageSetupApi cells_page_setup_post_page_setup POST /cells/name/worksheets/sheetName/pagesetup Update Page Setup information.
AsposeCellsCloud::CellsPicturesApi cells_pictures_delete_worksheet_picture DELETE /cells/name/worksheets/sheetName/pictures/pictureIndex Delete a picture object in worksheet
AsposeCellsCloud::CellsPicturesApi cells_pictures_delete_worksheet_pictures DELETE /cells/name/worksheets/sheetName/pictures Delete all pictures in worksheet.
AsposeCellsCloud::CellsPicturesApi cells_pictures_get_worksheet_picture GET /cells/name/worksheets/sheetName/pictures/pictureIndex GRead worksheet picture by number.
AsposeCellsCloud::CellsPicturesApi cells_pictures_get_worksheet_pictures GET /cells/name/worksheets/sheetName/pictures Read worksheet pictures.
AsposeCellsCloud::CellsPicturesApi cells_pictures_post_worksheet_picture POST /cells/name/worksheets/sheetName/pictures/pictureIndex Update worksheet picture by index.
AsposeCellsCloud::CellsPicturesApi cells_pictures_put_worksheet_add_picture PUT /cells/name/worksheets/sheetName/pictures Add a new worksheet picture.
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_delete_pivot_table_field DELETE /cells/name/worksheets/sheetName/pivottables/pivotTableIndex/PivotField Delete pivot field into into pivot table
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_delete_worksheet_pivot_table DELETE /cells/name/worksheets/sheetName/pivottables/pivotTableIndex Delete worksheet pivot table by index
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_delete_worksheet_pivot_table_filter DELETE /cells/name/worksheets/sheetName/pivottables/pivotTableIndex/PivotFilters/fieldIndex delete pivot filter for piovt table
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_delete_worksheet_pivot_table_filters DELETE /cells/name/worksheets/sheetName/pivottables/pivotTableIndex/PivotFilters delete all pivot filters for piovt table
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_delete_worksheet_pivot_tables DELETE /cells/name/worksheets/sheetName/pivottables Delete worksheet pivot tables
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_get_pivot_table_field GET /cells/name/worksheets/sheetName/pivottables/pivotTableIndex/PivotField Get pivot field into into pivot table
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_get_worksheet_pivot_table GET /cells/name/worksheets/sheetName/pivottables/pivottableIndex Get worksheet pivottable info by index.
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_get_worksheet_pivot_table_filter GET /cells/name/worksheets/sheetName/pivottables/pivotTableIndex/PivotFilters/filterIndex
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_get_worksheet_pivot_table_filters GET /cells/name/worksheets/sheetName/pivottables/pivotTableIndex/PivotFilters
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_get_worksheet_pivot_tables GET /cells/name/worksheets/sheetName/pivottables Get worksheet pivottables info.
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_post_pivot_table_cell_style POST /cells/name/worksheets/sheetName/pivottables/pivotTableIndex/Format Update cell style for pivot table
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_post_pivot_table_field_hide_item POST /cells/name/worksheets/sheetName/pivottables/pivotTableIndex/PivotField/Hide
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_post_pivot_table_field_move_to POST /cells/name/worksheets/sheetName/pivottables/pivotTableIndex/PivotField/Move
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_post_pivot_table_style POST /cells/name/worksheets/sheetName/pivottables/pivotTableIndex/FormatAll Update style for pivot table
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_post_worksheet_pivot_table_calculate POST /cells/name/worksheets/sheetName/pivottables/pivotTableIndex/Calculate Calculates pivottable's data to cells.
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_post_worksheet_pivot_table_move POST /cells/name/worksheets/sheetName/pivottables/pivotTableIndex/Move
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_put_pivot_table_field PUT /cells/name/worksheets/sheetName/pivottables/pivotTableIndex/PivotField Add pivot field into into pivot table
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_put_worksheet_pivot_table PUT /cells/name/worksheets/sheetName/pivottables Add a pivot table into worksheet.
AsposeCellsCloud::CellsPivotTablesApi cells_pivot_tables_put_worksheet_pivot_table_filter PUT /cells/name/worksheets/sheetName/pivottables/pivotTableIndex/PivotFilters Add pivot filter for piovt table index
AsposeCellsCloud::CellsPropertiesApi cells_properties_delete_document_properties DELETE /cells/name/documentproperties Delete all custom document properties and clean built-in ones.
AsposeCellsCloud::CellsPropertiesApi cells_properties_delete_document_property DELETE /cells/name/documentproperties/propertyName Delete document property.
AsposeCellsCloud::CellsPropertiesApi cells_properties_get_document_properties GET /cells/name/documentproperties Read document properties.
AsposeCellsCloud::CellsPropertiesApi cells_properties_get_document_property GET /cells/name/documentproperties/propertyName Read document property by name.
AsposeCellsCloud::CellsPropertiesApi cells_properties_put_document_property PUT /cells/name/documentproperties/propertyName Set/create document property.
AsposeCellsCloud::CellsRangesApi cells_ranges_get_worksheet_cells_range_value GET /cells/name/worksheets/sheetName/ranges/value Get cells list in a range by range name or row column indexes
AsposeCellsCloud::CellsRangesApi cells_ranges_post_worksheet_cells_range_column_width POST /cells/name/worksheets/sheetName/ranges/columnWidth Set column width of range
AsposeCellsCloud::CellsRangesApi cells_ranges_post_worksheet_cells_range_merge POST /cells/name/worksheets/sheetName/ranges/merge Combines a range of cells into a single cell.
AsposeCellsCloud::CellsRangesApi cells_ranges_post_worksheet_cells_range_move_to POST /cells/name/worksheets/sheetName/ranges/moveto Move the current range to the dest range.
AsposeCellsCloud::CellsRangesApi cells_ranges_post_worksheet_cells_range_outline_border POST /cells/name/worksheets/sheetName/ranges/outlineBorder Sets outline border around a range of cells.
AsposeCellsCloud::CellsRangesApi cells_ranges_post_worksheet_cells_range_row_height POST /cells/name/worksheets/sheetName/ranges/rowHeight set row height of range
AsposeCellsCloud::CellsRangesApi cells_ranges_post_worksheet_cells_range_style POST /cells/name/worksheets/sheetName/ranges/style Sets the style of the range.
AsposeCellsCloud::CellsRangesApi cells_ranges_post_worksheet_cells_range_unmerge POST /cells/name/worksheets/sheetName/ranges/unmerge Unmerges merged cells of this range.
AsposeCellsCloud::CellsRangesApi cells_ranges_post_worksheet_cells_range_value POST /cells/name/worksheets/sheetName/ranges/value Puts a value into the range, if appropriate the value will be converted to other data type and cell's number format will be reset.
AsposeCellsCloud::CellsRangesApi cells_ranges_post_worksheet_cells_ranges POST /cells/name/worksheets/sheetName/ranges copy range in the worksheet
AsposeCellsCloud::CellsSaveAsApi cells_save_as_post_document_save_as POST /cells/name/SaveAs Convert document and save result to storage.
AsposeCellsCloud::CellsShapesApi cells_shapes_delete_worksheet_shape DELETE /cells/name/worksheets/sheetName/shapes/shapeindex Delete a shape in worksheet
AsposeCellsCloud::CellsShapesApi cells_shapes_delete_worksheet_shapes DELETE /cells/name/worksheets/sheetName/shapes delete all shapes in worksheet
AsposeCellsCloud::CellsShapesApi cells_shapes_get_worksheet_shape GET /cells/name/worksheets/sheetName/shapes/shapeindex Get worksheet shape
AsposeCellsCloud::CellsShapesApi cells_shapes_get_worksheet_shapes GET /cells/name/worksheets/sheetName/shapes Get worksheet shapes
AsposeCellsCloud::CellsShapesApi cells_shapes_post_worksheet_shape POST /cells/name/worksheets/sheetName/shapes/shapeindex Update a shape in worksheet
AsposeCellsCloud::CellsShapesApi cells_shapes_put_worksheet_shape PUT /cells/name/worksheets/sheetName/shapes Add shape in worksheet
AsposeCellsCloud::CellsTaskApi cells_task_post_run_task POST /cells/task/runtask Run tasks
AsposeCellsCloud::CellsWorkbookApi cells_workbook_delete_decrypt_document DELETE /cells/name/encryption Decrypt document.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_delete_document_unprotect_from_changes DELETE /cells/name/writeProtection Unprotect document from changes.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_delete_unprotect_document DELETE /cells/name/protection Unprotect document.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_delete_workbook_name DELETE /cells/name/names/nameName Clean workbook's names.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_delete_workbook_names DELETE /cells/name/names Clean workbook's names.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_get_workbook GET /cells/name Read workbook info or export.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_get_workbook_default_style GET /cells/name/defaultstyle Read workbook default style info.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_get_workbook_name GET /cells/name/names/nameName Read workbook's name.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_get_workbook_name_value GET /cells/name/names/nameName/value Get workbook's name value.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_get_workbook_names GET /cells/name/names Read workbook's names.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_get_workbook_settings GET /cells/name/settings Get Workbook Settings DTO
AsposeCellsCloud::CellsWorkbookApi cells_workbook_get_workbook_text_items GET /cells/name/textItems Read workbook's text items.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_post_autofit_workbook_rows POST /cells/name/autofitrows Autofit workbook rows.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_post_encrypt_document POST /cells/name/encryption Encript document.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_post_import_data POST /cells/name/importdata
AsposeCellsCloud::CellsWorkbookApi cells_workbook_post_protect_document POST /cells/name/protection Protect document.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_post_workbook_calculate_formula POST /cells/name/calculateformula Calculate all formulas in workbook.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_post_workbook_get_smart_marker_result POST /cells/name/smartmarker Smart marker processing result.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_post_workbook_settings POST /cells/name/settings Update Workbook setting
AsposeCellsCloud::CellsWorkbookApi cells_workbook_post_workbook_split POST /cells/name/split Split workbook.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_post_workbooks_merge POST /cells/name/merge Merge workbooks.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_post_workbooks_text_replace POST /cells/name/replaceText Replace text.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_post_workbooks_text_search POST /cells/name/findText Search text.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_put_convert_workbook PUT /cells/convert Convert workbook from request content to some format.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_put_document_protect_from_changes PUT /cells/name/writeProtection Protect document from changes.
AsposeCellsCloud::CellsWorkbookApi cells_workbook_put_workbook_create PUT /cells/name Create new workbook using deferent methods.
AsposeCellsCloud::CellsWorksheetValidationsApi cells_worksheet_validations_delete_worksheet_validation DELETE /cells/name/worksheets/sheetName/validations/validationIndex Delete worksheet validation by index.
AsposeCellsCloud::CellsWorksheetValidationsApi cells_worksheet_validations_get_worksheet_validation GET /cells/name/worksheets/sheetName/validations/validationIndex Get worksheet validation by index.
AsposeCellsCloud::CellsWorksheetValidationsApi cells_worksheet_validations_get_worksheet_validations GET /cells/name/worksheets/sheetName/validations Get worksheet validations.
AsposeCellsCloud::CellsWorksheetValidationsApi cells_worksheet_validations_post_worksheet_validation POST /cells/name/worksheets/sheetName/validations/validationIndex Update worksheet validation by index.
AsposeCellsCloud::CellsWorksheetValidationsApi cells_worksheet_validations_put_worksheet_validation PUT /cells/name/worksheets/sheetName/validations Add worksheet validation at index.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_delete_unprotect_worksheet DELETE /cells/name/worksheets/sheetName/protection Unprotect worksheet.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_delete_worksheet DELETE /cells/name/worksheets/sheetName Delete worksheet.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_delete_worksheet_background DELETE /cells/name/worksheets/sheetName/background Set worksheet background image.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_delete_worksheet_comment DELETE /cells/name/worksheets/sheetName/comments/cellName Delete worksheet's cell comment.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_delete_worksheet_comments DELETE /cells/name/worksheets/sheetName/comments Delete all comments for worksheet.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_delete_worksheet_freeze_panes DELETE /cells/name/worksheets/sheetName/freezepanes Unfreeze panes
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_get_named_ranges GET /cells/name/worksheets/ranges Read worksheets ranges info.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_get_worksheet GET /cells/name/worksheets/sheetName Read worksheet info or export.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_get_worksheet_calculate_formula GET /cells/name/worksheets/sheetName/formulaResult Calculate formula value.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_get_worksheet_comment GET /cells/name/worksheets/sheetName/comments/cellName Get worksheet comment by cell name.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_get_worksheet_comments GET /cells/name/worksheets/sheetName/comments Get worksheet comments.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_get_worksheet_merged_cell GET /cells/name/worksheets/sheetName/mergedCells/mergedCellIndex Get worksheet merged cell by its index.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_get_worksheet_merged_cells GET /cells/name/worksheets/sheetName/mergedCells Get worksheet merged cells.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_get_worksheet_text_items GET /cells/name/worksheets/sheetName/textItems Get worksheet text items.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_get_worksheets GET /cells/name/worksheets Read worksheets info.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_post_autofit_worksheet_columns POST /cells/name/worksheets/sheetName/autofitcolumns
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_post_autofit_worksheet_row POST /cells/name/worksheets/sheetName/autofitrow
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_post_autofit_worksheet_rows POST /cells/name/worksheets/sheetName/autofitrows Autofit worksheet rows.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_post_copy_worksheet POST /cells/name/worksheets/sheetName/copy
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_post_move_worksheet POST /cells/name/worksheets/sheetName/position Move worksheet.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_post_rename_worksheet POST /cells/name/worksheets/sheetName/rename Rename worksheet
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_post_update_worksheet_property POST /cells/name/worksheets/sheetName Update worksheet property
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_post_update_worksheet_zoom POST /cells/name/worksheets/sheetName/zoom
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_post_worksheet_comment POST /cells/name/worksheets/sheetName/comments/cellName Update worksheet's cell comment.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_post_worksheet_range_sort POST /cells/name/worksheets/sheetName/sort Sort worksheet range.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_post_worksheet_text_search POST /cells/name/worksheets/sheetName/findText Search text.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_post_worsheet_text_replace POST /cells/name/worksheets/sheetName/replaceText Replace text.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_put_add_new_worksheet PUT /cells/name/worksheets/sheetName Add new worksheet.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_put_change_visibility_worksheet PUT /cells/name/worksheets/sheetName/visible Change worksheet visibility.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_put_protect_worksheet PUT /cells/name/worksheets/sheetName/protection Protect worksheet.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_put_worksheet_background PUT /cells/name/worksheets/sheetName/background Set worksheet background image.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_put_worksheet_comment PUT /cells/name/worksheets/sheetName/comments/cellName Add worksheet's cell comment.
AsposeCellsCloud::CellsWorksheetsApi cells_worksheets_put_worksheet_freeze_panes PUT /cells/name/worksheets/sheetName/freezepanes Set freeze panes
AsposeCellsCloud::OAuthApi o_auth_post POST /oauth2/token Get Access token

Documentation for Models

Documentation for Authorization

appsid

  • Type: API key
  • API key parameter name: appsid
  • Location: URL query string

oauth

  • Type: OAuth
  • Flow: implicit
  • Authorization URL:
  • Scopes:
    • write:pets: modify pets in your account

signature

  • Type: API key
  • API key parameter name: signature
  • Location: URL query string