Need of reading one particular sheet.
Kyeiv opened this issue · 3 comments
Since the xlsx format supports storing multiple tabs named differently and with different columns there is a need for supporting such files. It could be done by giving the user an ability to specify which sheet to read from by adding the Id or Name.
Is there an expected timeline for this issue?
Currently the readers will read all the sheets and try to map it to objects. I'm considering adding support for configurating the start/end sheet. So if an Excel file has say 6 sheets you can configure it to start at sheet 2 and end at sheet 4 (or 2 if only a single one is needed).
Still pondering on the configuration for this. Should it be a simple startSheet and endSheet property or a sheets property that can accept a pattern like 2-4 or 1,3-6 to specify specific sheets and ranges.
For my use case it would be more helpful to name the sheet.