| titi.duru@gmail.com 2006-09-30, 7:04 pm |
| Hi,
I am using POI to export some data to an excel file. The problem is
that in some cases the Sheet Dimension is not updated, meaning that if
I write data on 5 rows and 6 columns, the Sheet Dimension is 4(rows)
and 5(columns), but the data is correctly exported. When I open excel
file I see data in 5 rows and 6 columns, but if I try to import the
data(I use JExcelApi for import) when I access cells on row 5 or column
6 I get an error(the cell does not exist), also some warnings are
displayed in the console: "Warning: Cell XX exceeds defined cell
boundaries in Dimension record (4X5)".
If I open the excel file(with Excel) and enter something on row 6 and
column 7 then is working.
Why sheet Dimension is not updated? Is there a solution for this
problem? (Other than write a empty cell on row+1 and column+1)
Thanks,
DT
|