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