I work at a certain custodial bank and it's scary just how much of our business depends on Excel VBA. Something like this would be amazing as we have virtually no SCM / revision control for our critical spreadsheets.<p>Does anyone else know of any neat "can't-live-without" Excel utilities or add-ons that would make a software engineer's life a lot easier? A few weeks back someone posted ThingieQuery[0], which also looks fantastic. The IDE for VBA is awful, and I'll take any improvement I can get.<p>[0]: <a href="https://news.ycombinator.com/item?id=11583488" rel="nofollow">https://news.ycombinator.com/item?id=11583488</a>
It's interesting to see this written in Java, since the Excel application can be reached as a .NET object[0]. On top of that, Compare-Object is a built-in function for Powershell. Sure, with this built in Java you can use it to diff Excel spreadsheets on CentOS, but how often do you have those there? But in .NET most of the pieces are probably already there, so less work may have been needed to produce the same tool.<p>[0] <a href="http://www.madwithpowershell.com/2013/11/using-excel-functions-in-powershell.html" rel="nofollow">http://www.madwithpowershell.com/2013/11/using-excel-functio...</a>
Microsoft finally added the ability to compare two workbooks in Excel 2013:<p><a href="https://support.office.com/en-us/article/Basic-tasks-in-Spreadsheet-Compare-f2b20af8-a6d3-4780-8011-f15b3229f5d8" rel="nofollow">https://support.office.com/en-us/article/Basic-tasks-in-Spre...</a><p>Not a command line tool, and no API, but they delivered the basic feature. As far as I can tell, it isn't used very much.
Good strategy is to move all data transformation into Excel add-in Power Query and leave raw data in original format. No more copy/ paste of data. "Fat finger" events are minimized. Using PQ gets you moving towards more robust business process, data management and IT architecture.
OOC, how much of the complexity for implementing this was getting the data out of the formats, and how much was implementing the diff once you had the data?
They should add this to Diffoscope <<a href="https://diffoscope.org/>" rel="nofollow">https://diffoscope.org/></a>.