Hello All,
I am trying to work on automatic sizing of columns in POI. I am trying to do
this per column once all my data is generated. The data in one of the columns
is date time and since it is larger than the cell width it shows as "#######"
when i open excel. The below code des not work at all int his case. Can some
please provide any help.
HSSFRow row = sheet.getRow(1);
java.util.Iterator<HSSFCell> it = row.cellIterator();
while(it.hasNext()){
HSSFCell cell = it.next();
sheet.autoSizeColumn((short)cell.getCellNum());
}
