spring-batch-extensions icon indicating copy to clipboard operation
spring-batch-extensions copied to clipboard

Need of reading one particular sheet.

Open Kyeiv opened this issue 3 years ago • 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.

Kyeiv avatar Apr 12 '22 10:04 Kyeiv

Is there an expected timeline for this issue?

BillyBolton avatar Apr 06 '23 21:04 BillyBolton

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.

mdeinum avatar Oct 02 '23 14:10 mdeinum

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

acfo avatar Jan 12 '24 08:01 acfo