wood burning stoves 2.0*
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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Bookmark "JExcel API clarifications" Watch "JExcel API clarifications" New topic
Author

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.

Thanks
Lavanya
 
It is sorta covered in the JavaRanch Style Guide.
 
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