Thank you for the reply.
I just want to make sure that I understand this entirely. Are you saying that there is no way to write to the excel spreadsheet as a stream during the save process if I need to use rich cell formatting?
I am confused by this because there is a save option that allows the caller to pass in a HttpResponse. There is also another one that allows you to pass in a generic stream to the save method. However, I don’t see a way to add content to the worksheet when using this save option other than to use the LightCells interface.
As far as I can tell, the spreadsheet has to be fully populated before calling these save functions. If this is the case, then I would assume the entire spreadsheet has to be stored in memory.
Here are the two save functions I was referencing:
Do I understand this correctly? In my mind, it seems to defeat the purpose of using a stream if I have to fully prepare the spreadsheet in memory before calling the save method.
Am I missing something?