Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Need of reading one particular sheet. #95

Open
Kyeiv opened this issue Apr 12, 2022 · 3 comments
Open

Need of reading one particular sheet. #95

Kyeiv opened this issue Apr 12, 2022 · 3 comments

Comments

@Kyeiv
Copy link

Kyeiv commented Apr 12, 2022

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.

@Kyeiv Kyeiv changed the title Need of reading one particular sheet or define mapping for every sheet Need of reading one particular sheet. Apr 12, 2022
@mdeinum mdeinum self-assigned this Apr 12, 2022
@BillyBolton
Copy link

Is there an expected timeline for this issue?

@mdeinum
Copy link
Collaborator

mdeinum commented 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 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.

@acfo
Copy link

acfo commented Jan 12, 2024

For my use case it would be more helpful to name the sheet.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants