<%@ page language="java" import="org.apache.poi.hssf.usermodel.HSSFWorkbook,org.apache.poi.hssf.usermodel.HSSFSheet,org.apache.poi.hssf.usermodel.HSSFRow,org.apache.poi.hssf.usermodel.HSSFCell" pageEncoding="gb2312"%>
<%
response.reset();
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "inline;filename=" 11.xls");
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet( " sheet1 " );
// 以下以写表头
// 表头为第一行
HSSFRow row = sheet.createRow(( short ) 0 );
HSSFCell cell1 = row.createCell(( short ) 0 );
HSSFCell cell2 = row.createCell(( short ) 1 );
HSSFCell 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( " 测试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( " ggg " );
cell2.setCellValue( " 00000 " );
cell3.setCellValue( " adfasdf " );
}
wb.write(response.getOutputStream());
response.getOutputStream().flush();
response.getOutputStream().close();
%>