Doing a diff on a the xls will probabaly give u very little from a poi perspective.
There is an utility called BiffViewer (org.apache.poi.hssf.dev.BiffViewer) that displays the record structures for an xls file. Running that on the the two xls files and then doing a diff will tell you what is missing. Quoting "Riley, Cameron" <[EMAIL PROTECTED]>: > Hi, > > I have a project where we are outputting an invoice using POI from a > website. The users have asked for additional spreadsheet formatting such as > some sheets being landscape, sheets centered and sheet margins. I couldnt > find this functionality in the HSSF or HPSF API's. I also couldnt find > those > style(?)/settings(?) in the openoffice pdf. > > I generated two XLS files, one with one sheet and no data (13kb), and > another exactly the same except with landscape on (14kb). I diffed the two > files using, > > diff -a blank-landscape.xls blank.xls > > I got output alright, but am not sure the best way to use diff or to read > the output. Any tips or methods on isolating the changes between the two > files would be appreciated as I am not sure what I am or should be looking > for. > > > > Cameron Riley >
