在做excel导出时如何将excel直接写在输出流中

之前做excel导出时，我都是先将文件写在服务器上，然后再下载下来，后来发现原来可以直接将文件写在输出流里边。

下面是一个小demo:

package com.huaqin.fcstrp.util;

import java.io.IOException;

import java.io.OutputStream;

import java.io.UnsupportedEncodingException;

import java.net.URLEncoder;

import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.Sheet;

public class WriteExcle {

    private HSSFWorkbook workbook = null;

    /**

     *

     * @param response 下载请求的response

     */

    public void createExcel(HttpServletResponse response){

        //创建workbook

        workbook = new HSSFWorkbook();

        //添加Worksheet（不添加sheet时生成的xls文件打开时会报错)

        Sheet sheet1 = workbook.createSheet("sheet1");

        OutputStream out = null;

        try {

            out = response.getOutputStream();

            String fileName = "test.xls";// 文件名

            response.setContentType("application/x-msdownload");

            response.setHeader("Content-Disposition", "attachment; filename="

                                                    + URLEncoder.encode(fileName, "UTF-8"));

            Row row = workbook.getSheet("sheet1").createRow(0);    //创建第一行

            for(int i = 0;i < 10;i++){

                Cell cell = row.createCell(i);

                cell.setCellValue("测试数据"+i);

            }

            workbook.write(out);

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            try {

                out.close();

            } catch (IOException e) {

                e.printStackTrace();

            }

        }

    }

}  

调用：

/**

     * 下载2

     * @param request

     * @param response

     * @return

     * @throws FileNotFoundException

     */

    @RequestMapping(value = "/download2")

    @ResponseBody

    public void download2(HttpServletRequest request,

            HttpServletResponse response) throws FileNotFoundException {

         WriteExcel writeExcle = new WriteExcel();

         writeExcel.createExcel(response);

    }