Reading formulars and blank cells in Excel by POI event based API
Hello at all,
first sorry for my english.
I have to read Excel files using the POI event based API.
These files contain FormularRecords, whitch values are Strings.
I googled a lot, but I didn't found a way, to get FormularRecords as string.
This I need, because I have to compare the position of the Cell (row, column)
with other values.
An other way to get these cells is reading them as StringRecord or SSTRecod.
But there is no method .getRow() or .getColumn() for StringRecords and SSTRecords.
My other problem:
Some cells without a value can not be read.
Using the BlankRecord didn't catch all of them.
When I go to these cells and just hit Return (no value is set), then the cells can be catched.
Can anyone give me an idea?
It really would be very helpfull.
And I hope my english can be understood.
thx a lot
eichi
