Skip to content

Latest commit

 

History

History
24 lines (13 loc) · 740 Bytes

README.md

File metadata and controls

24 lines (13 loc) · 740 Bytes
Raw

xlsx-to-json

Using Python, convert an Excel (xlsx or xls) document to JSON

dependencies

  • pylightxl
  • xlrd

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

Usage

  • Run the command python3 xlstojson.py in your terminal/command window
  • Do what the prompt says (which is enter the path to the file)

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

Caveats and Whatnots

I wrote this six years ago; it was the first thing I'd ever written in Python. This code was written about as well as a non-Python programmer programming Python could write it.

I have made attempts to improve it, but I may still not know what I'm doing