Convert Excel Sheet into JSON file.
Project description
Excel to JSON Converter
A minimal API that downloads MS Excel (XLS + XLSX) file from a given URL and converts a given sheet into JSON file.
Contribution & License
You can contribute in following ways:
- Report bugs
- Add more "APIs"
- Give suggestions to make it better
- Fix issues & submit a pull request
Install
Using pipenv
(Recommended)
pipenv install excel2json-3
Using pip
pip install excel2json-3
Uses
Convert MS Excel File to JSON file
from excel2json import convert_from_file
EXCEL_FILE = '../example.xls' # or '../example.xlsx'
convert(EXCEL_FILE)
Convert to JSON file directly from URL
from excel2json import convert_from_url
EXCEL_FILE_URL = 'https://www.example.com/example.xlsx'
convert(EXCEL_FILE_URL)
Pre-requisites
- Python 3
Installation
Create Virtual Enviroment
Using pipenv
(Recommended)
-
Install pipenv
pip install pipenv
-
Create env
cd excel2json-3 # cd <repo_dir> pipenv --three install
-
Activate env
pipenv shell
-
Install requirements from Pipefile
pipenv sync
Using virtualenv
-
Install virtualenv
pip install virtualenv
-
Create virtualenv
mkdir myvenv cd myvenv virtualenv myvenv
-
Activate
myvenv
venvsource myvenv/bin/activate or . myvenv/bin/activate
-
Install from requirements.txt
pip install -r requirements.txt
Testing
```
pytest tests/test.py
```
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
excel2json-3-0.0.8.tar.gz
(2.9 kB
view hashes)
Built Distribution
Close
Hashes for excel2json_3-0.0.8-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 82757a7a8565a802e9d0ae299854a45d3ddcbd02aa2dcf823e00307122aa62ea |
|
MD5 | baf2774675bd88bb72ed6d105ae7bf04 |
|
BLAKE2b-256 | ab42e1c3390f503a4bda067a1fa53cad6b38767c83720571a5223f827a5c5908 |