Aspose.Cells Cloud SDK for Node.js enables your cloud-based applications to read excel spreadsheets, export XLSX workbooks, convert Microsoft Excel & OpenOffice documents to PDF, XPS, TIFF, Markdown (MD), DIF, SVG, XML (SpreadsheetML), CSV, TSV, HTML and other supported formats, without installing any 3rd party software.
Aspose.Cells Cloud SDK for Node.js gets its robust functionality from underlying Aspose.Cells REST API and allows your Node.js code to work with Excel conditional formatting, auto-filters, auto-shapes, charts, OleObjects, page breaks, ListObjects, pivot tables, tasks and ranges. Use simple Node.js commands to programmatically create, update, encrypt, merge, password protect, export and convert XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM & ODS files to other supported formats.
At a Glance
Aspose.Cells Cloud can perform all spreadsheet manipulation tasks.
- Work with tables
- Work with cells
- Work with charts
- Work with hyperlinks
- Work with pivot tables
- Work with pictures & shapes
- Work with validations
Supported File Formats
Aspose.Cells Cloud supported file formats.
- Microsoft Excel: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM
- OpenOffice: ODS
- SpreadsheetML: XML
- Text: CSV, TSV, TXT (TabDelimited)
- Web: HTML, MHTML
- SXC, FODS
- DIF, PDF, XPS, TIFF, SVG, MD (Markdown)
Aspose.Cells Cloud supports all major platforms and programming languages.
Advanced features to manipulate Excel Spreadsheets
Add filters with custom criteria for lists
Support for multiple types of list filters
Get information regarding Chart Area border or fill format
Add, update, and delete charts in worksheet
Get, update, show or hide chart legend
Get, update, chart title and set its visibility
Add or remove a cell area for conditional formatting
Add, update, and delete worksheet hyperlinks
Add a ListObject at specified place in the Excel file
Delete specific or all ListObjects in a worksheet
Convert ListObject or table to a range of cells
Summarize data of large ListObject or Table with Pivot Table
Add OleObjects to Excel worksheet
Delete specific or all OleObjects from worksheet
Insert or delete, horizontal or vertical page breaks
Manipulate page setup, header & footer
Add, update, fetch or delete worksheet pictures
Create, update, fetch or delete document properties
Fetch the required shape from worksheet
Add, update or delete shapes from a worksheet
Add, update or delete validations for worksheets
Get Started with Excel Spreadsheet Processing SDK
In order to get started with Aspose.Cells Cloud SDK for Node.js, you do not need to install anything. All you need to do is create an account at Aspose for Cloud and get your application information. Once you have the App SID & key, you are ready to use Aspose.Cells Cloud SDK for Node.js on any platform which supports REST APIs. Aspose.Cells Cloud SDK for Node.js provides you all the features to create, edit, and convert spreadsheets. It also allows you to extract data from the spreadsheets for further processing or storage.
Processing Workbooks via Cloud SDK
Aspose.Cells Cloud SDK for Node.js allows you to create, split, merge, search and replace text, password protection, export to supported file format, read workbook’s text items, auto-fit workbook rows while ignoring hidden elements, encrypt workbook password and provide encryption key length, import data to workbook, calculate all formulas in workbook, set formula calculation settings by providing precision strategy etc., use smart marker, convert workbook from request content to another format, apply password to allow content modification.
Cloud SDK to Process Worksheets
Using Aspose.Cells Cloud SDK for Node.js you can delete specific row or all rows in the worksheet, fetch worksheet cell data or cell style by cell’s name, read worksheet row or column data by its index, calculate cell formula, clear cell contents, copy cell into another cell, copy worksheet columns and rows, group worksheet rows and columns, hide worksheet rows and columns, set worksheet column and row styles, set HTMLSTRING value into cell, set cell range value and modify lot of other worksheet settings.
Leverage the power of Pivot Tables & Ranges
Aspose.Cells Cloud SDK for Node.js allows you to add a pivot table into worksheet, add or delete pivot fields into pivot table, add or remove pivot filter for pivot table index, update cell style for pivot table, and calculate pivot table's data to cells.
Aspose.Cells Cloud SDK for Node.js can also be used to get cells list in a range by range name or row column indexes, set column width of range, combine a range of cells into a single cell, move the current range to the destination range, sets outline border around a range of cells., set row height of range, set the style of the range, unmerges merged cells of this range, put a value into the range and convert its data type, and copy range in the worksheet.