Two Laptop Bag*
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 Murach's Java Servlets and JSP this week in the Servlets 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: 41040
    
  43
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.
 
wood burning stoves
 
subject: POI excel rewrite file
 
Similar Threads
How tochange the values in an existing Excel file by using POI?
use Apache POI to read Excel file problem
an Exception report
Identifying in bold, italics, underline using POI
streaming excel files on ServletOutputStream