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]
export_as_xa.xls
Description: MS-Excel spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
