poi jsp xls
poi jsp xls
<%@ page language="java"
pageEncoding="UTF-8"
import="java.util.*,org.apache.poi.hssf.usermodel.HSSFWorkbook,
org.apache.poi.hssf.usermodel.HSSFSheet,
org.apache.poi.hssf.usermodel.HSSFRow,
org.apache.poi.hssf.usermodel.HSSFCell,
java.text.SimpleDateFormat"%>
<%
String
filename = new SimpleDateFormat("yyyyMMddHHmmssSSS").format(new
Date());
response.setContentType("APPLICATION/OCTET-STREAM");
response.setHeader("Content-Disposition",
"attachment; filename=\""+filename+".xls" + "\"");
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet =
wb.createSheet();
wb.setSheetName(0, "汉字", HSSFWorkbook.ENCODING_UTF_16);//
设置中文编码;
// 以下以写表头
// 表头为第一行
HSSFRow row = sheet.createRow((short) 0);
HSSFCell cell1 = row.createCell((short) 0);
cell1.setEncoding((short)
1);
cell1.setCellType(1);
HSSFCell cell2 = row.createCell((short)
1);
cell2.setEncoding((short) 1);
cell2.setCellType(1);
HSSFCell cell3
= row.createCell((short) 2);
cell3.setEncoding((short)
1);
cell3.setCellType(1);
sheet.setColumnWidth((short) 0, (short)
9000);
sheet.setColumnWidth((short) 1, (short)
9000);
sheet.setColumnWidth((short) 2, (short) 9000);
// 定义表头的内容
cell1.setCellValue(" 测试 ");
cell2.setCellValue(" 测试2
");
cell3.setCellValue(" 测试3 ");
for (int i = 0; i < 4; i++) {
//
定义数据从第二行开始
row
= sheet.createRow((short) i + 1);
cell1 = row.createCell((short)
0);
cell2 = row.createCell((short) 1);
cell3 =
row.createCell((short) 2);
cell1.setEncoding((short) 1);
cell1.setCellType(1);
cell2.setEncoding((short)
1);
cell2.setCellType(1);
cell3.setEncoding((short) 1);
cell3.setCellType(1);
// 填充内容
cell1.setCellValue(" 字段内容一 ");
cell2.setCellValue(" 字段内容一 ");
cell3.setCellValue(" 字段内容一
");
}
wb.write(response.getOutputStream());
response.getOutputStream().flush();
response.getOutputStream().close();
%>
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。