py-xlsx-textconv 0.0.6

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 diff

And experimental VBA support. (v0.0.4)

This does not compare

• Style
• Auto Shapes
• ... and so on

Install

pip install py-xlsx-textconv

Configuration

If ~/.config/git/attributes (Windows: %HOMEPATH%.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 (Windows: %HOMEPATH%.gitconfig).

[diff "xlsx"]
    binary = true
    textconv = py-xlsx-textconv

If you would like to compare values only, append -d option.

[diff "xlsx"]
    binary = true
    textconv = py-xlsx-textconv -d

Development

Install pdm.

# install dependencies
pdm sync -d

# test
pdm run test

LICENSE

MIT