Hi,
with Excel, it's possible to set the data type (like text, numeric, ...) for an
entire column. This is applied to all cells in the column - even those, which
do not contain data yet. The setting survives saving/loading an xls file.
I haven't been able to figure out how to do this with Apache POI. I know,
there's
cell.setCellType(Cell.CELL_TYPE_STRING)
but that's for individual cells (or would I really have to create 65000 rows,
and set it manually on each of them?)
Maybe I could use NamedRange somehow, but - how?
Thanks
Chris
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
