Hi Nikos. A) You use a template containing macros (i.e. opening it) and you write to your desired file. Your template is unchanged on disk and you've generated a new file containing macros. B) For comparison you've to normalize the contents somehow. Numbers e.g. are the same with or without leading zeros.
Regards, Karl-Heinz. Am Mi 21.12.2005 00:07 schrieb Nikos Tsakiropoulos <[EMAIL PROTECTED]>: > 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 compare the sheets in the workbook. > (How can I create Workbooks 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 > these 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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
