Compare Excel files with Git versioning using by default Microsoft SPREADSHEETCOMPARE tool
This simple batch script will help you to setup excel comparison using git diff commands
It will help a lot to everyone using Excel files in git repository.
To Do:-
- Simply clone our repository
- Run the "setupExcelCompareGit.bat" file by double clicking it, not as admin. Remember run it once only as it is system-wide setting
- Run "gitExcelInject.bat" for each project you want the gitExcel to work as it modifies .gitattributes file
- Open git console and type "git diff [Excel File Name]/hash hash", you will see SPREADSHEETCOMPARE tool opening with two excel files. I mean use git diff with its standard syntax
====================================Enjoy=================================================