ciatphdev/json-to-excel repository overview

⁠json-to-excel

Node script that exports historical 10-day weather forecast JSON data to Excel files.

GitHub Repository
https://github.com/ciatph/json-to-excel⁠

⁠Usage

1. Pull the "latest" Docker image.
   docker pull ciatphdev/json-to-excel

2. Put the weather forecast data JSON files inside a target director, for example, the /data directory.

   • INFO: These files should follow uniform data and structure, following the TendayHistoricalItem TS type or the TendayHistoricalItemSchema zod schema.
   • View the /data/samples/sample_response.json⁠ file and the Data Description⁠ section for more information about its structure and format.

   .
   ├─ my-project-directory
   │   ├─ data
   │   ├─── data_01.json
   │   ├─── data_02.json
   │   ├─── data_03.json
   │   ├─── ...
   │   ├─ output
   │   ├─── ...
   

   Copy

3. Run the export script. This command binds volume mounts from the host to Docker. The /data directory contains the input JSON files from step #2. The script will generate Excel files under the /output directory.

   # On Linux OS
   docker run -it --rm -v $(pwd)/data:/opt/app/data -v $(pwd)/output:/opt/app/output ciatphdev/json-to-excel  
   
   # On Windows OS (Command Prompt)
   docker run -it --rm -v %cd%\data:/opt/app/data -v %cd%\output:/opt/app/output ciatphdev/json-to-excel
   

   Copy