This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin in Action and have Dmitry Jemerov & Svetlana Isakova on-line!
See this thread for details.
Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

POI excel rewrite file  RSS feed

 
zelynn goay
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I would like to write to an existing excel file using POI. I added a clause to check if file doesn't exist, create a new excel, or if exist, create a new worksheet.
when i execute the program, i can the see a new excel file being created. when i execute again, i see the file size increase . but when i open up the excel file, i couldn't see any added changes. after i close the excel file, the file size decrease.

Please help.


[ August 12, 2008: Message edited by: zelynn goay ]
[ August 12, 2008: Message edited by: zelynn goay ]
 
Ulf Dittmer
Rancher
Posts: 42972
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's probably not a good idea to write to a file while it's still open for reading. Try closing the input file first, and then writing to it.
 
zelynn goay
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ok. thanks.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!