Hi All, Thanks for your attempt to help me.
David, I have tried with POI3 RC1, it gives the same problem. I have attached the generated excel, I agree that, its veri complicated excel cross referencing between sheets. Don't know if that is the cause. Marian, the sheet does exist. Any of your further is greatly appreciated.. Regards, Davis David Fisher <[EMAIL PROTECTED]> 03/15/2007 08:32 PM Please respond to "POI Users List" <[email protected]> To "POI Users List" <[email protected]> cc Subject Re: Unable to open created excel file Try POI3 RC1. On Mar 15, 2007, at 7:10 AM, Simone Caldon wrote: > 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/ > > --------------------------------------------------------------------- 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/
