Hi,
(As far as I can tell the only way I¹ll be able to figure out
what sheet I¹m in using the event model is to add up the bytes and compare
it to a table I built from the offsets in the BoundSheetRecord records when
I read them. If there¹s a simpler way--and I hoper there is--this email is
moot, although the stack overflow seems like a potential problem.)
I get a stack overflow if I put ³getRecordSize()² in the processRecord
method while modifying the XLS2CSVmra example app.
/**
* Main HSSFListener method, processes events, and outputs the
* CSV as the file is processed.
*/
public void processRecord(Record record) {
int thisRow = -1;
int thisColumn = -1;
String thisStr = null;
size = record.getRecordSize(); # this blows the program up
switch (record.getSid())
{
Exception in thread "main" java.lang.StackOverflowError
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
at org.apache.poi.hssf.record.Record.serialize(Record.java:82)
at org.apache.poi.hssf.record.Record.getRecordSize(Record.java:98)
etc., etc. kaboom!
Thanks,
Dave
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]