You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
changed the title [-]Need of reading one particular sheet or define mapping for every sheet[/-][+]Need of reading one particular sheet.[/+]on Apr 12, 2022
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.
Activity
[-]Need of reading one particular sheet or define mapping for every sheet[/-][+]Need of reading one particular sheet.[/+]BillyBolton commentedon Apr 6, 2023
Is there an expected timeline for this issue?
mdeinum commentedon Oct 2, 2023
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
startSheetandendSheetproperty or asheetsproperty that can accept a pattern like2-4or1,3-6to specify specific sheets and ranges.acfo commentedon Jan 12, 2024
For my use case it would be more helpful to name the sheet.
Adrastopoulos commentedon Aug 26, 2026
Opened #218 with
setSheetNames(String...)onAbstractExcelItemReader.