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.0.9.tar.gz
(2.9 kB
view hashes)
Built Distribution
Close
Hashes for excel2json_3-0.0.9-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6bf34720761efe3e90a042e0ebc109f7e15fbfef1f44571d0ff8ed6ffba3f6c6 |
|
MD5 | 1a074c4a3050a97841ae2c9040eb7e1b |
|
BLAKE2b-256 | 63290548f2ca5f3355c60b37bcdeedd4957b53aefc4a07ebc7a88b0230311f82 |