Can NPOI read Excel files in stream？

[swang493]

When processing large files, to save memory, does NPOI have a way to do streaming read? If not, how does NPOI handle scenarios with large files?

[tonyqus]

You can try SXSSFWorkbook

[swang493]

Thank you! However I find SXSSFWorkbook only accepts 2 types of parameters: int(this is for reading I guess) or XSSFWorkbook(but I only have stream, if I have to create a XSSFWorkbook first for stream reading, that's meaningless)
so do you have any suggestions? :)