Android library for communicating with the Aspose.Cells Cloud API
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
.swagger-codegen
TestData
docs
gradle/wrapper
src
.gitignore
.swagger-codegen-ignore
README.md
aspose-cells-cloud-android.iml
build.gradle
git_push.sh
gradlew
gradlew.bat

README.md

aspose-cells-cloud-android

Requirements

Building the API client library requires Maven to be installed.

Installation

To install the API client library to your local Maven repository, simply execute:

mvn install

To deploy it to a remote Maven repository instead, configure the settings of the repository and execute:

mvn deploy

Refer to the official documentation for more information.

Maven users

Add this dependency to your project's POM:

<dependency>
    <groupId>com.aspose</groupId>
    <artifactId>aspose-cloud-cells-android</artifactId>
    <version>18.9</version>
    <scope>compile</scope>
</dependency>

Gradle users

Add this dependency to your project's build file:

compile "com.aspose:aspose-cells-cloud:18.9"

Others

At first generate the JAR by executing:

mvn package

Then manually install the following JARs:

  • target/aspose-cloud-cells-android-18.9.jar
  • target/lib/*.jar

Getting Started

Please follow the installation instruction and execute the following Java code:

import com.aspose.cloud.cells.api.CellsApi;

public class CellsApiExample {

    public static void main(String[] args) {
        CellsApi apiInstance = new CellsApi();
        String name = "name_example"; // String | The workbook name.
        String sheetName = "sheetName_example"; // String | The worksheet name.
        Integer columnIndex = 56; // Integer | The column index.
        Integer columns = 56; // Integer | The columns.
        Boolean updateReference = true; // Boolean | The update reference.
        String folder = "folder_example"; // String | The workbook folder.
        String storage = "storage_example"; // String | storage name.
        try {
            ColumnsResponse result = apiInstance.cellsDeleteWorksheetColumns(name, sheetName, columnIndex, columns, updateReference, folder, storage);
            System.out.println(result);
        } catch (ApiException e) {
            System.err.println("Exception when calling CellsApi#cellsDeleteWorksheetColumns");
            e.printStackTrace();
        }
    }
}

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 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

Authentication schemes defined for the API:

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

Recommendation

It's recommended to create an instance of ApiClient per thread in a multithreaded environment to avoid any potential issues.

Author