wood burning stoves 2.0*
The moose likes Other Open Source Projects and the fly likes POI excel rewrite file 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 » Products » Other Open Source Projects
Bookmark "POI excel rewrite file" Watch "POI excel rewrite file" New topic
Author

POI excel rewrite file

zelynn goay
Ranch Hand

Joined: Jan 09, 2005
Posts: 30
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
Marshal

Joined: Mar 22, 2005
Posts: 41180
    
  45
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.


Ping & DNS - my free Android networking tools app
zelynn goay
Ranch Hand

Joined: Jan 09, 2005
Posts: 30
ok. thanks.
 
 
subject: POI excel rewrite file
 
Similar Threads
Identifying in bold, italics, underline using POI
How tochange the values in an existing Excel file by using POI?
streaming excel files on ServletOutputStream
use Apache POI to read Excel file problem
an Exception report