aspose.cells.js

Aspose.Cells for JavaScript via C++ is a high-performance, feature-rich library for manipulating and converting spreadsheet files, including Excel (XLS, XLSX, XLSB, XLSM), ODS, CSV, and HTML formats. It provides a comprehensive set of features for creating, editing, converting, and rendering spreadsheets in both browser and Node.js environments. With full support for all major Excel formats, Aspose.Cells for JavaScript via C++ ensures maximum compatibility and flexibility across diverse use cases.

Built with WebAssembly to unlock near-native performance directly in the browser, Aspose.Cells for JavaScript via C++ enables fast and efficient spreadsheet processing without the need for a server. Its lightweight runtime footprint makes it perfect for serverless web applications that require advanced Excel functionality. Whether you're building dashboards, data processing pipelines, or document generation tools, Aspose.Cells for JavaScript via C++ offers a complete, reliable, and high-performance solution that works seamlessly across web, server-side, and hybrid environments.

Key features

- File Creation and Editing: Create new spreadsheets from scratch or edit existing ones with ease. This includes adding or modifying data, formatting cells, managing worksheets, and more.
- Data Processing: Perform complex data manipulations such as sorting, filtering, and validation. The library also supports advanced formulas and functions to facilitate data analysis and calculations.
- File Conversion: Convert Excel files to various formats such as PDF, HTML, ODS, and image formats like PNG and JPEG. This feature is useful for sharing and distributing spreadsheet data in different formats.
- Chart and Graphics: Create and customize a wide range of charts and graphics to visually represent data. The library supports bar charts, line charts, pie charts, and many more, along with customization options for design and layout.
- Rendering and Printing: Render Excel sheets to high-fidelity images and PDFs, ensuring that the visual representation is accurate. The library also provides options for printing spreadsheets with precise control over page layout and formatting.
- Advanced Protection and Security: Protect spreadsheets with passwords, encrypt files, and manage access permissions to ensure data security and integrity.
- Performance and Scalability: Designed to handle large datasets and complex spreadsheets efficiently, Aspose.Cells for JavaScript via C++ ensures high performance and scalability for enterprise-level applications.

Read & Write Excel Files

- Microsoft Excel: XLS, XLSX, XLSB, XLTX, XLTM, XLSM, XML
- OpenOffice: ODS
- Text: CSV, Tab-Delimited, TXT, JSON
- Web: HTML, MHTML

Save Excel Files As

- Fixed Layout: PDF, XPS
- Images: JPEG, PNG, BMP, SVG, TIFF, GIF, EMF
- Text: CSV, Tab-Delimited, JSON, SQL, XML

Browser and Node.js Support

- Fully compatible with modern browsers (Chrome, Firefox, Edge, Safari) and Node.js runtimes.
- Ensures consistent behavior across both client-side and server-side applications for seamless integration and execution.

Getting Started

$3

 html





$3

You need to use encrypt_lic.html in a http server to get the encrypted license file (aspose.cells.enc) in order to run in full-featured mode.

To run the http server:

shell

cd node_modules/aspose.cells.js

python -m http.server 8080

$3

$3

html

$3

 js

const fs = require("fs");

const { AsposeCells } = require("aspose.cells.js");

const { Workbook, SaveFormat } = AsposeCells;



AsposeCells.onReady({

        license: "aspose.cells.enc",

        fontPath: "./fonts/",

        fontList: [

            "arial.ttf",

            "NotoSansSC-Regular.ttf"

        ]

    }).then(() => {

    const fileBuffer = fs.readFileSync("example.xlsx");

    var workbook = new Workbook(new Uint8Array(fileBuffer));

    const outputData = workbook.save(SaveFormat.Pdf);

    fs.writeFileSync("output.pdf", outputData);

});

$3

 js

import fs from 'fs';

import { AsposeCells } from 'aspose.cells.js';

const { Workbook, FileFormatType, SaveFormat } = AsposeCells;



AsposeCells.onReady({

        license: "aspose.cells.enc",

        fontPath: "./fonts/",

        fontList: [

            "arial.ttf",

            "NotoSansSC-Regular.ttf"

        ]

    }).then(() => {

    var workbook = new Workbook(FileFormatType.Xlsx);

    workbook.worksheets.get(0).cells.get("A1").putValue("Hello World");

    const outputData = workbook.save(SaveFormat.Xlsx);

    fs.writeFileSync("hello-es6.xlsx", outputData);

});



Note: Please save the above code as example.mjs file and run it using

node example.mjs

.





$3

html