1.0.0 • Published 6 years ago

excel-parse-json v1.0.0

Weekly downloads
-
License
ISC
Repository
-
Last release
6 years ago

How to use:

npm install --save excel-parse-json
var excel = require('excel-parse-json');

var opts = {
    filePath: __dirname,
    fileName: 'File.xlsx'
}

excel.parse(opts).then(val =>{
    var workSheet = val;
    console.log(workSheet);
}).catch(err => {
    console.error(err);
});

Dependencies

  • node-xlsx
  • fs

How does it work?

The parse function will get the first row and all columns will be indices for the json object and all other rows will be their values.