Sheet index (1) is out of range (0..0) about spring-batch-extensions HOT 4 CLOSED

Le 11 sept. 2017 à 23:40, flacohenao ***@***.***> a écrit : Hey. I'm having this error using your extension library. when I execute the job it works just fine. but at the second time of executing, it gives me that error. @bean public PoiItemReader<ActivosExcel> excelReader() throws MalformedURLException { PoiItemReader<ActivosExcel> reader = new PoiItemReader<>(); reader.setSaveState(false); reader.setLinesToSkip(1); reader.setResource(new UrlResource("file:\\file.xlsx") { }); reader.setRowMapper(excelRowMapper()); return reader; } that is my Reader there... the complete error is: Caused by: java.lang.IllegalArgumentException: Sheet index (1) is out of range (0..0) at org.apache.poi.xssf.usermodel.XSSFWorkbook.validateSheetIndex(XSSFWorkbook.java:1527) ~[poi-ooxml-3.16.jar:3.16] at org.apache.poi.xssf.usermodel.XSSFWorkbook.getSheetAt(XSSFWorkbook.java:1134) ~[poi-ooxml-3.16.jar:3.16] at org.apache.poi.xssf.usermodel.XSSFWorkbook.getSheetAt(XSSFWorkbook.java:121) ~[poi-ooxml-3.16.jar:3.16] at org.springframework.batch.item.excel.poi.PoiItemReader.getSheet(PoiItemReader.java:47) ~[spring-batch-excel-0.5.0-SNAPSHOT.jar:na] at org.springframework.batch.item.excel.AbstractExcelItemReader.openSheet(AbstractExcelItemReader.java:120) ~[spring-batch-excel-0.5.0-SNAPSHOT.jar:na] at org.springframework.batch.item.excel.AbstractExcelItemReader.doOpen(AbstractExcelItemReader.java:112) ~[spring-batch-excel-0.5.0-SNAPSHOT.jar:na] at org.springframework.batch.item.support.AbstractItemCountingItemStreamItemReader.open(AbstractItemCountingItemStreamItemReader.java:144) ~[spring-batch-infrastructure-3.0.8.RELEASE.jar:3.0.8.RELEASE] ... 79 common frames omitted can you please help me? or should I do a custom Reader with POI. If that's the case, can you give me an example of how to do it? thank you. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#41>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AG73UtAH4nc99mPyTJvhSYC7z9RSyMFHks5shajjgaJpZM4PTzvp>.