Right, but you can't have 500 Columns in Excel. The max is like 255.
So while I think we should throw an exception (and hence THAT is a bug),
this is a limitation of what excel allows. (max col =IV)
-Andy
[EMAIL PROTECTED] wrote:
> 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]>
