git_diff_xlsx's Introduction

git_diff_xlsx

This script parses an .xlsx file and converts it into a text format which can be compared using git.

I wrote this script as I wanted to use a version control package for managing an existing computational model, the input files of which are defined using Microsoft Excel workbooks.

See my blog entry for more details of how it works.

Installation

Download the latest release
Run python setup.py install
Add the following lines to the global .gitconfig file:

    [diff "git_diff_xlsx"]
    binary = True
    textconv = parse_xlsx
    cachetextconv = true

Add the following line to your repository's .gitattributes file *.xlsx diff=git_diff_xlsx
Now, typing git diff at the prompt will produce differences between text versions of Excel .xlsx files

Caveats

There are a bunch of issues with this script. I wrote it to fulfil a need I had then and there and there are lots of hard-coded horrors. Please feel free to contribute to cleaning up the code, submit issues and pull-requests.

git_diff_xlsx's People

Contributors

Stargazers

Watchers

git_diff_xlsx's Issues

Unzipped xml source remains in repos after running of diff script

Results of formulas that are strings do not print correctly

Enhanced display of non-ascii friendly content

Thanks for this useful script, I made the following change to add some robustness in handling non-ascii friendly content that may appear in the Excel files, such as curly quotes.

line 61:
output += unicodedata.normalize('NFKD', unicode(content)).encode('utf-8', 'ignore')

Sample output as follows:

 =================================
-Sheet: Sheet1[ 4 , 2 ]
+Sheet: Sheet1[ 5 , 5 ]
 =================================
     B3:
         Col1
     A4:
         Row1
     B4:
-        456.0
+        "456"
+    A5:
+        Row2
+    B5:
+        “test”
+    C5:
+        °C
+    D5:
+        ⛨
+    E5:
+        Ɛ

Recommend Projects