Loading and managing Excel, OpenOffice, Json, Csv and Html files

With Aspose.Cells, it is simple to create, open, and manage Excel files, for example, to retrieve data, or to use a designer template to speed up the development process.

Creating a New Workbook

The following example creates a new workbook from scratch.

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const licensePath = path.join(dataDir, "Aspose.Cells.lic");

try {
    // Create a License object
    const license = new AsposeCells.License();

    // Set the license of Aspose.Cells to avoid the evaluation limitations
    license.setLicense(licensePath);
} catch (ex) {
    console.log(ex.message);
}

// Instantiate a Workbook object that represents an Excel file.
const wb = new AsposeCells.Workbook();

// When you create a new workbook, a default "Sheet1" is added to the workbook.
const sheet = wb.getWorksheets().get(0);

// Access the "A1" cell in the sheet.
const cell = sheet.getCells().get("A1");

// Input the "Hello World!" text into the "A1" cell
cell.putValue("Hello World!");

// Save the Excel file.
wb.save(path.join(dataDir, "MyBook_out.xlsx"));

Opening and saving a File

With Aspose.Cells, it is simple to open, save and manage Excel files.

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");

// Opening through Path
// Creating a Workbook object and opening an Excel file using its file path
const workbook1 = new AsposeCells.Workbook(path.join(dataDir, "Book1.xlsx"));

// Adding new sheet
const sheet = workbook1.getWorksheets().add("MySheet");

// Setting active sheet
workbook1.getWorksheets().setActiveSheetIndex(1);

// Setting values.
const cells = sheet.getCells();

// Setting text
cells.get("A1").putValue("Hello!");

// Setting number
cells.get("A2").putValue(1000);

// Setting Date Time
const cell = cells.get("A3");
cell.putValue(new Date());
const style = cell.getStyle();
style.setNumber(14);
cell.setStyle(style);

// Setting formula
cells.get("A4").setFormula("=SUM(A1:A3)");

// Saving the workbook to disk.
workbook1.save(path.join(dataDir, "dest.xlsx"));

Advanced Topics

Different Ways to Save Files with Node.js via C++