Johan Appelgren

For sure we can be smarter here. Not sure how much difference lazily parsing cell content would make, but something to test and benchmark. Perhaps it would be enough to...

It is often missing or incorrect so unfortunately it can't bed used.

Do you have a sample .xlsb file that can be used to reproduce it?

A sample file using that format. [ed83a0f2-ad5d-45b1-98fd-80bb9b54c942.zip](https://github.com/ExcelDataReader/ExcelDataReader/files/1615019/ed83a0f2-ad5d-45b1-98fd-80bb9b54c942.zip)

Another example, this time with broken XML. It has leading whitespace which isn't valid XML. [101_DT_1C8013_20200109231039.zip](https://github.com/ExcelDataReader/ExcelDataReader/files/4040738/101_DT_1C8013_20200109231039.zip)

Because someone has to write the code and noone has so far.

The Server GC trades memory in favor of throughput. Then there's the Retain VM option that also affects how .NET frees memory back to the OS. I have an idea...

I'll take a look but I'm not sure it is worth it because of the added complexity. Lots of pitfalls with read and write errors, performance cost of reading, string...

Is there a sample Excel file that causes gigabytes of memory usage I can test things with?

Perhaps I'm missing something obvious, but I did a simple test and made the DrawingContext ctor protected instead of internal, built my own class inheriting from it and then rendered...