Interesting. Very strange. Yes it is a big file. [EMAIL PROTECTED] wrote:
>Hi, > >I tried running the code, and it works fine for me. Quite a big file >though, as I had to increase the amount of memory available to the VM to >100Megs before it worked! > >I'm using POI 1.5.1 running on JDK 1.3.1 running on Windows 2000. I >opened your file using Excel 2000. > >Regards, > >-Jeff > >Now... If I can just figure out why I can't open an xls when the base >pre-extisting template file has Excel comments in one or more cells... > > > >>doesnt work >>can someone try my code to see if it comes from the code or from my >>software? >> >>Thanks >> >>-----Message d'origine----- >>De : Hilbe Stefan [mailto:[EMAIL PROTECTED]] >>Envoy� : jeudi 1 ao�t 2002 14:12 >>� : 'POI Users List' >>Objet : AW: Impossible to read the file created >> >> >>Hi >> >>try instead of >> >>moClasseur.write(new FileOutputStream("U:\\Test.xls"));} >> >>the following >> >>FileOutputStream fileOut = new FileOutputStream("U:\\Test.xls"); >>moClasseur.write(fileOut); >>fileOut.close(); >> >>I had the same problem. The file handle is not closed. >> >>-----Urspr�ngliche Nachricht----- >>Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >>Gesendet: Donnerstag, 1. August 2002 16:05 >>An: [EMAIL PROTECTED] >>Betreff: RE: Impossible to read the file created >> >> >>I use the 1.5.1 and see the source below >> >>HSSFWorkbook moClasseur = new HSSFWorkbook(); >>HSSFSheet moFeuille01 = moClasseur.createSheet("Essai Gd Fichier Feuille >>01"); >>HSSFSheet moFeuille02 = moClasseur.createSheet("Essai Gd Fichier Feuille >>02"); >> >>for(int i = 0; i < 3500;i++) >>{ >> for(int j=0;j<40;j++) >> { >> HSSFRow r = moFeuille01.createRow((short)i); >> HSSFCell c = r.createCell((short)j); >> c.setCellValue(i + " " + j); >> } >>} >>try{ >> moClasseur.write(new FileOutputStream("U:\\Test.xls"));} >>catch(Exception e) >>{} >> >> >> >>-----Message d'origine----- >>De : Andrew C. Oliver [mailto:[EMAIL PROTECTED]] >>Envoy� : jeudi 1 ao�t 2002 13:32 >>� : POI Users List >>Objet : Re: Impossible to read the file created >> >> >>Do you have the source used to generate the file? Secondly what version >> of HSSF? >> >>-Andy >> >>[EMAIL PROTECTED] wrote: >> >> >> >>> One topic has already set the problem but none has resolve it. In >>>fact, i >>>create one sheet with a lot of rows (for example 2000) and 40 columns >>>for each. I put not big data in cells, only 2 numbers. I run the >>>program and it goes fine even if it takes long to make the output file >>>(its size is about 4MB). The problem is coming when i want to open the >>>file. I can't open it. Excel 97 ( or 2000) tells me that " it is >>>impossible to read the file". >>> >>> >>Then >> >> >>>i try to open the file with OpenOffice. And I can read it! >>>I try again with less rows (1000) and it works on Excel. >>> >>>What is the problem? At first sight, it is not coming from HSSF but >>>from >>>Excel. If someone has ever had this problem, it would be nice to tell >>>me >>> >>> >>his >> >> >>>solution. >>> >>>Thanks >>> >>>-- >>>To unsubscribe, e-mail: >>><mailto:[EMAIL PROTECTED]> For additional >>>commands, e-mail: <mailto:[EMAIL PROTECTED]> >>> >>> >>> >>> >>> >>> >> >> >>-- >>To unsubscribe, e-mail: >><mailto:[EMAIL PROTECTED]> For additional >>commands, e-mail: <mailto:[EMAIL PROTECTED]> >> >>-- >>To unsubscribe, e-mail: >><mailto:[EMAIL PROTECTED]> For additional >>commands, e-mail: <mailto:[EMAIL PROTECTED]> >> >>-- >>To unsubscribe, e-mail: >><mailto:[EMAIL PROTECTED]> For additional >>commands, e-mail: <mailto:[EMAIL PROTECTED]> >> >>-- >>To unsubscribe, e-mail: >><mailto:[EMAIL PROTECTED]> For additional >>commands, e-mail: <mailto:[EMAIL PROTECTED]> >> >> > > > > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
