RE: Event-based API for generating Excel files?

[Avik Sengupta]

> This would only help for reading, not writing, unfortunately.

Indeed. Thanks for clarifying.


> -------Original Message-------
>
> > From: Chris Nokleberg
>
> > Subject: Re: RE: RE: Event-based API for generating Excel files?
>
> > Sent: 29 Oct 2003 04:41:41
>
> >
>
> > Avik Sengupta wrote:
>
> > > But anyways... It is, in general, not possible to stream the writing of an
>
> > > excel file, since the file structure contains upstream pointers to
>
> > > downstream data.
>
> >
>
> > I can imagine some specific scenarios where it might be possible, but yes in
>
> > general this is true. Even if you could stream the Excel part, the
>
> > underlying OLE writer needs to know the size of the resulting stream, which
>
> > probably would be very hard for HSSF to calculate. If you also had a writer
>
> > that was based on a RandomAccessFile you could potentially go back and
>
> > "fixup" the pointers after writing the data, but that's pretty tricky.
>
> >
>
> > > The solution for streaming like access currently proposed is to user the
>
> > > RandomAccessFile. Chris has proposed such a solution.. but not many people
>
> > > have actually worked with that solution.
>
> >
>
> > This would only help for reading, not writing, unfortunately.
>
> >
>
> > Chris
>
> >
>
> >
>
> >
>
> > ---------------------------------------------------------------------
>
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
>
> > For additional commands, e-mail: [EMAIL PROTECTED]
>
> -------Original Message-------
-------Original Message-------