POI jar compatibility issue

Hi all,

               I was held up with some task to do on Excel file in Java. I finally decide to work out with the third party jar file POI. Well this is a product of Apache. 

What i have to do with POI ?

              I have to read through excel file and update excel file when fetched with the cell value to be replaced. I done with all the implementation work and uploaded the same on the server. I do have Microsoft office 2003 installed on my computer. I tested well with the excel file created on Microsoft office 2003  and also with the excel file created using Open Office. A few days later, a client reported an issue stating that the excel file reading and updating the excel file is not working. I then collected the logs from him and surprised to see that the excel file created using excel file on Microsoft office 2007 will not work with POI jar as the data reading mechanism is different from the predecessor. I soon realised that testing is a vital thing, before shipping the product. Though certain things cannot be avoided, it is quite a learning experience. I love to make such faults in my working environment.

 

Comments are Welcomed….!