File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other JSE/JEE APIs and the fly likes JExcel API clarifications Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Bookmark "JExcel API clarifications" Watch "JExcel API clarifications" New topic

JExcel API clarifications

lavanya Ananth
Ranch Hand

Joined: Apr 04, 2005
Posts: 40
Hi ,

I am using JExcel API and i am having a few problems. I need to merge 4 excelsheets with an existing excel sheet using a Java program.

I basically read one row at a time from the excel sheet and find a match with the main excel sheet until all end of rows.

Once i find my match,I get the rownumber. Now i create a copy of the main one (ritable workbook) and update that sheet using addCell method.

here's my problem. If i follow my write() statements with a close(), I have no two problems,how do i get back the same file for further modifications?

If i do not close, I do not see any changes at all.I just have a copy of the mail one.

Please suggest workarounds.

I agree. Here's the link:
subject: JExcel API clarifications
It's not a secret anymore!