<% @ page language = " java " contentType = " text/html;charset=gb2312 " %>
<% @ page language = " java "
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 " %>
<%
response.setContentType( " APPLICATION/OCTET-STREAM " );
response.setHeader( " Content-Disposition " ,
" attachment; filename=/ " test.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();
%>


























































