True, my code did contain one string. However, I have tested the code for numbers as
well. The code fails if I repeat the same number in every cell and also if I use
different numbers in every cell.
I have pasted my code below.
Kind Regards,
Nitin
import org.apache.poi.hssf.usermodel.*;
import java.io.*;
import java.util.*;
public class test
{
public static void main(String args[]) throws Throwable
{
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet1 = wb.createSheet("new sheet");
for (short index = 0; index < 600; index ++)
{
HSSFRow row = sheet1.createRow(index);
for (short index2 = 0; index2 < 500; index2++)
{
row.createCell(index2).setCellValue(((int)index)*((int)index2));
}//end for (index2)
}//end for (index)
FileOutputStream fileOut = new FileOutputStream("workbook2.xls");
wb.write(fileOut);
fileOut.close();
}//end main
}//end class
-----Original Message-----
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: 01 August 2002 16:20
To: POI Users List
Subject: Re: MEGA SST Record (was: Re: Impossible to read the file
created)(GLENPLEASE READ)
IIRC, Yours also contained a large number of strings. I was not able to
determine the problem from the sample. (Sometimes it takes a couple
samples before we can catch a thing like this).
-Andy
[EMAIL PROTECTED] wrote:
>I reported the same error on this list a month ago (1st July 2002). I have also
>logged it into bugzilla (id = 10393). No one has got back to me yet but it seems
>that this is not a one off result.
>
>
>Thanks,
>
>Nitin
>
>
>
>-----Original Message-----
>From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
>Sent: 01 August 2002 14:51
>To: POI Users List; Marc Johnson; [EMAIL PROTECTED]
>Subject: MEGA SST Record (was: Re: Impossible to read the file created)
>(GLENPLEASE READ)
>
>
>Confirmed. This generates an invalid spreadsheet. It generates a LOT
>of unique strings, which looks like
>it generates a symantically valid but obviously not valid enough SST
>record. There are 160 continue records
>for the SST table. That is a LOT of continue records.
>
>Anyone here a VB or VBA whiz? Can someone write a spreadsheet with the
>SAME data using VB/OLE 2 Automation so we can see what Excel does with
>160 Continue records. This might be the mysterious EXTSST record that
>both we don't mess
>with yet. I may try to open this with and save this with staroffice and
>see if we can read the star office version (along with excel). I'm
>betting (since they don't handle EXTSST either) that Star/OpenOffice
>generates an invalid sheet as well.
>
>Submitter, while we do need to fix this, its unlikely a real spreadsheet
>would have this many strings in it. Generally spreadsheets would have
>more numbers than strings (you have NO numeric cells and WAY more
>strings than any real spreadsheet I've seen).
>
>Thanks for reporting this,
>
>-Andy
>
>PS: attached is a compilable source that generates the invalid output
>
>[EMAIL PROTECTED] wrote:
>
>
>
>>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]>
>>
>>
>>
>>
>>
>>
>
>
>
>Visit our website at http://www.ubswarburg.com
>
>This message contains confidential information and is intended only
>for the individual named. If you are not the named addressee you
>should not disseminate, distribute or copy this e-mail. Please
>notify the sender immediately by e-mail if you have received this
>e-mail by mistake and delete this e-mail from your system.
>
>E-mail transmission cannot be guaranteed to be secure or error-free
>as information could be intercepted, corrupted, lost, destroyed,
>arrive late or incomplete, or contain viruses. The sender therefore
>does not accept liability for any errors or omissions in the contents
>of this message which arise as a result of e-mail transmission. If
>verification is required please request a hard-copy version. This
>message is provided for informational purposes and should not be
>construed as a solicitation or offer to buy or sell any securities or
>related financial instruments.
>
>
>--
>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]>
Visit our website at http://www.ubswarburg.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed,
arrive late or incomplete, or contain viruses. The sender therefore
does not accept liability for any errors or omissions in the contents
of this message which arise as a result of e-mail transmission. If
verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities or
related financial instruments.
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
