English

简体中文 Русский عربي Français Deutsch Italiano Español Svenska Türkçe

Developer Center

- What's new
- Getting Started
- Learn
- Developer Guide
- Docker
- Release Notes

Home
Developer Center
Developer Guide
Developer Guide 3.0

Developer Guide 3.0

Contents

Working with Aspose.Cells Cloud REST APIs

Working with Aspose.Cells Cloud REST APIs

File

Workbook new, convert, saveas

Creates an empty Excel workbook.
Creates Excel workbook from a template file.
Creates Excel workbook from a smart marker template.
Converts Excel workbook to different file formats.
Save Excel workbook as different file formats.

Search, Replace

Search text form Excel files.
Replace old value by new value on Excel files.

Compress

Compress Excel files.

Workbook merge, split

Merges Excel workbooks.
Splits Excel workbooks.

Watermarks

Adds background in workbook.
Deletes background in workbook.
Sets background or watermark on Excel worksheet.
Deletes background or watermark on Excel worksheet.

Home

Cells font, styles, conditional formatting and value

Gets cell style from an Excel worksheet.
Updates multiple cells style on an Excel worksheet.
Updates cell style on an Excel worksheet.
Sets rich text formatting to a cell of Excel worksheet.
Clears contents and styles of cells on Excel worksheet.
Adds, deletes and updates conditional formatting on Excel worksheet.
Sets value of a cell on an Excel worksheet.

Row/Column insert, delete, copy, hide and auto fit

Adds an empty row on an Excel worksheet.
Deletes row from an Excel worksheet.
Copys rows on an Excel worksheet.
Hide rows on an Excel worksheet.
Auto fit rows on an Excel workbook.
Adds an empty column on an Excel worksheet.
Deletes column from an Excel worksheet.
Copys columns on an Excel worksheet.
Hide columns on an Excel worksheet.
Auto fit columns on an Excel workbook.

Insert

Chart

Adds a chart on an Excel worksheet.
Deletes a chart on an Excel worksheet.
Deletes all charts on an Excel worksheet.
Converts chart to image.
Hides chart legend on an Excel worksheet.
Updates chart title on an Excel worksheet.
Deletes chart title on an Excel worksheet.

Table

Adds a list object on an Excel worksheet.
Updates a list object on an Excel worksheet.
Converts list object to range.
Sorts table data.

OleObject

Adds Ole-object on an Excel worksheet.
Updates a specific Ole-object on an Excel worksheet.
Converts Ole-object to image.
Deletes all Ole-objects on an Excel worksheet.
Deletes a specific Ole-object on an Excel worksheet.

Shape

Adds a shape on an Excel worksheet.
Deletes all shapes on an Excel worksheet.
Deletes a shape by Index on an Excel Worksheet.

Pivot Table

Adds a pivot table on an Excel worksheet.
Deletes on all pivot tables an Excel worksheet.
Deletes a pivot table by index on an Excel worksheet.
Updates cell style of pivot table on an Excel worksheet.
Updates style of pivot table on an Excel worksheet.
Working with pivot filters on an Excel worksheet
Hides pivot field item on an Excel worksheet
Moves pivot table on an Excel worksheet.

Page Layout

Page Break

Inserts a horizontal page break on an Excel worksheet.
Inserts a vertical page break on an Excel worksheet.
Deletes a horizontal page break on an Excel worksheet.
Deletes a vertical page break on an Excel worksheet.

Page Setup

Formulas

Calculate

Calculates all formulas on an Excel workbook.
Calculates cells formula on an Excel workbook.
Calculates formula on an Excel Worksheet.

Name

Data

Outline

Groups rows on an Excel Worksheet.
Ungroups rows on an Excel Worksheet

Filter

Adds a filter for a filter column on an Excel worksheet.
Deletes a filter for a filter column on an Excel worksheet.
Removes a date filter on an Excel worksheet.
Adds an icon filter on an Excel worksheet.
Add a date filter on an Excel worksheet.
Filters a list with a custom criteria on an Excel worksheet.
Filters a top 10 items in the List on an Excel worksheet.
Matchs all blank cells in the list on an Excel worksheet.

Sort

Sorts cells data on an Excel worksheet.

Import Data

Imports data into Excel files.
Imports CSV data into an Excel worksheet.
Imports picture into an Excel worksheet.
Imports double array into an Excel worksheet.
Imports integer array into an Excel worksheet.
Imports string array into an Excel worksheet.
Imports data into an Excel worksheet with using Storage.
Imports data into an Excel worksheet without using Storage.

Assembly

Assemble data in Excel files.

Review

Comments

Adds a comment to a Cell on an Excel worksheet.
Updates a comment on an Excel worksheet.
Deletes all comments on an Excel worksheet.

Changes

Protects an Excel workbook.
Un-protects an Excel workbook.

View

Windows

Freezes panes on an Excel worksheet.
Unfreezes Panes on an Excel worksheet.
Hides an Excel worksheet.
Deletes all comments on an Excel worksheet.

Zoom

Sets zoom on an Excel worksheet.

Files and Storage Aspose.Cells Cloud Web API - Other Features: Health Check, Get Public Key, and More