A node based approach to transform XLSX file into JSON.
First of all install npm packages.
npm install
Below command can be use to convert test.xlsx
file to result.json
as output.
node xlsxtojson
Optional arguments can be provided as:
node xlsxtojson --src=test2.XLSX --dest=test.json --sheet=Sheet2
--src=xlsxfilename
: Source xlsx file name, if not provided default will betest.xlsx
.--dest=jsonfilename
: destinatoin json file name, if not provided default will beresult.json
.--sheet=sheetname
: name of sheet in excel file, if not provided entore excel file will be transformed to json.