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]

Reply via email to