jsp导出excel poi

<% @ 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();
%> 
 
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值