andersnm

@SpiritBob Thanks for the additional information! This should be enough to attempt a repro at least. Alas no .NET 5 here, and no free diskspace to install, so it's likely...

Throwing out some random thoughts here. Just to be sure, can you confirm if the problem only happens with this particular XLSX and not with other similarly sized XLSX? And...

The two interesting files: ``` 01/01/1980 12:00 AM 30,798,086 sharedStrings.xml ... 01/01/1980 12:00 AM 278,566,993 sheet1.xml ``` These files are pretty huge and ExcelDataReader parses both in `CreateReader()`. I suppose...

@SpiritBob I suppose using a temp file will not reduce the total allocations, but rather double the number due to the added roundtrip. Alas I don't have any other good...

@SpiritBob The key factor is likely the the combined size of the XMLs inside file XLSX, not necessarily only the string table. I am assuming the memory pressure occurs in...

@SpiritBob I trust your testing and agree it sounds indeed like the string table is the main factor! To add, there was a report on bad XLSB perf on some...

Hi - not sure loading 20 concurrent 70mb spreadsheets is necessarily something this project should aim to support out of the box. If there is strong demand to externalize the...

Hi, This is something I've wanted myself for the ExcelNumberFormat project in order to properly support those invalid dates that Excel supports (f.ex January 0 1900 and February 29 1900)....

I still don't quite get it. It sounds like all your concerns are related to the default formatting provided by the .NET runtime. You would see the same behavior whether...

Have you looked at this section: https://github.com/ExcelDataReader/ExcelDataReader#formatting If you want to print a value as date-only, or time-only, you cannot rely on the raw values in the file. Neither Excel...