生成excel并发送给客户端

首先需要将excel写入输出流中，这个代码有机会给补充。这篇展示的是写入流之后，发送给客户端的代码示例：

/**
     * 将生成的excel发送给客户端
     * @param response
     * @param os 输出流
     * @param fileName excel文件名称
     */
    public static void  sendExcel(HttpServletResponse response , ByteArrayOutputStream os, String fileName){
        byte[] content = os.toByteArray();
        InputStream is = new ByteArrayInputStream(content);
        // 设置response参数，可以打开下载页面
        BufferedInputStream bis = null;
        BufferedOutputStream bos = null;
        try {
            
            String downLoadName = new String((fileName+".xls").getBytes("gbk"), "iso8859-1");  
            response.reset();
            response.setContentType("applicationnd.ms-excel;charset=utf-8");
            response.setHeader("Content-Disposition", "attachment;filename="+ downLoadName);
            ServletOutputStream out = response.getOutputStream();
            bis = new BufferedInputStream(is);
            bos = new BufferedOutputStream(out);
            byte[] buff = new byte[2048];
            int bytesRead;
            while (-1 != (bytesRead = bis.read(buff, 0, buff.length))) {
                bos.write(buff, 0, bytesRead);
            }
        } catch (final IOException e) {
            e.printStackTrace();
        } finally {
            if (bis != null)
                try {
                    bis.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            if (bos != null)
                try {
                    bos.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
        }
    }

这样既可让客户端接收到excel并下载。