Node.js excel parser & builder
Excel parser/builder that relies on js-xlsx.
npm install excel node-xlsx
Parsing a xlsx from file/buffer, outputs an array of arrays
var xlsx = require'node-xlsx';var obj = xlsxparse__dirname + '/myFile.xlsx'; // parses a filevar obj = xlsxparsefsreadFileSync__dirname + '/myFile.xlsx'; // parses a buffer
Building a plist from an object
var xlsx = require'node-xlsx';var data = 123true false null 'sheetjs''foo''bar''2014-02-19T14:30Z' '0.3' 'baz' null 'qux';var buffer = xlsxbuildname: "mySheetName" data: data; // returns a buffer
node-xlsx is tested with
npm install --devnpm test
Copyright (C) 2012-2014 Olivier LouvignesLicensed under the Apache License, Version 2.0 (the "License");you may not use this file except in compliance with the License.You may obtain a copy of the License atUnless required by applicable law or agreed to in writing, softwaredistributed under the License is distributed on an "AS IS" BASIS,WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.See the License for the specific language governing permissions andlimitations under the License.Except where noted, this license applies to any and all software programs and associated documentation files created by the Original Author and distributed with the Software:'node-xlsx.js' is a modified version of SheetJS gist examples, Copyright (c) SheetJS.