Seamless convert xlsx to json with optional option to lowerCase the excel headers (Credits rahil471/node-xlsx-json library)
npm install node-xlsx-parserConverting xlsx file to json or csv files using nodejs.
Long story short, our commercial project needed lightweight,
pretty simple and up-to-date tool for converting btw XLSX/CSV/JSON.
So, came here to share it with you guys.
npm install node-xlsx-parser
`
$3
`
yarn add node-xlsx-parser
`
Usage
`javascript
XLSXParser = require("xlsx-to-json"); const jsonFromXLSX = new XLSXParser()
.xlsx_to_json(
input, // file/blob/base64/string/array/buffer as xlsx to convert to json
options // options from require('xlsx').xlsx_to_json()
);
const csvFromXLSX = new XLSXParser()
.xlsx_to_csv(
input, // file/blob/base64/string/array/buffer as xlsx to convert to json
options // options from require('xlsx').xlsx_to_csv()
);
const jsonFromCSV = new XLSXParser()
.csv_to_json(
input, // file/blob/path as xlsx to convert to json
options // options from require('xlsx').xlsx_to_csv()
);
const CSVFromJSON = new XLSXParser()
.json_to_csv(
input, // JSON/JSONB file with object for translate to CSV
options // options from require('xlsx').json_to_csv()
)
const {
result: string, // csv or json formatted string
error: string, // reason of the failure
} = jsonFromXLSX || csvFromXLSX || jsonFromCSV;
`Thoughts
Feel free guys, to share you PRs to
develop` branch with some proposals. I will greetely review all of them as soon as I can for sure)MIT @dkfl1995