Re:ExcelCompare: Command line tool and API for diffing Excel...
by sha1-1b141e on Monday May 09, 2016 @08:03PM
(#11664282)
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?
[ Parent
| on HN ]
Re:ExcelCompare: Command line tool and API for diffing Excel...
by jkaptur on Monday May 09, 2016 @08:31PM
(#11664400)
It looks like the Apache POI library gets the data out of the formats. The tool itself seems to compare the data cell-wise (i.e. A1 against A1 - no alignment seems to be attempted) and there doesn't seem to be any handling for merged cells, charts, pivot tables, filters, data validation, etc.