tafia / calamine

A pure Rust Excel/OpenDocument SpreadSheets file reader: rust on metal sheets
MIT License
1.6k stars 155 forks source link

Memory error and panic on large Excel sheets #433

Open SgtPepper47 opened 1 month ago

SgtPepper47 commented 1 month ago

Memory Issue: When the Excel sheet is too large, the Vec that is created for the range exceeds the machine memory. The application panics and crashes the program. This trickles up to the python interpreter and crashes the python interpreter even in the present of a try except.

tafia commented 1 month ago

I think you want to use worksheet_range_ref and stream the data.