Hi Troy. POI reads real Excel file (as it just simulates to be Excel - just producing the same structures on disk). Excel itself implicitly converts text files and afterwards you might save them as Excel files.
Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: Troy McKinnon [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 23. Juni 2004 01:11 An: POI Users List Betreff: Re: Unable to read entire header It appears I was mislead by TextPad :( The file is actually plain text. And hence the error in reading it. On the bright side, I got to learn POI which will be useful for an upcoming feature set. Just a note: I included a screen shot of the sample file opened in Textpad. (Had to prove I wasn't crazy ) Thanks all, and sorry for the waste of time. Troy ----- Original Message ----- From: "Ryan Ackley" <[EMAIL PROTECTED]> To: "POI Users List" <[EMAIL PROTECTED]> Sent: Tuesday, June 22, 2004 2:13 PM Subject: Re: Unable to read entire header > Err..This is a tab delimited file(100% pure ASCII text). You don't need POI > for this, just use java.io.InputStreamReader. > > -Ryan > > > ----- Original Message ----- > From: "Troy McKinnon" <[EMAIL PROTECTED]> > To: "POI Users List" <[EMAIL PROTECTED]> > Sent: Tuesday, June 22, 2004 4:44 PM > Subject: Re: Unable to read entire header > > > > Example attached > > > > Troy > > > > ----- Original Message ----- > > From: "Noah Campbell" <[EMAIL PROTECTED]> > > To: "POI Users List" <[EMAIL PROTECTED]> > > Sent: Tuesday, June 22, 2004 1:18 PM > > Subject: Re: Unable to read entire header > > > > > > Is this on every single document you download? > > > > Try opening up with POIFSFileSystem first. If POIFSFileSystem works > > then check to see in the internal structure is in tack. (off the top > > of my head I can't recall) but you're looking for a POIFSDocument that > > called Book (95). > > > > I found using a debugger really helpful. Just break after you've > > created the POIFSFileSystem and start picking through the content. > > > > Keep in mind that brute force won't get you anywhere because of the > > internal binary file structure. Can you post an example excel > > spreadsheet? > > > > HTH, > > Noah > > > > On Tue, 22 Jun 2004 12:19:12 -0700, Troy McKinnon > > <[EMAIL PROTECTED]> wrote: > > > > > > I tried JExcelAPI but it returns: > > > > > > jxl.read.biff.BiffException: Unable to recognize OLE stream > > > > > > I am getting a bit desperate here. Anyone have any ideas how to blunt > > force > > > this with JOI or JExcel > > > > > > Thanks > > > > > > Troy > > > > > > > > > > > > ----- Original Message ----- > > > From: "Noah Campbell" <[EMAIL PROTECTED]> > > > To: "POI Users List" <[EMAIL PROTECTED]> > > > Sent: Tuesday, June 22, 2004 9:56 AM > > > Subject: Re: Unable to read entire header > > > > > > You'll have to use JExcelAPI which supports 95 format. > > > > > > On Tue, 22 Jun 2004 09:05:20 -0700, Troy McKinnon > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > Could I somehow prepend the input stream? > > > > Or so I have to find a solution other than POI? > > > > > > > > Troy > > > > > > > > ----- Original Message ----- > > > > From: "Koundinya (Sudhakar Chavali)" <[EMAIL PROTECTED]> > > > > To: "POI Users List" <[EMAIL PROTECTED]> > > > > Sent: Tuesday, June 22, 2004 3:15 AM > > > > Subject: RE: Unable to read entire header > > > > > > > > > POI will not support older versions of EXcel. That is the reason you > > get > > > > that problem, > > > > > > > > > > POI supported documents should start with following charachters > > ��ࡱ� > > > > > > > > > > > > > > > > > > Regards > > > > > Sudhakar > > > > > > > > > > > > > > > --- [EMAIL PROTECTED] wrote: > > > > > > You may try separating the excel file first from the stream then > > read > > > > > > it. > > > > > > > > > > > > -----Original Message----- > > > > > > From: Troy McKinnon [mailto:[EMAIL PROTECTED] > > > > > > Sent: Tuesday, June 22, 2004 11:54 AM > > > > > > To: [EMAIL PROTECTED] > > > > > > Subject: Unable to read entire header > > > > > > > > > > > > I have a big problem, and I am hoping for an easy solution or > > > > > > workaround. > > > > > > > > > > > > I am trying to read an excel file using POI, but I get the > following > > > > > > error: > > > > > > > > > > > > java.io.IOException: Unable to read entire header; 279 bytes read; > > > > > > expected > > > > > > 512 bytes > > > > > > at > > > > > > > > > org.apache.poi.poifs.storage.HeaderBlockReader.<init><HeaderBlockReader. > > > > > > java > > > > > > :78> > > > > > > ... > > > > > > > > > > > > If I open the file in excel and resave it.. all is good. > > > Unfortunately > > > > > > I > > > > > > don't have this option. > > > > > > Is there some way to work around this. I am receiving the file as > an > > > > > > InputStream via Http. > > > > > > > > > > > > Troy > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > ===== > > > > > "No one can earn a million dollars honestly."- William Jennings > Bryan > > > > (1860-1925) > > > > > > > > > > "Make everything as simple as possible, but not simpler."- Albert > > > Einstein > > > > (1879-1955) > > > > > > > > > > "It is dangerous to be sincere unless you are also stupid."- George > > > > Bernard Shaw (1856-1950) > > > > > > > > > > > > > > > > > > > > __________________________________ > > > > > Do you Yahoo!? > > > > > Yahoo! Mail Address AutoComplete - You start. We finish. > > > > > http://promotions.yahoo.com/new_mail > > > > > > > > > > > --------------------------------------------------------------------- > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > ------------------------------------------------------------------------ -- -- > ---- > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
