Our most popular open-source project is clearly xlwings, an Excel add-in that allows you to write user defined functions and macros in Python instead of VBA.
Like many open-source projects, xlwings’ source code is hosted on GitHub which works great for the Python code but doesn’t really give you anything for binary files like Excel workbooks:
For the longest time, when developing the add-in, we were exporting the VBA modules and then committing these text files
to Git alongside the
xlwings.xlam file. There must be an easier way.
xltrail syncs with your Git repository (all providers are supported) and gives you a detailed view of the workbook’s contents:
By clicking on one of the VBA modules, you can look at the changes from one commit to the other:
xltrail also shows changes in worksheets/cells: this screenshot shows the Fibonacci example:
Curious? Try it out yourself: