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();
%>

posted on 2014-05-20 14:06  蒲公英半海  阅读(209)  评论(0编辑  收藏  举报