On Feb 25, 3:27 am, Silvio Bierman
wrote:
> Jile...@gmail.com wrote:
> > I wish to create Excel file, such that it should be able to
> > incrementally write data to the file system ... and not hold
> > everything in memory... i.e unlike HSSF POI.
>
> > Any Suggestions ?
>
> Excel supports the traditional XLS format and a newer XML based format.
> The former is very difficult to stream since it is some form of
> Microsfts compound document format which is not very stream-oriented. It
> might be possible but I do not know of any available tools that will
> support this. To generate this format in a non-streamed fashion you can
> use Apache POI but it will build the complete document in memory so you
> can not stream it before it has been completely generated.
> The XML format is easy to stream, of course. However, older versions of
> Excel do not support it.
>
> Silvio Bierman
Any Other Options ???