Using Python, convert an Excel document to JSON
Clone or download
paceaux Merge pull request #2 from skohli0302/date-values
script now understands date values
Latest commit 46beaf5 Oct 30, 2017
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
LICENSE Initial commit Aug 29, 2016
README.md updates readme with pre-emptive request for forgiveness Aug 29, 2016
requirements.txt script now understands date values Sep 9, 2017
xlstojson.py sheet data is in lower case Oct 3, 2017

README.md

xlsx-to-json

Using Python, convert an Excel document to JSON

dependencies

  • xlrd
  • xlwt

you can run pip install xlrd in your terminal/command window if you don't have these dependencies installed

Usage

  • Run the command python xslx-to-json.py in your terminal/command window
  • Do what the prompt says

A .json file matching the name of your xlsx document will be generated.

Caveats and Whatnots

I'm not a Python Programmer. The code is written about as well as a non-Python programmer programming Python could write it.

Forgive me, I don't know what I'm doing