-
Notifications
You must be signed in to change notification settings - Fork 0
How to transform an Excel file into a JSON one?
Carlos GR edited this page Feb 14, 2019
·
5 revisions
- Install NodeJS so the npm executable is available in the console
- Open PowerShell or cmd.exe in Administrative mode
- Install Windows Build Tools for NodeJS (See https://github.com/felixrieseberg/windows-build-tools/issues/56 for more info), including python executable in the path
npm --add-python-to-path='true' --debug install --global windows-build-tools
- Install latest version of Libxmljs library
npm i libxmljs
- Install excel-as-json library
npm install excel-as-json --save-dev
- Change directory to the one where the file 'excel-to-json.js' is located together with data.xlsx
- Execute 'excel-to-json.js'
node .\excel-to-json.js
- If everything went well, you should now see as many .json files as sheets exist in the Excel file