Simple .xlsx
(Excel 2007+) to .csv
, .json
, and .yaml
converter without
dependencies.
git clone https://github.com/nuno-andre/sheet-happens.git
cd sheet-happens
python setup.py install
$ sheet-happens <path-to-file> --csv --json
Output path is <file_path>/<file_stem>/<sheet_no>_<sheet_name>.<format>
from sheet_happens import Book
for sheet in Book(path):
print('Sheet:', sheet.name)
# print a dict {field:value} for each row
for row in sheet:
print(row)
If PyYAML
is available, Sheet Happens will add a --yaml
option.
Copyright © 2017-2021 Nuno André <mail@nunoand.re>