Skip to content

.NET SDK to communicate with the Aspose.Cells REST API. Create, Edit & Convert Excel files in the Cloud.

License

Notifications You must be signed in to change notification settings

aspose-cells-cloud/aspose-cells-cloud-dotnet

Repository files navigation

Aspose.Cells.Cloud.SDK - the C# library for the Web API Swagger specification

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

This C# SDK is automatically generated by the Swagger Codegen project:

  • API version: 1.0
  • SDK version: 19.2.1
  • Build package: io.swagger.codegen.languages.CSharpClientCodegen

Frameworks supported

  • .NET 4.0 or later
  • Windows Phone 7.1 (Mango)

Dependencies

The DLLs included in the package may not be the latest version. We recommend using [NuGet] (https://docs.nuget.org/consume/installing-nuget) to obtain the latest version of the packages:

Install-Package RestSharp
Install-Package Newtonsoft.Json

NOTE: RestSharp versions greater than 105.1.0 have a bug which causes file uploads to fail. See RestSharp#742

Installation

Run the following command to generate the DLL

  • [Mac/Linux] /bin/sh build.sh
  • [Windows] build.bat

Then include the DLL (under the bin folder) in the C# project, and use the namespaces:

using Aspose.Cells.Cloud.SDK.Api;
using Aspose.Cells.Cloud.SDK.Client;
using Aspose.Cells.Cloud.SDK.Model;

Packaging

A .nuspec is included with the project. You can follow the Nuget quickstart to create and publish packages.

This .nuspec uses placeholders from the .csproj, so build the .csproj directly:

nuget pack -Build -OutputDirectory out Aspose.Cells.Cloud.SDK.csproj

Then, publish to a local feed or other host and consume the new package via Nuget as usual.

Getting Started

using System;
using System.Diagnostics;
using Aspose.Cells.Cloud.SDK.Api;
using Aspose.Cells.Cloud.SDK.Client;
using Aspose.Cells.Cloud.SDK.Model;

namespace Example
{
    public class Example
    {
        public void main()
        {

            var apiInstance = new CellsApi();
            var name = name_example;  // string | The workbook name.
            var sheetName = sheetName_example;  // string | The worksheet name.
            var columnIndex = 56;  // int? | The column index.
            var columns = 56;  // int? | The columns.
            var updateReference = true;  // bool? | The update reference.
            var folder = folder_example;  // string | The workbook folder. (optional) 
            var storage = storage_example;  // string | storage name. (optional) 

            try
            {
                // Delete worksheet columns.
                ColumnsResponse result = apiInstance.CellsDeleteWorksheetColumns(name, sheetName, columnIndex, columns, updateReference, folder, storage);
                Debug.WriteLine(result);
            }
            catch (Exception e)
            {
                Debug.Print("Exception when calling CellsApi.CellsDeleteWorksheetColumns: " + e.Message );
            }

        }
    }
}

Documentation for API Endpoints

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

Class Method HTTP request Description
CellsApi CellsDeleteWorksheetColumns DELETE /cells/{name}/worksheets/{sheetName}/cells/columns/{columnIndex} Delete worksheet columns.
CellsApi CellsDeleteWorksheetRow DELETE /cells/{name}/worksheets/{sheetName}/cells/rows/{rowIndex} Delete worksheet row.
CellsApi CellsDeleteWorksheetRows DELETE /cells/{name}/worksheets/{sheetName}/cells/rows Delete several worksheet rows.
CellsApi CellsGetCellHtmlString GET /cells/{name}/worksheets/{sheetName}/cells/{cellName}/htmlstring Read cell data by cell's name.
CellsApi CellsGetWorksheetCell GET /cells/{name}/worksheets/{sheetName}/cells/{cellOrMethodName} Read cell data by cell's name.
CellsApi CellsGetWorksheetCellStyle GET /cells/{name}/worksheets/{sheetName}/cells/{cellName}/style Read cell's style info.
CellsApi CellsGetWorksheetCells GET /cells/{name}/worksheets/{sheetName}/cells Get cells info.
CellsApi CellsGetWorksheetColumn GET /cells/{name}/worksheets/{sheetName}/cells/columns/{columnIndex} Read worksheet column data by column's index.
CellsApi CellsGetWorksheetColumns GET /cells/{name}/worksheets/{sheetName}/cells/columns Read worksheet columns info.
CellsApi CellsGetWorksheetRow GET /cells/{name}/worksheets/{sheetName}/cells/rows/{rowIndex} Read worksheet row data by row's index.
CellsApi CellsGetWorksheetRows GET /cells/{name}/worksheets/{sheetName}/cells/rows Read worksheet rows info.
CellsApi CellsPostCellCalculate POST /cells/{name}/worksheets/{sheetName}/cells/{cellName}/calculate Cell calculate formula
CellsApi CellsPostCellCharacters POST /cells/{name}/worksheets/{sheetName}/cells/{cellName}/characters Set cell characters
CellsApi CellsPostClearContents POST /cells/{name}/worksheets/{sheetName}/cells/clearcontents Clear cells contents.
CellsApi CellsPostClearFormats POST /cells/{name}/worksheets/{sheetName}/cells/clearformats Clear cells contents.
CellsApi CellsPostColumnStyle POST /cells/{name}/worksheets/{sheetName}/cells/columns/{columnIndex}/style Set column style
CellsApi CellsPostCopyCellIntoCell POST /cells/{name}/worksheets/{sheetName}/cells/{destCellName}/copy Copy cell into cell
CellsApi CellsPostCopyWorksheetColumns POST /cells/{name}/worksheets/{sheetName}/cells/columns/copy Copy worksheet columns.
CellsApi CellsPostCopyWorksheetRows POST /cells/{name}/worksheets/{sheetName}/cells/rows/copy Copy worksheet rows.
CellsApi CellsPostGroupWorksheetColumns POST /cells/{name}/worksheets/{sheetName}/cells/columns/group Group worksheet columns.
CellsApi CellsPostGroupWorksheetRows POST /cells/{name}/worksheets/{sheetName}/cells/rows/group Group worksheet rows.
CellsApi CellsPostHideWorksheetColumns POST /cells/{name}/worksheets/{sheetName}/cells/columns/hide Hide worksheet columns.
CellsApi CellsPostHideWorksheetRows POST /cells/{name}/worksheets/{sheetName}/cells/rows/hide Hide worksheet rows.
CellsApi CellsPostRowStyle POST /cells/{name}/worksheets/{sheetName}/cells/rows/{rowIndex}/style Set row style.
CellsApi CellsPostSetCellHtmlString POST /cells/{name}/worksheets/{sheetName}/cells/{cellName}/htmlstring Set htmlstring value into cell
CellsApi CellsPostSetCellRangeValue POST /cells/{name}/worksheets/{sheetName}/cells Set cell range value
CellsApi CellsPostSetWorksheetColumnWidth POST /cells/{name}/worksheets/{sheetName}/cells/columns/{columnIndex} Set worksheet column width.
CellsApi CellsPostUngroupWorksheetColumns POST /cells/{name}/worksheets/{sheetName}/cells/columns/ungroup Ungroup worksheet columns.
CellsApi CellsPostUngroupWorksheetRows POST /cells/{name}/worksheets/{sheetName}/cells/rows/ungroup Ungroup worksheet rows.
CellsApi CellsPostUnhideWorksheetColumns POST /cells/{name}/worksheets/{sheetName}/cells/columns/unhide Unhide worksheet columns.
CellsApi CellsPostUnhideWorksheetRows POST /cells/{name}/worksheets/{sheetName}/cells/rows/unhide Unhide worksheet rows.
CellsApi CellsPostUpdateWorksheetCellStyle POST /cells/{name}/worksheets/{sheetName}/cells/{cellName}/style Update cell's style.
CellsApi CellsPostUpdateWorksheetRangeStyle POST /cells/{name}/worksheets/{sheetName}/cells/style Update cell's range style.
CellsApi CellsPostUpdateWorksheetRow POST /cells/{name}/worksheets/{sheetName}/cells/rows/{rowIndex} Update worksheet row.
CellsApi CellsPostWorksheetCellSetValue POST /cells/{name}/worksheets/{sheetName}/cells/{cellName} Set cell value.
CellsApi CellsPostWorksheetMerge POST /cells/{name}/worksheets/{sheetName}/cells/merge Merge cells.
CellsApi CellsPostWorksheetUnmerge POST /cells/{name}/worksheets/{sheetName}/cells/unmerge Unmerge cells.
CellsApi CellsPutInsertWorksheetColumns PUT /cells/{name}/worksheets/{sheetName}/cells/columns/{columnIndex} Insert worksheet columns.
CellsApi CellsPutInsertWorksheetRow PUT /cells/{name}/worksheets/{sheetName}/cells/rows/{rowIndex} Insert new worksheet row.
CellsApi CellsPutInsertWorksheetRows PUT /cells/{name}/worksheets/{sheetName}/cells/rows Insert several new worksheet rows.
CellsAutoFilterApi CellsAutoFilterDeleteWorksheetDateFilter DELETE /cells/{name}/worksheets/{sheetName}/autoFilter/dateFilter Removes a date filter.
CellsAutoFilterApi CellsAutoFilterDeleteWorksheetFilter DELETE /cells/{name}/worksheets/{sheetName}/autoFilter/filter Delete a filter for a filter column.
CellsAutoFilterApi CellsAutoFilterGetWorksheetAutoFilter GET /cells/{name}/worksheets/{sheetName}/autoFilter Get Auto filter Description
CellsAutoFilterApi CellsAutoFilterPostWorksheetAutoFilterRefresh POST /cells/{name}/worksheets/{sheetName}/autoFilter/refresh
CellsAutoFilterApi CellsAutoFilterPostWorksheetMatchBlanks POST /cells/{name}/worksheets/{sheetName}/autoFilter/matchBlanks Match all blank cell in the list.
CellsAutoFilterApi CellsAutoFilterPostWorksheetMatchNonBlanks POST /cells/{name}/worksheets/{sheetName}/autoFilter/matchNonBlanks Match all not blank cell in the list.
CellsAutoFilterApi CellsAutoFilterPutWorksheetColorFilter PUT /cells/{name}/worksheets/{sheetName}/autoFilter/colorFilter
CellsAutoFilterApi CellsAutoFilterPutWorksheetCustomFilter PUT /cells/{name}/worksheets/{sheetName}/autoFilter/custom Filters a list with a custom criteria.
CellsAutoFilterApi CellsAutoFilterPutWorksheetDateFilter PUT /cells/{name}/worksheets/{sheetName}/autoFilter/dateFilter add date filter in worksheet
CellsAutoFilterApi CellsAutoFilterPutWorksheetDynamicFilter PUT /cells/{name}/worksheets/{sheetName}/autoFilter/dynamicFilter
CellsAutoFilterApi CellsAutoFilterPutWorksheetFilter PUT /cells/{name}/worksheets/{sheetName}/autoFilter/filter Adds a filter for a filter column.
CellsAutoFilterApi CellsAutoFilterPutWorksheetFilterTop10 PUT /cells/{name}/worksheets/{sheetName}/autoFilter/filterTop10 Filter the top 10 item in the list
CellsAutoFilterApi CellsAutoFilterPutWorksheetIconFilter PUT /cells/{name}/worksheets/{sheetName}/autoFilter/iconFilter Adds an icon filter.
CellsAutoshapesApi CellsAutoshapesGetWorksheetAutoshape GET /cells/{name}/worksheets/{sheetName}/autoshapes/{autoshapeNumber} Get autoshape info.
CellsAutoshapesApi CellsAutoshapesGetWorksheetAutoshapes GET /cells/{name}/worksheets/{sheetName}/autoshapes Get worksheet autoshapes info.
CellsChartAreaApi CellsChartAreaGetChartArea GET /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/chartArea Get chart area info.
CellsChartAreaApi CellsChartAreaGetChartAreaBorder GET /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/chartArea/border Get chart area border info.
CellsChartAreaApi CellsChartAreaGetChartAreaFillFormat GET /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/chartArea/fillFormat Get chart area fill format info.
CellsChartsApi CellsChartsDeleteWorksheetChartLegend DELETE /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/legend Hide legend in chart
CellsChartsApi CellsChartsDeleteWorksheetChartTitle DELETE /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/title Hide title in chart
CellsChartsApi CellsChartsDeleteWorksheetClearCharts DELETE /cells/{name}/worksheets/{sheetName}/charts Clear the charts.
CellsChartsApi CellsChartsDeleteWorksheetDeleteChart DELETE /cells/{name}/worksheets/{sheetName}/charts/{chartIndex} Delete worksheet chart by index.
CellsChartsApi CellsChartsGetWorksheetChart GET /cells/{name}/worksheets/{sheetName}/charts/{chartNumber} Get chart info.
CellsChartsApi CellsChartsGetWorksheetChartLegend GET /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/legend Get chart legend
CellsChartsApi CellsChartsGetWorksheetChartTitle GET /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/title Get chart title
CellsChartsApi CellsChartsGetWorksheetCharts GET /cells/{name}/worksheets/{sheetName}/charts Get worksheet charts info.
CellsChartsApi CellsChartsPostWorksheetChart POST /cells/{name}/worksheets/{sheetName}/charts/{chartIndex} Update chart propreties
CellsChartsApi CellsChartsPostWorksheetChartLegend POST /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/legend Update chart legend
CellsChartsApi CellsChartsPostWorksheetChartTitle POST /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/title Update chart title
CellsChartsApi CellsChartsPutWorksheetAddChart PUT /cells/{name}/worksheets/{sheetName}/charts Add new chart to worksheet.
CellsChartsApi CellsChartsPutWorksheetChartLegend PUT /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/legend Show legend in chart
CellsChartsApi CellsChartsPutWorksheetChartTitle PUT /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/title Add chart title / Set chart title visible
CellsConditionalFormattingsApi CellsConditionalFormattingsDeleteWorksheetConditionalFormatting DELETE /cells/{name}/worksheets/{sheetName}/conditionalFormattings/{index} Remove conditional formatting
CellsConditionalFormattingsApi CellsConditionalFormattingsDeleteWorksheetConditionalFormattingArea DELETE /cells/{name}/worksheets/{sheetName}/conditionalFormattings/area Remove cell area from conditional formatting.
CellsConditionalFormattingsApi CellsConditionalFormattingsDeleteWorksheetConditionalFormattings DELETE /cells/{name}/worksheets/{sheetName}/conditionalFormattings Clear all condition formattings
CellsConditionalFormattingsApi CellsConditionalFormattingsGetWorksheetConditionalFormatting GET /cells/{name}/worksheets/{sheetName}/conditionalFormattings/{index} Get conditional formatting
CellsConditionalFormattingsApi CellsConditionalFormattingsGetWorksheetConditionalFormattings GET /cells/{name}/worksheets/{sheetName}/conditionalFormattings Get conditional formattings
CellsConditionalFormattingsApi CellsConditionalFormattingsPutWorksheetConditionalFormatting PUT /cells/{name}/worksheets/{sheetName}/conditionalFormattings Add a condition formatting.
CellsConditionalFormattingsApi CellsConditionalFormattingsPutWorksheetFormatCondition PUT /cells/{name}/worksheets/{sheetName}/conditionalFormattings/{index} Add a format condition.
CellsConditionalFormattingsApi CellsConditionalFormattingsPutWorksheetFormatConditionArea PUT /cells/{name}/worksheets/{sheetName}/conditionalFormattings/{index}/area add a cell area for format condition
CellsConditionalFormattingsApi CellsConditionalFormattingsPutWorksheetFormatConditionCondition PUT /cells/{name}/worksheets/{sheetName}/conditionalFormattings/{index}/condition Add a condition for format condition.
CellsHypelinksApi CellsHypelinksDeleteWorksheetHyperlink DELETE /cells/{name}/worksheets/{sheetName}/hyperlinks/{hyperlinkIndex} Delete worksheet hyperlink by index.
CellsHypelinksApi CellsHypelinksDeleteWorksheetHyperlinks DELETE /cells/{name}/worksheets/{sheetName}/hyperlinks Delete all hyperlinks in worksheet.
CellsHypelinksApi CellsHypelinksGetWorksheetHyperlink GET /cells/{name}/worksheets/{sheetName}/hyperlinks/{hyperlinkIndex} Get worksheet hyperlink by index.
CellsHypelinksApi CellsHypelinksGetWorksheetHyperlinks GET /cells/{name}/worksheets/{sheetName}/hyperlinks Get worksheet hyperlinks.
CellsHypelinksApi CellsHypelinksPostWorksheetHyperlink POST /cells/{name}/worksheets/{sheetName}/hyperlinks/{hyperlinkIndex} Update worksheet hyperlink by index.
CellsHypelinksApi CellsHypelinksPutWorksheetHyperlink PUT /cells/{name}/worksheets/{sheetName}/hyperlinks Add worksheet hyperlink.
CellsListObjectsApi CellsListObjectsDeleteWorksheetListObject DELETE /cells/{name}/worksheets/{sheetName}/listobjects/{listObjectIndex} Delete worksheet list object by index
CellsListObjectsApi CellsListObjectsDeleteWorksheetListObjects DELETE /cells/{name}/worksheets/{sheetName}/listobjects Delete worksheet list objects
CellsListObjectsApi CellsListObjectsGetWorksheetListObject GET /cells/{name}/worksheets/{sheetName}/listobjects/{listobjectindex} Get worksheet list object info by index.
CellsListObjectsApi CellsListObjectsGetWorksheetListObjects GET /cells/{name}/worksheets/{sheetName}/listobjects Get worksheet listobjects info.
CellsListObjectsApi CellsListObjectsPostWorksheetListObject POST /cells/{name}/worksheets/{sheetName}/listobjects/{listObjectIndex} Update list object
CellsListObjectsApi CellsListObjectsPostWorksheetListObjectConvertToRange POST /cells/{name}/worksheets/{sheetName}/listobjects/{listObjectIndex}/ConvertToRange
CellsListObjectsApi CellsListObjectsPostWorksheetListObjectSortTable POST /cells/{name}/worksheets/{sheetName}/listobjects/{listObjectIndex}/sort
CellsListObjectsApi CellsListObjectsPostWorksheetListObjectSummarizeWithPivotTable POST /cells/{name}/worksheets/{sheetName}/listobjects/{listObjectIndex}/SummarizeWithPivotTable
CellsListObjectsApi CellsListObjectsPutWorksheetListObject PUT /cells/{name}/worksheets/{sheetName}/listobjects Add a list object into worksheet.
CellsOleObjectsApi CellsOleObjectsDeleteWorksheetOleObject DELETE /cells/{name}/worksheets/{sheetName}/oleobjects/{oleObjectIndex} Delete OLE object.
CellsOleObjectsApi CellsOleObjectsDeleteWorksheetOleObjects DELETE /cells/{name}/worksheets/{sheetName}/oleobjects Delete all OLE objects.
CellsOleObjectsApi CellsOleObjectsGetWorksheetOleObject GET /cells/{name}/worksheets/{sheetName}/oleobjects/{objectNumber} Get OLE object info.
CellsOleObjectsApi CellsOleObjectsGetWorksheetOleObjects GET /cells/{name}/worksheets/{sheetName}/oleobjects Get worksheet OLE objects info.
CellsOleObjectsApi CellsOleObjectsPostUpdateWorksheetOleObject POST /cells/{name}/worksheets/{sheetName}/oleobjects/{oleObjectIndex} Update OLE object.
CellsOleObjectsApi CellsOleObjectsPutWorksheetOleObject PUT /cells/{name}/worksheets/{sheetName}/oleobjects Add OLE object
CellsPageBreaksApi CellsPageBreaksDeleteHorizontalPageBreak DELETE /cells/{name}/worksheets/{sheetName}/horizontalpagebreaks/{index}
CellsPageBreaksApi CellsPageBreaksDeleteHorizontalPageBreaks DELETE /cells/{name}/worksheets/{sheetName}/horizontalpagebreaks
CellsPageBreaksApi CellsPageBreaksDeleteVerticalPageBreak DELETE /cells/{name}/worksheets/{sheetName}/verticalpagebreaks/{index}
CellsPageBreaksApi CellsPageBreaksDeleteVerticalPageBreaks DELETE /cells/{name}/worksheets/{sheetName}/verticalpagebreaks
CellsPageBreaksApi CellsPageBreaksGetHorizontalPageBreak GET /cells/{name}/worksheets/{sheetName}/horizontalpagebreaks/{index}
CellsPageBreaksApi CellsPageBreaksGetHorizontalPageBreaks GET /cells/{name}/worksheets/{sheetName}/horizontalpagebreaks
CellsPageBreaksApi CellsPageBreaksGetVerticalPageBreak GET /cells/{name}/worksheets/{sheetName}/verticalpagebreaks/{index}
CellsPageBreaksApi CellsPageBreaksGetVerticalPageBreaks GET /cells/{name}/worksheets/{sheetName}/verticalpagebreaks
CellsPageBreaksApi CellsPageBreaksPutHorizontalPageBreak PUT /cells/{name}/worksheets/{sheetName}/horizontalpagebreaks
CellsPageBreaksApi CellsPageBreaksPutVerticalPageBreak PUT /cells/{name}/worksheets/{sheetName}/verticalpagebreaks
CellsPageSetupApi CellsPageSetupDeleteHeaderFooter DELETE /cells/{name}/worksheets/{sheetName}/pagesetup/clearheaderfooter clear header footer
CellsPageSetupApi CellsPageSetupGetFooter GET /cells/{name}/worksheets/{sheetName}/pagesetup/footer get page footer information
CellsPageSetupApi CellsPageSetupGetHeader GET /cells/{name}/worksheets/{sheetName}/pagesetup/header get page header information
CellsPageSetupApi CellsPageSetupGetPageSetup GET /cells/{name}/worksheets/{sheetName}/pagesetup Get Page Setup information.
CellsPageSetupApi CellsPageSetupPostFooter POST /cells/{name}/worksheets/{sheetName}/pagesetup/footer update page footer information
CellsPageSetupApi CellsPageSetupPostHeader POST /cells/{name}/worksheets/{sheetName}/pagesetup/header update page header information
CellsPageSetupApi CellsPageSetupPostPageSetup POST /cells/{name}/worksheets/{sheetName}/pagesetup Update Page Setup information.
CellsPicturesApi CellsPicturesDeleteWorksheetPicture DELETE /cells/{name}/worksheets/{sheetName}/pictures/{pictureIndex} Delete a picture object in worksheet
CellsPicturesApi CellsPicturesDeleteWorksheetPictures DELETE /cells/{name}/worksheets/{sheetName}/pictures Delete all pictures in worksheet.
CellsPicturesApi CellsPicturesGetWorksheetPicture GET /cells/{name}/worksheets/{sheetName}/pictures/{pictureIndex} GRead worksheet picture by number.
CellsPicturesApi CellsPicturesGetWorksheetPictures GET /cells/{name}/worksheets/{sheetName}/pictures Read worksheet pictures.
CellsPicturesApi CellsPicturesPostWorksheetPicture POST /cells/{name}/worksheets/{sheetName}/pictures/{pictureIndex} Update worksheet picture by index.
CellsPicturesApi CellsPicturesPutWorksheetAddPicture PUT /cells/{name}/worksheets/{sheetName}/pictures Add a new worksheet picture.
CellsPivotTablesApi CellsPivotTablesDeletePivotTableField DELETE /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotField Delete pivot field into into pivot table
CellsPivotTablesApi CellsPivotTablesDeleteWorksheetPivotTable DELETE /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex} Delete worksheet pivot table by index
CellsPivotTablesApi CellsPivotTablesDeleteWorksheetPivotTableFilter DELETE /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotFilters/{fieldIndex} delete pivot filter for piovt table
CellsPivotTablesApi CellsPivotTablesDeleteWorksheetPivotTableFilters DELETE /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotFilters delete all pivot filters for piovt table
CellsPivotTablesApi CellsPivotTablesDeleteWorksheetPivotTables DELETE /cells/{name}/worksheets/{sheetName}/pivottables Delete worksheet pivot tables
CellsPivotTablesApi CellsPivotTablesGetPivotTableField GET /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotField Get pivot field into into pivot table
CellsPivotTablesApi CellsPivotTablesGetWorksheetPivotTable GET /cells/{name}/worksheets/{sheetName}/pivottables/{pivottableIndex} Get worksheet pivottable info by index.
CellsPivotTablesApi CellsPivotTablesGetWorksheetPivotTableFilter GET /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotFilters/{filterIndex}
CellsPivotTablesApi CellsPivotTablesGetWorksheetPivotTableFilters GET /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotFilters
CellsPivotTablesApi CellsPivotTablesGetWorksheetPivotTables GET /cells/{name}/worksheets/{sheetName}/pivottables Get worksheet pivottables info.
CellsPivotTablesApi CellsPivotTablesPostPivotTableCellStyle POST /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/Format Update cell style for pivot table
CellsPivotTablesApi CellsPivotTablesPostPivotTableFieldHideItem POST /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotField/Hide
CellsPivotTablesApi CellsPivotTablesPostPivotTableFieldMoveTo POST /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotField/Move
CellsPivotTablesApi CellsPivotTablesPostPivotTableStyle POST /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/FormatAll Update style for pivot table
CellsPivotTablesApi CellsPivotTablesPostWorksheetPivotTableCalculate POST /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/Calculate Calculates pivottable's data to cells.
CellsPivotTablesApi CellsPivotTablesPostWorksheetPivotTableMove POST /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/Move
CellsPivotTablesApi CellsPivotTablesPutPivotTableField PUT /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotField Add pivot field into into pivot table
CellsPivotTablesApi CellsPivotTablesPutWorksheetPivotTable PUT /cells/{name}/worksheets/{sheetName}/pivottables Add a pivot table into worksheet.
CellsPivotTablesApi CellsPivotTablesPutWorksheetPivotTableFilter PUT /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotFilters Add pivot filter for piovt table index
CellsPropertiesApi CellsPropertiesDeleteDocumentProperties DELETE /cells/{name}/documentproperties Delete all custom document properties and clean built-in ones.
CellsPropertiesApi CellsPropertiesDeleteDocumentProperty DELETE /cells/{name}/documentproperties/{propertyName} Delete document property.
CellsPropertiesApi CellsPropertiesGetDocumentProperties GET /cells/{name}/documentproperties Read document properties.
CellsPropertiesApi CellsPropertiesGetDocumentProperty GET /cells/{name}/documentproperties/{propertyName} Read document property by name.
CellsPropertiesApi CellsPropertiesPutDocumentProperty PUT /cells/{name}/documentproperties/{propertyName} Set/create document property.
CellsRangesApi CellsRangesGetWorksheetCellsRangeValue GET /cells/{name}/worksheets/{sheetName}/ranges/value Get cells list in a range by range name or row column indexes
CellsRangesApi CellsRangesPostWorksheetCellsRangeColumnWidth POST /cells/{name}/worksheets/{sheetName}/ranges/columnWidth Set column width of range
CellsRangesApi CellsRangesPostWorksheetCellsRangeMerge POST /cells/{name}/worksheets/{sheetName}/ranges/merge Combines a range of cells into a single cell.
CellsRangesApi CellsRangesPostWorksheetCellsRangeMoveTo POST /cells/{name}/worksheets/{sheetName}/ranges/moveto Move the current range to the dest range.
CellsRangesApi CellsRangesPostWorksheetCellsRangeOutlineBorder POST /cells/{name}/worksheets/{sheetName}/ranges/outlineBorder Sets outline border around a range of cells.
CellsRangesApi CellsRangesPostWorksheetCellsRangeRowHeight POST /cells/{name}/worksheets/{sheetName}/ranges/rowHeight set row height of range
CellsRangesApi CellsRangesPostWorksheetCellsRangeStyle POST /cells/{name}/worksheets/{sheetName}/ranges/style Sets the style of the range.
CellsRangesApi CellsRangesPostWorksheetCellsRangeUnmerge POST /cells/{name}/worksheets/{sheetName}/ranges/unmerge Unmerges merged cells of this range.
CellsRangesApi CellsRangesPostWorksheetCellsRangeValue 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.
CellsRangesApi CellsRangesPostWorksheetCellsRanges POST /cells/{name}/worksheets/{sheetName}/ranges copy range in the worksheet
CellsSaveAsApi CellsSaveAsPostDocumentSaveAs POST /cells/{name}/SaveAs Convert document and save result to storage.
CellsShapesApi CellsShapesDeleteWorksheetShape DELETE /cells/{name}/worksheets/{sheetName}/shapes/{shapeindex} Delete a shape in worksheet
CellsShapesApi CellsShapesDeleteWorksheetShapes DELETE /cells/{name}/worksheets/{sheetName}/shapes delete all shapes in worksheet
CellsShapesApi CellsShapesGetWorksheetShape GET /cells/{name}/worksheets/{sheetName}/shapes/{shapeindex} Get worksheet shape
CellsShapesApi CellsShapesGetWorksheetShapes GET /cells/{name}/worksheets/{sheetName}/shapes Get worksheet shapes
CellsShapesApi CellsShapesPostWorksheetShape POST /cells/{name}/worksheets/{sheetName}/shapes/{shapeindex} Update a shape in worksheet
CellsShapesApi CellsShapesPutWorksheetShape PUT /cells/{name}/worksheets/{sheetName}/shapes Add shape in worksheet
CellsTaskApi CellsTaskPostRunTask POST /cells/task/runtask Run tasks
CellsWorkbookApi CellsWorkbookDeleteDecryptDocument DELETE /cells/{name}/encryption Decrypt document.
CellsWorkbookApi CellsWorkbookDeleteDocumentUnprotectFromChanges DELETE /cells/{name}/writeProtection Unprotect document from changes.
CellsWorkbookApi CellsWorkbookDeleteUnprotectDocument DELETE /cells/{name}/protection Unprotect document.
CellsWorkbookApi CellsWorkbookDeleteWorkbookName DELETE /cells/{name}/names/{nameName} Clean workbook's names.
CellsWorkbookApi CellsWorkbookDeleteWorkbookNames DELETE /cells/{name}/names Clean workbook's names.
CellsWorkbookApi CellsWorkbookGetWorkbook GET /cells/{name} Read workbook info or export.
CellsWorkbookApi CellsWorkbookGetWorkbookDefaultStyle GET /cells/{name}/defaultstyle Read workbook default style info.
CellsWorkbookApi CellsWorkbookGetWorkbookName GET /cells/{name}/names/{nameName} Read workbook's name.
CellsWorkbookApi CellsWorkbookGetWorkbookNameValue GET /cells/{name}/names/{nameName}/value Get workbook's name value.
CellsWorkbookApi CellsWorkbookGetWorkbookNames GET /cells/{name}/names Read workbook's names.
CellsWorkbookApi CellsWorkbookGetWorkbookSettings GET /cells/{name}/settings Get Workbook Settings DTO
CellsWorkbookApi CellsWorkbookGetWorkbookTextItems GET /cells/{name}/textItems Read workbook's text items.
CellsWorkbookApi CellsWorkbookPostAutofitWorkbookRows POST /cells/{name}/autofitrows Autofit workbook rows.
CellsWorkbookApi CellsWorkbookPostEncryptDocument POST /cells/{name}/encryption Encript document.
CellsWorkbookApi CellsWorkbookPostImportData POST /cells/{name}/importdata
CellsWorkbookApi CellsWorkbookPostProtectDocument POST /cells/{name}/protection Protect document.
CellsWorkbookApi CellsWorkbookPostWorkbookCalculateFormula POST /cells/{name}/calculateformula Calculate all formulas in workbook.
CellsWorkbookApi CellsWorkbookPostWorkbookGetSmartMarkerResult POST /cells/{name}/smartmarker Smart marker processing result.
CellsWorkbookApi CellsWorkbookPostWorkbookSettings POST /cells/{name}/settings Update Workbook setting
CellsWorkbookApi CellsWorkbookPostWorkbookSplit POST /cells/{name}/split Split workbook.
CellsWorkbookApi CellsWorkbookPostWorkbooksMerge POST /cells/{name}/merge Merge workbooks.
CellsWorkbookApi CellsWorkbookPostWorkbooksTextReplace POST /cells/{name}/replaceText Replace text.
CellsWorkbookApi CellsWorkbookPostWorkbooksTextSearch POST /cells/{name}/findText Search text.
CellsWorkbookApi CellsWorkbookPutConvertWorkbook PUT /cells/convert Convert workbook from request content to some format.
CellsWorkbookApi CellsWorkbookPutDocumentProtectFromChanges PUT /cells/{name}/writeProtection Protect document from changes.
CellsWorkbookApi CellsWorkbookPutWorkbookCreate PUT /cells/{name} Create new workbook using deferent methods.
CellsWorksheetValidationsApi CellsWorksheetValidationsDeleteWorksheetValidation DELETE /cells/{name}/worksheets/{sheetName}/validations/{validationIndex} Delete worksheet validation by index.
CellsWorksheetValidationsApi CellsWorksheetValidationsGetWorksheetValidation GET /cells/{name}/worksheets/{sheetName}/validations/{validationIndex} Get worksheet validation by index.
CellsWorksheetValidationsApi CellsWorksheetValidationsGetWorksheetValidations GET /cells/{name}/worksheets/{sheetName}/validations Get worksheet validations.
CellsWorksheetValidationsApi CellsWorksheetValidationsPostWorksheetValidation POST /cells/{name}/worksheets/{sheetName}/validations/{validationIndex} Update worksheet validation by index.
CellsWorksheetValidationsApi CellsWorksheetValidationsPutWorksheetValidation PUT /cells/{name}/worksheets/{sheetName}/validations Add worksheet validation at index.
CellsWorksheetsApi CellsWorksheetsDeleteUnprotectWorksheet DELETE /cells/{name}/worksheets/{sheetName}/protection Unprotect worksheet.
CellsWorksheetsApi CellsWorksheetsDeleteWorksheet DELETE /cells/{name}/worksheets/{sheetName} Delete worksheet.
CellsWorksheetsApi CellsWorksheetsDeleteWorksheetBackground DELETE /cells/{name}/worksheets/{sheetName}/background Set worksheet background image.
CellsWorksheetsApi CellsWorksheetsDeleteWorksheetComment DELETE /cells/{name}/worksheets/{sheetName}/comments/{cellName} Delete worksheet's cell comment.
CellsWorksheetsApi CellsWorksheetsDeleteWorksheetComments DELETE /cells/{name}/worksheets/{sheetName}/comments Delete all comments for worksheet.
CellsWorksheetsApi CellsWorksheetsDeleteWorksheetFreezePanes DELETE /cells/{name}/worksheets/{sheetName}/freezepanes Unfreeze panes
CellsWorksheetsApi CellsWorksheetsGetNamedRanges GET /cells/{name}/worksheets/ranges Read worksheets ranges info.
CellsWorksheetsApi CellsWorksheetsGetWorksheet GET /cells/{name}/worksheets/{sheetName} Read worksheet info or export.
CellsWorksheetsApi CellsWorksheetsGetWorksheetCalculateFormula GET /cells/{name}/worksheets/{sheetName}/formulaResult Calculate formula value.
CellsWorksheetsApi CellsWorksheetsGetWorksheetComment GET /cells/{name}/worksheets/{sheetName}/comments/{cellName} Get worksheet comment by cell name.
CellsWorksheetsApi CellsWorksheetsGetWorksheetComments GET /cells/{name}/worksheets/{sheetName}/comments Get worksheet comments.
CellsWorksheetsApi CellsWorksheetsGetWorksheetMergedCell GET /cells/{name}/worksheets/{sheetName}/mergedCells/{mergedCellIndex} Get worksheet merged cell by its index.
CellsWorksheetsApi CellsWorksheetsGetWorksheetMergedCells GET /cells/{name}/worksheets/{sheetName}/mergedCells Get worksheet merged cells.
CellsWorksheetsApi CellsWorksheetsGetWorksheetTextItems GET /cells/{name}/worksheets/{sheetName}/textItems Get worksheet text items.
CellsWorksheetsApi CellsWorksheetsGetWorksheets GET /cells/{name}/worksheets Read worksheets info.
CellsWorksheetsApi CellsWorksheetsPostAutofitWorksheetColumns POST /cells/{name}/worksheets/{sheetName}/autofitcolumns
CellsWorksheetsApi CellsWorksheetsPostAutofitWorksheetRow POST /cells/{name}/worksheets/{sheetName}/autofitrow
CellsWorksheetsApi CellsWorksheetsPostAutofitWorksheetRows POST /cells/{name}/worksheets/{sheetName}/autofitrows Autofit worksheet rows.
CellsWorksheetsApi CellsWorksheetsPostCopyWorksheet POST /cells/{name}/worksheets/{sheetName}/copy
CellsWorksheetsApi CellsWorksheetsPostMoveWorksheet POST /cells/{name}/worksheets/{sheetName}/position Move worksheet.
CellsWorksheetsApi CellsWorksheetsPostRenameWorksheet POST /cells/{name}/worksheets/{sheetName}/rename Rename worksheet
CellsWorksheetsApi CellsWorksheetsPostUpdateWorksheetProperty POST /cells/{name}/worksheets/{sheetName} Update worksheet property
CellsWorksheetsApi CellsWorksheetsPostUpdateWorksheetZoom POST /cells/{name}/worksheets/{sheetName}/zoom
CellsWorksheetsApi CellsWorksheetsPostWorksheetComment POST /cells/{name}/worksheets/{sheetName}/comments/{cellName} Update worksheet's cell comment.
CellsWorksheetsApi CellsWorksheetsPostWorksheetRangeSort POST /cells/{name}/worksheets/{sheetName}/sort Sort worksheet range.
CellsWorksheetsApi CellsWorksheetsPostWorksheetTextSearch POST /cells/{name}/worksheets/{sheetName}/findText Search text.
CellsWorksheetsApi CellsWorksheetsPostWorsheetTextReplace POST /cells/{name}/worksheets/{sheetName}/replaceText Replace text.
CellsWorksheetsApi CellsWorksheetsPutAddNewWorksheet PUT /cells/{name}/worksheets/{sheetName} Add new worksheet.
CellsWorksheetsApi CellsWorksheetsPutChangeVisibilityWorksheet PUT /cells/{name}/worksheets/{sheetName}/visible Change worksheet visibility.
CellsWorksheetsApi CellsWorksheetsPutProtectWorksheet PUT /cells/{name}/worksheets/{sheetName}/protection Protect worksheet.
CellsWorksheetsApi CellsWorksheetsPutWorksheetBackground PUT /cells/{name}/worksheets/{sheetName}/background Set worksheet background image.
CellsWorksheetsApi CellsWorksheetsPutWorksheetComment PUT /cells/{name}/worksheets/{sheetName}/comments/{cellName} Add worksheet's cell comment.
CellsWorksheetsApi CellsWorksheetsPutWorksheetFreezePanes PUT /cells/{name}/worksheets/{sheetName}/freezepanes Set freeze panes
OAuthApi OAuthPost 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