想导出数据格式:
第一步:定制显示格式
HSSFCellStyle styleCon_left_line = wb.createCellStyle(); styleCon_left_line.cloneStyleFrom(styleCon); styleCon_left_line.setAlignment((short)1); styleCon_left_line.setWrapText(true);
第二步:数据后拼接 ‘/n' 换行符,添加到样式
HSSFCell cella2 = row.createCell(11); cella2.setCellValue(new HSSFRichTextString(Utils.trim("test /n"))); cella2.setCellStyle(styleCon_left_line);
第三部:设置列高(可选),行高(可选)
/*设置行宽*/
int columnWidth[] = {4000,3000,3000,4500,3000,3000,4500,3000,3000,3000,3000,3000,3000}; for(int i=0; i<head.length;i++){ HSSFCell cell = row0.createCell(i); cell.setCellValue(new HSSFRichTextString(head[i])); cell.setCellStyle(titleStyle); sheet.setColumnWidth(i, columnWidth[i]); } /*设置行高*/ sheet.setDefaultRowHeight((short)300);