Metadata-Version: 2.1
Name: py-xlsx-textconv
Version: 0.0.2
Summary: Git textconv tool for excel
Home-page: https://github.com/tiibun/py-xlsx-textconv
Author: IIBUN Toshiyuki
Author-email: toshiyuki.iibun@gmail.com
License: UNKNOWN
Project-URL: Bug Tracker, https://github.com/tiibun/py-xlsx-textconv/issues
Platform: UNKNOWN
Classifier: Development Status :: 3 - Alpha
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.6
Classifier: Programming Language :: Python :: 3.7
Classifier: Programming Language :: Python :: 3.8
Classifier: Programming Language :: Python :: 3.9
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.6
Description-Content-Type: text/markdown
Requires-Dist: openpyxl (==3.0.*)
Provides-Extra: dev
Requires-Dist: pytest (==6.*) ; extra == 'dev'
Requires-Dist: build ; extra == 'dev'
Requires-Dist: twine ; extra == 'dev'
Requires-Dist: tox ; extra == 'dev'
Requires-Dist: yapf ; extra == 'dev'

# py_xlsx_textconv

Excel to text covert tool for Git.
This is a python port of [git-xlsx-textconv](https://github.com/tokuhirom/git-xlsx-textconv)

When git diff or git log -p, extract cell values in excel and format:

```
[SheetName1][TAB][A1][TAB][B1][TAB][C1][TAB]...
[SheetName1][TAB][A2][TAB][B2][TAB][C2][TAB]...
```

and compare text formats.

Example: Excel
![excel](https://raw.githubusercontent.com/tiibun/py-xlsx-textconv/main/excel.png)

git diif
![git diff](https://raw.githubusercontent.com/tiibun/py-xlsx-textconv/main/diff.png)

## This does not compare

- Style
- Auto Shapes
- ... and so on

## Install 

```
pip install py-xlsx-textconv
```

## Configuration

If `~/.config/git/attributes` does not exist, you need to creat and edit it.

```:~/.config/git/attributes
.xlsx diff=xlsx
.xlsm diff=xlsx
```

Or if you prefered per project attribute file, create `.gitattributes` file and edit it above

Append to `~/.gitconfig`.

```:~/.gitconfig
[diff "xlsx"]
    binary = true
    textconv = py-xlsx-textconv
```

## Development

```
git clone https://github.com/tiibun/py-xlsx-textconv.git
cd py-xlsx-textconv
# virtual env
python -m venv env
. ./env/Scripts/activate
# install editable
pip install -e .
...develop
# package
rm -rf dist/*
python -m build
# upload
twine upload dist/*
```

## LICENSE

MIT


