response.setContentType("UTF-8");
hWorkbook.write(response.getOutputStream());
response.getOutputStream().flush();
response.getOutputStream().close();
}
return null;
}
//设置样式方法
public HSSFCellStyle getCellStyle(HSSFWorkbook hWorkbook, short fontHeight,
short boldWeight) {
HSSFCellStyle cellStyle = hWorkbook.createCellStyle();
HSSFFont font = hWorkbook.createFont();
cellStyle = hWorkbook.createCellStyle();
cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
cellStyle.setTopBorderColor(HSSFColor.BLACK.index);
cellStyle.setLeftBorderColor(HSSFColor.BLACK.index);
cellStyle.setRightBorderColor(HSSFColor.BLACK.index);
cellStyle.setBottomBorderColor(HSSFColor.BLACK.index);
font = hWorkbook.createFont();
font.setFontHeight(fontHeight);
font.setBoldweight(boldWeight);
font.setFontName("宋体");
cellStyle.setFont(font);
cellStyle.setWrapText(true);
cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER)
return cellStyle;
}
摘自 xuliangwen的专栏