search

PydPiper / pylightxl

A light weight, zero dependency, minimal functionality excel read/writer python library
https://pylightxl.readthedocs.io
MIT License
303 stars 47 forks source link

read worksheet on demand #14

Closed mszbot closed 4 years ago

mszbot commented 4 years ago

Is it possible to read 1 worksheet on demand to save on memory?

My research says this is not possible on xlsx files because they are zip/xml files. Is this correct?

PydPiper commented 4 years ago

hi there, when you specify just a single worksheet, all other xml files are never read into memory. It’s a 2 step process. pylightxl unzips a workbook into a temp file (disk space) then parses the necessary worksheets.

hope that answers your question!

On Wed, Jun 10, 2020 at 10:31 AM mszbot notifications@github.com wrote:

Is it possible to read 1 worksheet on demand to save on memory?

My research says this is not possible on xlsx files because they are zip/xml files. Is this correct?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/PydPiper/pylightxl/issues/14, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIOU6F7MH2DFXG6S5ZV6P6TRV67NXANCNFSM4N2S7R5A .

-- Best, Viktor Kis

PydPiper commented 4 years ago

going to close this out - please feel free to reach out to us if you have any more question on this! :)