This is a tool to generate an excel file based on a provided source excel and transformation mapping
Project description
excel-transform
Installation
Make sure you are using python 3.8+.
λ python --version
Python 3.8.8
Create a virtual environment in the desired directory.
λ mkdir ~/excel-transform
λ cd ~/excel-transform
λ python -m venv venv
Activate the virtual environment and install dependencies.
Windows:
λ venv\Scripts\activate.bat
Unix/Linux:
λ source venv/bin/activate
Install Option 1 (Recommended):
(venv) λ pip install excel-transform
Install Option 2:
Install from source via github
(venv) λ pip install git+https://github.com/adrian549092/excel-transform.git@master
Create template mapping file
Run this command to generate the skeleton of a mapping file
(venv) λ excel-transform mapping-skeleton -o some_mapping.json
Transform Spreadsheet
Transform a spreadsheet
(venv) λ excel-transform transform -o transformed.xlsx some_spreadsheet.xlsx mapping.json
Transform GUI
Launch available PYQT5 GUI
(venv) λ excel-transform gui
Get Help
Use the --help
flag anywhere along the excel-transform
commands to get context aware help
(venv) λ excel-transform --help
(venv) λ excel-transform transform --help
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
excel_transform-1.1.4.tar.gz
(9.3 kB
view hashes)
Built Distribution
Close
Hashes for excel_transform-1.1.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b495f7245747e6dba2b74595518728cf7b83567d3a4ef1ccc4ee68db7d235446 |
|
MD5 | da7d2bd0714d6288cbd7bb6603413627 |
|
BLAKE2b-256 | 61958f55e8782f5912863180d1633566d61df353aaefbf0e4781d27fd352e360 |