py-xlsx-textconv 0.0.2

Git textconv tool for excel

py_xlsx_textconv

Excel to text covert tool for Git. This is a python port of 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

git diif

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.

.xlsx diff=xlsx
.xlsm diff=xlsx

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

Append to ~/.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