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.
[ August 12, 2008: Message edited by: zelynn goay ] [ August 12, 2008: Message edited by: zelynn goay ]
posted 7 years ago
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.