POI 操纵EXCEL 写入内存，下载

来源：互联网发布：校园机房网络拓扑图编辑：程序博客网时间：2024/05/18 13:06

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