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]
