Is there a streaming model? about bookfx HOT 1 CLOSED

It's great that more people share the view to making xlsx in BookFx way.

Yes, the model should be placed in memory before it will be rendered and packed into the xlsx. BookFx creates an xlsx in several phases:

1. Describing. You make the BookFx model from your data.
2. Validating. BookFx validates the BookFx model.
3. Proto-banking (optional). If prototypes are used, BookFx opens their xlsx files and puts they into the ProtoBank.
4. Calculating. BookFx calculates coordinates and sizes of boxes (places boxes on sheets).
5. Rendering. BookFx makes the EPPlus model.
6. Packing. EPPlus packs the xlsx.

It is possible to enable the stream mode at the 6 phase only. This will allow us to get the EPPlus output stream. But I don't see the much point to do this, because if a very large sheet can produce an out of memory error, it will happen before packing. Nevertheless, we can try to do an experiment with the streaming at the 6 phase. And, if it will be useful, we can add a stream mode.

What is the very large sheet?

from bookfx.