Re: compare Excel files on the fly

2005-12-21 Thread Karl-Heinz Zengerle
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 leadin

compare Excel files on the fly

2005-12-20 Thread Nikos Tsakiropoulos
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

compare Excel files on the fly

2005-12-20 Thread Nikos Tsakiropoulos
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