xlsx-to-json-lc

Convert xlsx to json with optional option to lowerCase the excel headers (Credits DataGarage Fork)

Downloads in past

Stats

StarsIssuesVersionUpdatedCreatedSize
xlsx-to-json-lc
310.5.07 years ago8 years agoMinified + gzip package size for xlsx-to-json-lc in KB

Popular Searches

Readme

node-xlsx-json
Build Status Converting xlsx file to json files using nodejs. This is a fork of DataGarage module with additional option of converting excel headers to lowerCase as json keys.

Install

``` npm install xlsx-to-json-lc ```

Usage

```javascript xlsxj = require("xlsx-to-json"); xlsxj({ 
input: "sample.xlsx", 
output: "output.json",
lowerCaseHeaders:true //converts excel header rows into lowercase as json keys
}, function(err, result) { 
if(err) {
console.error(err);
}else {
console.log(result);
}
}); ```

Specifying a target sheet

You can optionally provide a sheet name to extract from that sheet ```javascript xlsxj = require("xlsx-to-json"); xlsxj({ 
input: "sample.xlsx", 
output: "output.json",
sheet: "tags"
}, function(err, result) { 
if(err) {
console.error(err);
}else {
console.log(result);
}
}); ``` In config object, you have to enter an input path. But If you don't want to output any file you can set to null.

License

MIT @chilijung