A powerful library for manipulating and converting Excel (XLS, XLSX, XLSB), ODS, CSV and HTML files.
npm install aspose.cellsAspose.Cells for Node.js via Java is a scalable and feature-rich API to create, process, manipulate & convert Excel & OpenOffice spreadsheets using Node.js. API offers Excel file generation, conversion, worksheets styling, Pivot Table & chart management & rendering, reliable formula calculation engine and much more - all without any dependency on Office Automation or Microsoft Excel®.
js
var aspose = aspose || {};
aspose.cells = require("aspose.cells");
var workbook = new aspose.cells.Workbook(aspose.cells.FileFormatType.XLSX);
workbook.getWorksheets().get(0).getCells().get("A1").putValue("testing...");
workbook.save("output.xlsx");
`
$3
` js
var aspose = aspose || {};
aspose.cells = require("aspose.cells");
var workbook = new aspose.cells.Workbook("example.xlsx");
var saveOptions = aspose.cells.PdfSaveOptions();
saveOptions.setOnePagePerSheet(true);
workbook.save("example.pdf", saveOptions);
`
$3
`js
var aspose = aspose || {};
aspose.cells = require("aspose.cells");
var excel = new aspose.cells.Workbook();
var style = excel.createStyle();
style.getFont().setName("Times New Roman");
style.getFont().setColor(aspose.cells.Color.getBlue());
for (var i = 0; i < 100; i++)
{
excel.getWorksheets().get(0).getCells().get(0, i).setStyle(style);
}
`
$3
`js
var aspose = aspose || {};
aspose.cells = require("aspose.cells");
var workbook = new aspose.cells.Workbook();
var sheetIndex = workbook.getWorksheets().add();
var worksheet = workbook.getWorksheets().get(sheetIndex);
// adding a picture at "F6" cell
worksheet.getPictures().add(5, 5, "image.gif");
workbook.save("output.xls", aspose.cells.SaveFormat.EXCEL_97_TO_2003);
``