The closedxml load file slowly

Nov 24, 2014 at 5:52 AM
I try to do a test and compare the time of load file.
I found the closedXml is the slowest between OpenXML and NPOI.

Just testing load the file and nothing to do.

OpenXML 103 ms
ClosedXML 2790ms
NPOI 1097ms

It's bad when do with lot of files. ╮(╯_╰)╭
Nov 24, 2014 at 6:37 PM
How many cells?

If performance is paramount then you should use SAX.
Nov 24, 2014 at 11:17 PM

The cells count about 6000+ and size is about 500kb.
Hope the closedxml will be better. :-D