利用poi导出excel的代码片段
程序员文章站
2022-07-13 12:27:06
...
try {
OutputStream os = response.getOutputStream();
response.reset();// 清空输出流
response.setHeader("Content-disposition",
"attachment; filename=" + new String("images".getBytes("GB2312"), "iso8859_1")
+ ".xls");// 设定输出文件头
response.setContentType("application/msexcel");// 定义输出类型
/************** 创建一个xls文档 *************/
HSSFWorkbook workbook = new HSSFWorkbook(); // 定义工作薄
HSSFCellStyle style = workbook.createCellStyle(); // 获取单元格样式
/************** 设置单元格样式 *************/
style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 垂直
style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 水平
style.setWrapText(true);
HSSFSheet sheet = workbook.createSheet(); // 创建sheet
// 设置表头
// 创建第一行
HSSFRow row1 = sheet.createRow(0);
// 创建列
HSSFCell cell1 = row1.createCell(0);// 第一列
HSSFCell cell2 = row1.createCell(1);
HSSFCell cell3 = row1.createCell(2);
HSSFCell cell4 = row1.createCell(3);
// 定义单元格为字符串类型
cell1.setCellType(HSSFCell.CELL_TYPE_STRING);
cell2.setCellType(HSSFCell.CELL_TYPE_STRING);
cell3.setCellType(HSSFCell.CELL_TYPE_STRING);
cell4.setCellType(HSSFCell.CELL_TYPE_STRING);
cell1.setCellValue("类型/大小");
cell2.setCellValue("作者 (全部)");
cell3.setCellValue("地址");
cell4.setCellValue("时间");
// 设置列宽
sheet.setColumnWidth(0, 8000);
sheet.setColumnWidth(1, 10000);
sheet.setColumnWidth(2, 5000);
sheet.setColumnWidth(3, 6000);
HSSFRow row = null;
// 添加数据
for (int r = 1; r <= filelist.size(); r++) // 表示行
{
img = filelist.get(r - 1);
row = sheet.createRow(r);
row.createCell(0).setCellValue(
img.getUploadFileInfo().subStr(img.getUploadFileInfo().getThumbnailurl()) + " "
+ img.getUploadFileInfo().getSize());
row.createCell(1).setCellValue(img.getAuthor());
row.createCell(2).setCellValue(img.getUploadFileInfo().getImgrefurl());
row.createCell(3).setCellValue(img.getFormatDate());
}
workbook.write(os);
os.flush();
os.close();
} catch (IOException e) {
logger.error("", e);
}