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]>
