Aspose.Cells-Cloud 20.2.0

.NET REST API for Spreadsheet Processing in Cloud

This Cloud SDK enhances your C#, ASP.NET, & other .NET cloud-based apps to process & manipulate Microsoft Excel spreadsheets in the cloud, without MS Office.

Spreadsheet Processing Features

• Add, update or delete charts, worksheet pictures, shapes, hyperlinks & validations.
• Add or remove cells area for conditional formatting, or OleObjects from Excel worksheets.
• Insert or delete, horizontal or vertical page breaks
• Add ListObject at a specific place within an Excel file & convert them to a range of cells.
• Delete specific or all ListObjects in a worksheet or summarize its data with pivot table.
• Apply custom criteria to list filters of various types.
• Get, update, show or hide chart legend & titles.
• Manipulate page setup, header & footer.
• Create, update, fetch or delete document properties.
• Fetch the required shape from worksheet.
• Load & Process Excel Spreadsheets via Cloud SDK.
• Cloud SDK to Read & Process Excel Worksheets.
• Leverage the Power of Pivot Tables & Ranges.

Enhancements in Version 20.2.0

• Automatically refresh authorization Token in SDK.

Read & Write Spreadsheet Formats

Microsoft Excel: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM OpenOffice: ODS SpreadsheetML: XML Text: CSV, TSV, TXT (TabDelimited) Web: HTML, MHTML

Save Spreadsheet As

DIF, PDF, XPS, TIFF, SVG, MD (Markdown)

Read Spreadsheet Formats

SXC, FODS

Platform Independence

Aspose.Cells Cloud’s platform independent document manipulation API is a true REST API that can be used from any platform. You can use it with any language or platform that supports REST, be it the web, desktop, mobile, or the cloud. The API integrates with other cloud services to provide you the flexibility you require for processing documents. It is suitable for the most types of businesses, documents, or content.

Getting Started with Aspose.Cells Cloud SDK for .NET

You do not need to install anything to get started with Aspose.Cells Cloud SDK for .NET. Just create an account at Aspose for Cloud and get your application information.

Simply execute Install-Package Aspose.Cells-Cloud from the Package Manager Console in Visual Studio to fetch & reference Aspose.Cells assembly in your project. If you already have Aspose.Cells Cloud SDK for .NET and want to upgrade it, please execute Update-Package Aspose.Cells-Cloud to get the latest version.

Please check the GitHub Repository for other common usage scenarios.

Using C# to Add a New Worksheet to an Excel File

The following code snippet demonstrates how to add a new worksheet to a Microsoft Excel document using C# code:

CellsWorksheetsApi instance = new CellsWorksheetsApi(GetConfiguration());
string name = "Input.xlsx";
string sheetName = "Sheet1";
int? position = 1;
string sheettype = "VB";
string folder = null;
UpdateDataFile(folder, name);
var response = instance.CellsWorksheetsPutAddNewWorksheet(name, sheetName, position, sheettype, folder);

Using C# to Convert an Excel File to another File Format

The following code example elaborates how you can use C# code to convert an Excel document to another file format in the cloud:

// Upload source file to aspose cloud storage
storageApi.PutCreate(inputfileName, "", "", System.IO.File.ReadAllBytes(Common.GetDataDir() + inputfileName));

// Invoke Aspose.Cells Cloud SDK API to convert excel workbook to different format
SaveResponse apiResponse = cellsApi.PostDocumentSaveAs(inputfileName, outputFileName, isAutoFitRows, isAutoFitColumns, storage, folder, body);

Product Page | Documentation | API Reference | Code Samples | Blog | Free Support | Free Trial