This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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.

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