P
ponzetta
Hi, I use Apache Poi to read/write from/to Excel.
I'm try to set a column of a sheet to show all values with correct
format "m/d/yy"
I'm used:
HSSFCellStyle cellStyle = wb.createCellStyle();
cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy"));
HSSFCell cellaData = row.createCell(new Integer(0).shortValue());
cellaData.setCellStyle(cellStyle);
cellaData.setCellValue(data);
This works fine, but format all cells of sheet and with much rows excel
return a warning.
I'm serching a method to format column entire.
Thank's Lorenzo
I'm try to set a column of a sheet to show all values with correct
format "m/d/yy"
I'm used:
HSSFCellStyle cellStyle = wb.createCellStyle();
cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy"));
HSSFCell cellaData = row.createCell(new Integer(0).shortValue());
cellaData.setCellStyle(cellStyle);
cellaData.setCellValue(data);
This works fine, but format all cells of sheet and with much rows excel
return a warning.
I'm serching a method to format column entire.
Thank's Lorenzo