monitorjbl / excel-streaming-reader

An easy-to-use implementation of a streaming Excel reader using Apache POI
Apache License 2.0
953 stars 344 forks source link

Possibility to disable Shared Strings Table #35

Closed andersjaensson closed 8 years ago

andersjaensson commented 8 years ago

The entire shared strings table is read into memory, which can have a very big impact on memory consumtion. Would it be possible to add an option to use inline strings instead? See https://poi.apache.org/apidocs/org/apache/poi/xssf/streaming/SXSSFWorkbook.html for some background.

bitdivine commented 6 years ago

When writing, sure, a writer can write inline strings instead of creating a string table. However when reading it looks as if the file already contains a strings table so the reader has no choice but to deal with it. That doesn't mean that it cannot use less memory when using the strings table, e.g. with multi-pass (fast) or storing the table on disk (slower but simpler).