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