Hi All I have discover POI due to an Oracle article: http://www.oracle.com/technology/pub/articles/saternos_broadcast.html
After using the examples I found it extremely interesting. The article describes the procedure of configuring the XML file and runing an SQL code to multiple Databases. Then bringing the results in an excel file in different sheets for every DB. However I'm currently looking in a way to compare these excel sheets and see the differences highlighted in the files generated by POI. Therefore having ready the comparison of data comming back from the DBs and not having to compare them manually. Can you please advise if this is possible? A) Embed macros that comare the sheets in the workbook. (How can I create Workboos with POI with embeded Macros?) B) Somehow compare the sheets with Java(POI). (I found some packages that can do something like this but I see that this exists for hpsf format in the following link : http://jakarta.apache.org/poi/apidocs/index.html, in examples category. Nothing like this exists for hssf format.) Can you please provide some feedback, help on the above? Thanks very much in advance for your help. -- Nikolaos Tsakiropoulos
