version control - How do I create a readable diff of two spreadsheets using git diff? -


we have lot of spreadsheets (xls) in our source code repository. these edited gnumeric or openoffice.org, , used populate databases unit testing dbunit. there no easy ways of doing diffs on xls files know of, , makes merging extremely tedious , error prone.

i've tried converting spreadsheets xml , doing regular diff, feels should last resort.

i'd perform diffing (and merging) git text files. how this, e.g. when issuing git diff?

we faced exact same issue in our co. our tests output excel workbooks. binary diff not option. rolled out our own simple command line tool. check out excelcompare project. infact allows automate our tests quite nicely. patches / feature requests quite welcome!


Comments

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

c++ - How do I get a multi line tooltip in MFC -

unit testing - How to mock PreferenceManager in Android? -