aspose file tools*
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

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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.

subject: JExcel API clarifications
Similar Threads
Using JExcel API to create Excel sheet.
Problem with JExcel API
want to get more then 256 columns in XL using JXL API
usage of Range object from JXL api
How To compare two excel sheets using java