xlsx-workbook
v1.0.3
Published
A simple, friendly interface for xlsx
Downloads
847
Maintainers
Readme
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");