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….!
2 Comments »
Leave a comment
TechNewsLetter- Nokia acquires social media sharing site ‘Twango’ July 25, 2007Nokia’s acquisition of social media sharing website Twango, marks another milestone in the handset majors move to capitalize on the proliferation of media on the web. Already, the N series phones have been branded as Multimedia PCs. This latest move provides more impetus to on the move anytime, anywhere computing. Read more [...]technewsletter
- Use firewall for your security July 11, 2007If you always connected to the internet to help you find something or for your work, or for just browsing, it’s highly recommend to always activate your firewall, especialy if you running windows XP and don’t third-party firewall software. And if you don’t know what is firewall, firewall is a hardware or software device which [...]technewsletter
- Thierry Henry moving from Arsenal to Barcelona July 11, 2007Huge move in the world of soccer. Spanish papers as well as Sky Sports are reporting this. Seems like a done deal if true, albeit one that’s been rumored for a while now. read more | digg storytechnewsletter
- Nokia acquires social media sharing site ‘Twango’ July 25, 2007
-
Archives
- August 2009 (1)
- June 2009 (1)
- April 2009 (4)
- November 2008 (1)
- October 2008 (3)
- March 2008 (1)
- September 2007 (1)
- August 2007 (5)
- July 2007 (21)
-
Categories
-
RSS
Entries RSS
Comments RSS
Am facing the same issue. How did you solve the problem. Am using AbstractExcelView from Spring framework to generate the excel.
To get the customized file name I added the line response.setHeader(“Content-disposition”, “attachment; filename=\”test.xls\”");
Arjun, we can save the Excel file with extension xls and not as xlsx in Office 2007. If then, you can use these jar with no problem.