asposecellscloud

Process Excel® Files in the Cloud with Node.js

Aspose.Cells Cloud SDK for Node.js allows developers to create, edit, process & convert Excel spreadsheets in the Cloud. The Node.js Excel Cloud SDK gets its functionality from Aspose.Cells Cloud API, allowing your Node.js apps to work with all Excel file formats and features including worksheet & cell management, conditional formatting, auto-filters, auto-shapes, charts, OleObjects, page breaks, ListObjects, Pivot Tables, charts and much more.

Excel File Manipulation Features

• Create Excel files from scratch via API or Smart Markers.
• Load, process & convert Excel files via Cloud SDK.
• Add, update or delete worksheet, charts, pictures, shapes, hyperlinks & validations.
• Add or remove cells area for conditional formatting from Excel worksheets.
• Insert or delete, horizontal or vertical page breaks.
• Add ListObject or convert ListObjects to a range of cells.
• Summarize data with Pivot Tables & Excel charts.
• 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.
• Leverage the power of named ranges.

Feature & Enhancements in Version 24.2.1

Full list of issues covering all changes in this release:

• Add the analyze excel api for analyze controller.

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 PDF

Save Spreadsheet As

DIF, HTML, MHTML, PNG, JPG, TIFF, XPS, SVG, MD (Markdown), ODS, XLSX, XLS, XLSB, PDF, XML, TXT, CSV

Read Other Formats

SXC, FODS

Integrated Storage API

Since version 19.9, SDK includes support of storage operations for better user experience and unification. It gives you an ability to;

• Upload, download, copy, move and delete files, including versions handling (if you are using Cloud storage that supports this feature - true by default).
• Create, copy, move and delete folders.
• Copy and move files and folders across separate storages in scope of a single operation.
• Check if certain file, folder or storage exists.

Get Started with Aspose.Cells Cloud SDK for Node.js

First, create an account at Aspose for Cloud to get your application information. Next, execute npm install asposecellscloud --save from the command line to install Aspose.Cells Cloud SDK for Node.js via NPM.

Convert Excel to PDF via Node.js

var fs = require('fs');
var path = require('path');
var assert = require('assert');
const localPath = "../TestData/";
describe('cellsWorkbookPutConvertWorkbook', function() {
  it('should call cellsWorkbookPutConvertWorkbook successfully', function() {
    const cellsApi =new api.CellsApi(clientId, clientSecret);
    const filename = "Book1.xlsx";
    var data =fs.createReadStream(localPath  + filename);
    var req = new model.UploadFileRequest();
    req.path = "Temp/" + filename;
    req.file = data;

    return cellsApi.uploadFile(req)
      .then(() => {
        var req = new model.CellsWorkbook_PutConvertWorkbookRequest({
          workbook : fs.createReadStream(localPath  + filename),
          format : "pdf",
        });

        return cellsApi.cellsWorkbookPutConvertWorkbook(req)
          .then((result) => {
            expect(result.body.toString().length).to.greaterThan(0);
          });
      });
  });
});

Hide Excel Columns via Node.js

const { CellsApi, Cells_PostHideWorksheetColumnsRequest } = require("asposecellscloud");

clientId = ""
clientSecret = ""
cellsApi = new CellsApi(clientId, clientSecret);
filename = "Book1.xlsx"

var req = new Cells_PostHideWorksheetColumnsRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.startColumn = 1;
req.totalColumns = 2;
req.folder = "";

return cellsApi.cellsPostHideWorksheetColumns(req)
    .then((result) => {
        console.log(result)
    });

Merge Worksheets in the Cloud

const { CellsApi, Cells_PostWorksheetMergeRequest } = require("asposecellscloud");

clientId = ""
clientSecret = ""
cellsApi = new CellsApi(clientId, clientSecret);
filename = "Book1.xlsx"

var req = new Cells_PostWorksheetMergeRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.startRow = 1;
req.startColumn = 1;
req.totalRows = 4;
req.totalColumns = 4;
req.folder = "";

return cellsApi.cellsPostWorksheetMerge(req)
  .then((result) => {
    console.log(result)
  });

Aspose.Cells Cloud SDKs in Popular Languages

Java	PHP	Python	Ruby	Node.js	Android	Swift	Perl	GO
GitHub	GitHub	GitHub	GitHub	GitHub	GitHub	GitHub	GitHub	GitHub
Maven	Composer	PIP	GEM	NPM	Maven	POD	CPAN	GO

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