Process Excel Spreadsheets with Cloud SDK
Create, Manipulate, Convert or Protect spreadsheets (10+ file formats) from any Node.js based app.
Start Free Trial
Aspose.Cells Cloud SDK for Node.js
A complete SDK for Excel Spreadsheet Processing
No Software download or install required. It is easy to get started with Aspose.Cells Cloud SDK for Node.js and 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 to create, edit, and convert spreadsheets. Along with above-mentioned features, it also enables you to extract data from the spreadsheets for further processing or storage.
Advanced features related to Excel Spreadsheet manipulation
Create spreadsheets from templates, XML or smart markers
Merge multiple spreadsheets
Split spreadsheets to single worksheet spreadsheets
Manipulate rows, columns, cells & data
Protect & unprotect workbooks & worksheets
Convert spreadsheets to different formats
Encrypt & de-crypt spreadsheets
Export worksheets to images
Extract charts, pictures, shapes & other objects as images
Autofit rows & columns
Set complex formula
Add & update text & images
Manipulate comments
Hide & show worksheets
Comprehensive support for Various Spreadsheet Formats
Aspose.Cells Cloud SDK for Node.js enables the developers to easily open and save a multitude of file formats. Some of the formats include XLS, XLSX, XLSM, XLTX, XLTM, ODS, Tab delim., CSV, TXT, PDF, SpreadsheetML, HTML, TIFF, JPG, PNG, BMP and SVG. The Office Open XML (OOXML) is a container format for several specialized XML-based markup languages. OOXML SpreadsheetML documents mostly come as XLSX files, which are ZIP packages. In addition to XLSX format, Aspose.Cells Cloud SDK for Node.js also offers extensive support for converting SpreadsheetML documents.
Manage Worksheets using Node.js
Aspose.Cells Cloud SDK for Node.js gives you complete control over spreadsheets and the data inside them. The Excel cloud SDK helps you create formulas and make sophisticated calculations based on user input or external data sources. You may use it to work with individual cells in a spreadsheet, add comments, apply validation rules and manage hyperlinks & pictures. The SDK also allows manipulating all aspects of the spreadsheets including worksheets, rows, columns, cells, text, data, images, links, comments, charts and many more. Aspose.Cells Cloud SDK for Node.js puts these features at your fingertips, through a cloud-based SDK.
Get Chart from a Worksheet - Node.js
// Instantiate Aspose Storage SDK
var storageApi = new StorageApi(config);
// Instantiate Aspose Cells SDK
var cellsApi = new CellsApi(config);
// Upload source file to aspose cloud storage
storageApi.PutCreate("Sample_Test_Book.xls", null, null, '../../../../Data/' + "Sample_Test_Book.xls", function(responseMessage) {
assert.equal(responseMessage.status, 'OK');
// Invoke Aspose.Cells Cloud SDK to get a specific chart from a worksheet
cellsApi.GetWorksheetChart("Sample_Test_Book.xls", "Sheet5", 0, null, null, function(responseMessage) {
assert.equal(responseMessage.status, 'OK');
var chart = responseMessage.body.Chart;
console.log("Chat Type :: " + chart.Type);
console.log("Chat Name :: " + chart.Name);
});
});
Manipulate Excel Spreadsheet contents
Get the ability to add or remove data in cell elements. The data may include comments, pictures, hyperlinks and any validation rules applied over cells. In fact, Aspose.Cells Cloud SDK for Node.js is a complete solution in cloud exposed as a REST interface. It also enables you to extract text, images, data and many other objects from the Excel spreadsheets while using simple interfaces.
Get Hyperlink from Excel Worksheet - Node.js
// Instantiate Aspose Storage SDK
var storageApi = new StorageApi(config);
// Instantiate Aspose Cells SDK
var cellsApi = new CellsApi(config);
// Upload source file to aspose cloud storage
storageApi.PutCreate("Sample_Test_Book.xls", null, null, '../../../../Data/' + "Sample_Test_Book.xls", function(responseMessage) {
assert.equal(responseMessage.status, 'OK');
// Invoke Aspose.Cells Cloud SDK to get a specific hyperlink from a worksheet
cellsApi.GetWorkSheetHyperlink("Sample_Test_Book.xls", "Sheet2", hyperlinkIndex, null, null, function(responseMessage) {
assert.equal(responseMessage.status, 'OK');
var hyperlink = responseMessage.body.Hyperlink;
console.log("Hyperlink Address : " + hyperlink.Address);
});
});
Handle Worksheet Data
Aspose.Cells Cloud SDK for Node.js allows you to manipulate spreadsheet data including text, numeric or alphanumeric with the help of simple methods. You can add, modify or remove data from cells as well as add and calculating formulas in a worksheet cell to get the resultant value.
Render Spreadsheets as Images
Aspose.Cells Cloud SDK for Node.js supports rendering Excel spreadsheets, Charts, AutoShapes and OleObjects to most commonly used image formats like JPG, BMP, GIF, PNG. During conversion, Aspose.Cells Cloud SDK for Node.js ensures accuracy and precision.
Convert AutoShape to Image - Node.js
// Instantiate Aspose Storage SDK
var storageApi = new StorageApi(config);
// Instantiate Aspose Cells SDK
var cellsApi = new CellsApi(config);
// Upload source file to aspose cloud storage
storageApi.PutCreate("Sample_Test_Book.xls", null, null, '../../../../Data/' + "Sample_Test_Book.xls", function(responseMessage) {
assert.equal(responseMessage.status, 'OK');
// Invoke Aspose.Cells Cloud SDK to convert an autoshape to image
cellsApi.GetWorksheetAutoshapeWithFormat("Sample_Test_Book.xls", "Sheet4", 1, format, null, null, function(responseMessage) {
assert.equal(responseMessage.status, 'OK');
// Download image from response stream
assert.equal(responseMessage.status, 'OK');
var writeStream = fs.createWriteStream(data_path + "Resultant.png");
writeStream.write(responseMessage.body);
});
});
High Fidelity PDF Conversion of Spreadsheets
The output of SDK conforms to PDF 1.5 or PDF/A-1b specifications and SDK goes an extra mile while performing the conversion of Microsoft Excel documents to PDF format with a high degree of precision. As a result, majority of conversions will be indistinguishable from the original Microsoft Excel document.
Support and Learning Resources
- Learning Resources
- Documentation
- Source Code
- API References
- Tutorial Videos
- Product Support
- Free Support
- Blog
- Aspose.Cells Blog
- Why Aspose.Cells Cloud SDK for Node.js ?
- Customers List
- Security