POI EXCELÁпí×ÔÊÊÓ¦ÖÐÎÄÇé¿öϲ»×Ô¶¯ÊÊÓ¦ÎÊÌâ

for (int columnNum = 0; columnNum <= titles.length; columnNum++) {
int columnWidth = sheet.getColumnWidth(columnNum) / 256;
for (int rowNum = 0; rowNum < sheet.getLastRowNum(); rowNum++) {
HSSFRow currentRow;
//µ±Ç°ÐÐδ±»Ê¹Óùý
if (sheet.getRow(rowNum) == null) {
currentRow = sheet.createRow(rowNum);
} else {
currentRow = sheet.getRow(rowNum);
}


if (currentRow.getCell(columnNum) != null) {
HSSFCell currentCell = currentRow.getCell(columnNum);
if (currentCell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
int length = currentCell.getStringCellValue().getBytes().length;
if (columnWidth < length) {
columnWidth = length;
}
}


}
}
sheet.setColumnWidth(columnNum, columnWidth * 256);
}