xlsx-workbook v1.0.3

A simple, friendly interface for xslx, that allows easy creation of new Excel spreadsheets and simple editing of existing ones.

Creating a new spreadsheet and adding a little data is easy.

// the Worksheet object gives you a simple interface to a single sheet
var Worksheet = require('xlsx-workbook').Worksheet;

var worksheet = new Worksheet("Hello Spreadsheet");

// add data using row and column indices on the worksheet object
worksheet[0][0] = "Hello";
worksheet[0][1] = "Spreadsheet";

// saving automatically creates a new workbook with the same name
var workbook = worksheet.save();

Creating a workbook with multiple sheets is a snap!

// the Workbook object gives you more control and stores multiple sheets
var Workbook = require('xlsx-workbook').Workbook;

var workbook = new Workbook();

var sales = workbook.add("Sales");
var costs = workbook.add("Costs");

sales[0][0] = 304.50;
sales[1][0] = 159.24;
sales[2][0] = 493.38;

costs[0][0] = 102.50;
costs[1][0] = 59.14;
costs[2][0] = 273.32;

// automatically appends the '.xlsx' extension
workbook.save("Revenue-Summary");

Editing existing workbooks is easy too!

var Workbook = require('xlsx-workbook').Workbook;

// looks for a file with a '.xlsx' extension
var wb = new Workbook("Revenue-Summary");

var sales = wb["Sales"];
var costs = wb["Costs"];

var profits = wb.add("Profits");

for(i = 0; i < sales.length; i++){
	profits[i][0] = sales[i][0] - costs[i][0];
}

wb.save("Revenue-Summary");