• Post Reply Bookmark Topic Watch Topic
  • New Topic

JExcel API clarifications  RSS feed

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.

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!