I have a use case which supports reading a single large excel file and writing into multiple smaller plain text files. I'm using the event model to achieve a low memory foot print. What I would like to be able to do is save progress. If I've broken my single large file into 1000 row chunks and have saved off that I've worked through 100 chunks, I would like to be able to start reading at row number 100,000.
As far as I can tell there isn't a way to do something like seek(100,000) using the HSSFEventFactory. Would it be reasonable to assume the memory variable, _unreadRecordIndex, in RecordFactoryInputStream contains both the number I'm looking for (how many records I've processed/read) and the number I could set if I wanted to start reading at, say row number, 100,000? (Obviously I would need to make code changes to make this work) Or is there some other way to save progress and/or start reading at a specified row number? matt
