Apache Poi set Date Format on a column

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,764
Messages
2,569,564
Members
45,039
Latest member
CasimiraVa

Latest Threads

Top