Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JExcel API clarifications

 
lavanya Ananth
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic