- #Spreadsheet compare on microsoft excel for mac full
- #Spreadsheet compare on microsoft excel for mac windows 10
Let’s see what exactly changed: git diff Book1.xlsx. Open Book1.xlsx in Excel, do some edits and hit Save.Ī git status should now show that Book1.xlsx has been modified.
#Spreadsheet compare on microsoft excel for mac full
git/config (Step 2) and specify the full path to xldiff.bat inside your repository Ensure the path inside xldiff.bat points to Spreadsheet Compare (Step 1).The repository comes with xldiff.bat and the workbook Book1.xlsx. You can find a simple repository which might be useful getting up and running in a minute. Here, we instruct Git to use the “excel” differ for any file names matching the *.xls* pattern (feel free to refine the wildcard pattern). Make sure xldiff.bat is available globally on your computer (for instance, C:\Developer\xldiff.bat is a good choice). Spreadsheet Compare accepts only a single argument: The path to a text file which itself contains the paths to the two workbooks to be compared.Ĭreate the batch file xldiff.bat to transform the git diff argument into the text file that Spreadsheet Compare expects to invoke the application. Git diff passes seven arguments: path, old-file, old-hex, old-mode, new-file, new-hex, new-mode. We cannot call Spreadsheet Compare directly because the git diff command passes arguments that are incompatible with Spreadsheet Compare. We want to configure Git such that git diff invokes Spreadsheet Compare whenever is an Excel workbook. In order to use Spreadsheet Compare as a Git differ, we need to be able to run it programmatically from the command line.
#Spreadsheet compare on microsoft excel for mac windows 10
For example, on Windows 10 and Office 2016 (32-bit), it can be found in C:\Program Files (x86)\Microsoft Office\root\Office16\DCF. Spreadsheet Compare is a stand-alone desktop application that lets us compare two Excel workbooks and create a report of the differences.ĭepending on your Windows and Office versions, Spreadsheet Compare is located somewhere in the \Program Files\Microsoft Office\ folder. Spreadsheet Compare has been part of Office Professional Plus since version 2013 and is also shipped with Office 365 ProPlus. In this blog post, we hook up Microsoft Office’s Spreadsheet Compare to git diff to create meaningful workbook comparisons. This means they cannot be diffed via git diff. For Git, Excel workbooks are just binary files.