search

rabanti-github / NanoXLSX

NanoXLSX is a small .NET library written in C#, to create and read Microsoft Excel files in the XLSX format (Microsoft Excel 2007 or newer) in an easy and native way
MIT License
120 stars 36 forks source link

Read large xlsx files #38

Open mla-alm opened 2 years ago

mla-alm commented 2 years ago

Is your feature request related to a problem? Please describe. Very large xlsx files explodes the memory usage or is unable to be loaded.

Describe the solution you'd like If one only cares about reading data from very large xlsx files, then by utilizing the streams it is possible to minimize the memory usage and improve performance.

Additional context A working sketch can be found on my fork. If you have any interest in such a feature, please let me know.

rabanti-github commented 2 years ago

Hi, Thank you for the input and the PoC. Currently. I am doing a complete re-engineering (mostly structural) on the library (branch: dev-v3). The main goal is modularization. Therefore, the architecture may change in the upcoming version a little bit (or more). However, I am always interested in making the library more efficient. Maybe your approach can be incorporated or provided as module. I will link this issue and your fork in the Backlog.