search

spring-projects / spring-batch-extensions

Spring Batch Extensions
242 stars 258 forks source link

Need of reading one particular sheet. #95

Open Kyeiv opened 2 years ago

Kyeiv commented 2 years ago

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.

BillyBolton commented 1 year ago

Is there an expected timeline for this issue?

mdeinum commented 1 year ago

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 commented 10 months ago

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