Reputation: 75
Is there a good way to track changes in Excel sheets in GIT repo?
I have tried the solutions provided in How to perform better document version control on Excel files and SQL schema files, but I was unable to find a good solution for unzip the files to see the changes which can be tracked by Git. I have been using Git for a while and wanted to know if there is a good and fairly simple way to tracks the changes being made. Excel is being used in JAVA framework.
Upvotes: 6
Views: 2612
Answers (1)
Reputation: 7070
You can use Git hooks with a little help of something like Python to automatically export your VBA code and track it with Git. For a detailed walk-through, see this blog post.
Nowadays you can also use the open-source Git extension Git XL that allows you to see the diffs on the command line. It also integrates with Atlassian's free SourceTree tool, see this blog post for a detailed walk through on how to set everything up.
Upvotes: 4
Related Questions
- How do I create a readable diff of two spreadsheets using git diff?
- How do I use git extensions to view an old version of an Excel file from it's history
- Is it possible to use git for tracking changes without storing them?
- Tracking Excel files in Version Control
- What is the best way to version control a Google sheet using Github?
- How to track all file changes in Git for auditing purposes
- Save versions of Excel file on Git to reconcile differences manually later
- Git in excel or numbers
- Tracking changed files with git without saving changes
- how to track changes before commiting in git