atomantic-edit-xlsx
v0.0.4
Published
Edit an existing xlsx file.
Downloads
2
Readme
adr-edit-xlsx
Edit an existing xlsx file. Things to be able to do are simple. Read and write cell values. That's all. Available data types are boolean, number and string, not formula.
Install
npm install atomantic-edit-xlsx --save
Usage
var EditXlsx = require('edit-xlsx');
var data = {
title: 'AKIRA',
creator: 'Katsuhiro Otomo',
year: 1988
};
var xlsx = new EditXlsx('src.xlsx');
var sheet = xlsx.sheet(0);
sheet.update('A1', 'Title');
sheet.update([2, 1], 'Creator');
sheet.update('C1', 'Year');
sheet.update([1, 2], data.title);
sheet.update('B2', data.creator);
sheet.update('C2', data.year);
sheet = xlsx.sheet(1);
sheet.update('A1', 'test');
xlsx.save('output.xlsx');
xlsx = new EditXlsx('output.xlsx');
sheet = xlsx.sheet(0);
console.log(sheet.value('B2')); //=> 'Katsuhiro Otomo'
console.log(sheet.value([1, 2], 'C2')); //=> ['AKIRA', 1988]
License
Licensed under the MIT license.