Or rather:
sheet.setDefaultColumnCellType(1, Cell.CELL_TYPE_STRING);
(where 1 is my column number)
-------- Original-Nachricht --------
> Datum: Tue, 05 Jul 2011 15:57:11 +0200
> Von: [email protected]
> An: "POI Users List" <[email protected]>
> Betreff: Re: Setting the cell type to "text" for an entire column (.xls)
> Yes, I also assumed, that this would be the method I was looking for -
> however, I believe that a CellStyle is not responsible for setting the data
> type (?)
>
> Ideally, I would like to call something like:
>
> sheet.setDefaultColumnCellType(Cell.CELL_TYPE_STRING);
>
>
>
> -------- Original-Nachricht --------
> > Datum: Tue, 5 Jul 2011 14:33:29 +0100 (BST)
> > Von: Nick Burch <[email protected]>
> > An: POI Users List <[email protected]>
> > Betreff: Re: Setting the cell type to "text" for an entire column (.xls)
>
> > On Tue, 5 Jul 2011, Christian Lercher wrote:
> > > 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.
> >
> > Did you try setting the default column style to a style with your
> required
> > formatting? It's XSSFSheet.setDefaultColumnStyle(int,CellStyle)
> >
> > Nick
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [email protected]
> > For additional commands, e-mail: [email protected]
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
