Skip to content
master
Go to file
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
 
 
 
 
src
 
 
 
 
 
 
 
 
 
 
 
 
 
 

README.md

npm node-current GitHub license GitHub commits since latest release (by date)

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.

Enhancements in Version 20.11

  • Support Aspose.Cells Cloud for Docker.

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 Spreadsheets As

Microsoft Excel: XLS, XLSX, XLSB OpenOffice: ODS SpreadsheetML: XML Text: CSV, TSV, TXT (TabDelimited) Web: HTML, MHTML Fixed Layout: PDF, XPS Images: PNG, JPG, TIFF, SVG Markdown: MD Other: DIF

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

.NET Java PHP Python Ruby Android Swift Perl GO
GitHub GitHub GitHub GitHub GitHub GitHub GitHub GitHub GitHub
NuGet Maven Composer PIP GEM Maven POD CPAN GO

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

You can’t perform that action at this time.