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
Installation
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)
DEVELOPEMENT
Pre-requisites
- Python 3
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.1.0.tar.gz
(2.9 kB
view hashes)
Built Distribution
Close
Hashes for excel2json_3-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ef79adbcd7894c90403c9918a9a4463fa4623f177587709abb8fc5bdd5645ddb |
|
MD5 | aeb8fb431942de1b5adcb4e31db92e66 |
|
BLAKE2b-256 | 15db7af238d630f45a9832f4e985647e6cf352454e1df2dedc2ea149c8157ed7 |