Metadata-Version: 2.1
Name: excel-transform
Version: 1.1.4
Summary: This is a tool to generate an excel file based on a provided source excel and transformation mapping
Home-page: https://github.com/adrian549092/excel_transform
Author: Adrian Martin
Author-email: adrian.m138@gmail.com
License: MIT
Platform: any
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 3.8
Requires-Python: >=3.8
Description-Content-Type: text/markdown
Requires-Dist: click (~=7.1.2)
Requires-Dist: humanfriendly (~=9.1)
Requires-Dist: openpyxl (~=3.0.6)
Requires-Dist: pandas (~=1.2.2)
Requires-Dist: setuptools (~=54.1.2)
Requires-Dist: PyQt5 (~=5.15.2)

# excel-transform

![PyPI - Python Version](https://img.shields.io/pypi/pyversions/excel-transform.svg)
[![PyPI](https://img.shields.io/pypi/v/excel-transform.svg)](https://pypi.python.org/pypi/netmiko)
[![Downloads](https://pepy.tech/badge/excel-transform)](https://pepy.tech/project/excel-transform)
![GitHub contributors](https://img.shields.io/github/contributors/adrian549092/excel-transform.svg)

### Installation
Make sure you are using [python](https://www.python.org/downloads/) 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
```


