Oh no Marian, in case of complicated excel file POI outputs corrupted files, there's some bug reported in bugzilla...
Marian Roman wrote:
Hi Davies,

I see no errors in Your code, I tried it, there can be a problem only if You
want to remove a non-existing sheet, You get
java.lang.IndexOutOfBoundsException.

Marian

On 3/15/07, Davis Varkey Koottala <[EMAIL PROTECTED]> wrote:

Hi All,

I am unable to open the excel file which is created programatically. This
is what I am doing :

fileIn = new FileInputStream("test.xls");
POIFSFileSystem fs = new POIFSFileSystem(fileIn);

HSSFWorkbook test = new HSSFWorkbook(fs);
test.removeSheetAt(2);

fileOut = new FileOutputStream("D:\\Workshop\\poi\\excel
Utility\\workbookout.xls");
test.write(fileOut);

After writing the file, when I open it, it just open the file poping up
the microsoft standard error dialog.

Your help is much appreciated.

Regards,
Davis




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

Reply via email to