how to restrict XLS2CSVmra to one sheet only?

Question

i need to read XLS(not XLSX) file efficiently and I found the XLS2CSVmra example of POI, the problem is that I need to read one sheet only (i have sheet name sheet index etc.). Is there any way to restrict reading to one sheet only?

Any help will be appreciated.

Thanks in advance, Yan

score 1 · Accepted Answer · answered Dec 01 '11 at 10:45

1

It should be really simple - in the record handler for BOFRecord, when it has worked out the sheet, just have it stop processing when it sees the start of the sheet after the one you want. Done!

answered Dec 01 '11 at 10:45

Gagravarr

47,320
10
111
156

Thank you, but events will continue to call, plus how to start with second sheet for example skipping previous sheets? – yan Dec 01 '11 at 10:58
Ignore all the records until you hit the required BOFRecord – Gagravarr Dec 01 '11 at 12:17

how to restrict XLS2CSVmra to one sheet only?

1 Answers1