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.js
and 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
xlsx
library to read Excel files and thefs
(file system) module to write JSON files. -
Modify the
excelFolderPath
variable inconvert.js
to specify the path to the "Excel" folder. -
Adjust the script in
convert.js
to 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.