Register / Login
File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
Other JSE/JEE APIs
JExcel API clarifications
posted 10 years ago
I am using JExcel API and i am having a few problems. I need to merge 4 excelsheets with an existing
sheet using a
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.
It is sorta covered in the
JavaRanch Style Guide
Problem with JExcel API
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.
How To compare two excel sheets using java