Excel2JSON
This repository contains a Node.js script that converts Excel files from the "Excel" folder into JSON format and saves the JSON output in the "JSON" folder.
Prerequisites
- Node.js installed on your machine
Getting Started
-
Clone this repository to your local machine or download the ZIP file.
-
Install the required dependencies by running the following command in your terminal:
npm install -
Place your Excel files inside the "Excel" folder.
-
Modify the script to suit your Excel structure and desired JSON output. Open
convert.jsand make necessary adjustments. -
Run the conversion script by executing the following command in your terminal:
node convert.js -
After running the script, you will find the generated JSON output files in the "JSON" folder.
Configuration
-
The script uses the
xlsxlibrary to read Excel files and thefs(file system) module to write JSON files. -
Modify the
excelFolderPathvariable inconvert.jsto specify the path to the "Excel" folder. -
Adjust the script in
convert.jsto match the structure and data of your Excel files.
Contributing
Contributions are welcome! If you have suggestions or improvements, feel free to create a pull request.
License
This project is licensed under the MIT License.