November 15, 2018
5 tools to compare Excel files
September 03, 2018
Comparing text files is easy, but comparing Excel files not so much. The fact that Excel is a two dimensional grid with formulas that contain relative cell references makes it quite a challenge. Accordingly, there are only a few tools available that claim to do the job. Let’s see what our options are! In the first part of the post,...
Find spreadsheet errors faster with xltrail
August 02, 2018
Holiday season in Europe and North America is coming to an end.
If you’ve been out of the office for a week or two and that business-
critical Excel workbook throws an error in your face right on your first day back,
you want to know as quickly as possible what has changed in your absence.
DevelopExcel Conference in London
May 28, 2018
The DevelopExcel conference will take place in London on Thursday, 18 October 2018. It will be held at the Microsoft Reactor (70 Wilson Street London EC2A 2DB). DevelopExcel gives you a unique community event to meet and learn from the developers of the major Excel extension technologies.
How to git-merge Excel VBA code
April 10, 2018
xltrail client is a free, open-source Git command line extension for managing Excel workbook files in Git. The xltrail client makes git diff and git merge work for Excel workbooks file formats. It works directly on the workbook file and does not require Excel.
Make Git Tower work with Spreadsheet Compare
March 23, 2018
Git Tower is a graphical user interface-based Git client and an interesting alternative to the command line. Git Tower is very customisable to your individual needs; it supports a set of third party diff tools (such as Beyond Compare) out of the box but you can also make it work with literally any diff tool. This makes Git Tower an...
Git-xltrail: An open-source Git command-line extension for Excel files
January 26, 2018
Git can be tweaked to make it play nicely with Excel workbook files (that is, to be able to show diffs). Pre-commit hoooks can be set-up to automatically export the workbook’s VBA code as stand-alone .bas files on each commit. And Microsoft’s Spreadsheet Compare can be used as a custom differ for Excel workbook file changes.
Quick Guide: Git Large File Storage (LFS) for Excel
As a distributed version control system, Git always copies down the entire repository history to the client when you do a git clone or git fetch. For repositories containing large files and/or long commit histories, this clone process can take a long time, as every file version that ever existed has to be downloaded.