POI code:

public static void writeExcel(OutputStream out, List<BaseBean> beanList)
         throws Exception {
      HSSFWorkbook book = new HSSFWorkbook();

      for(int i = 0; i < beanList.size(); i++) {
         HSSFRow row = sheet.createRow(sheet.getLastRowNum() + 1);
         //row.setHeight((short) 255);

         cell = row.createCell(0);
         cell.setCellValue(String.valueOf(beanList.get(i).getName()));
      }

      book.write(out);
   }

download code：
    protected void doPost(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        String sufix = request.getParameter("s");
        String path = request.getParameter("p") + "." + sufix;
        try {
            String fileName = request.getParameter("f").trim();
            int c = fileName.lastIndexOf(".");
            String name = fileName.substring(0, c > 0 ? c : fileName.length())
                    + "." + sufix;
            response.setContentType("application/octet-stream");
            response.setHeader("Content-Disposition", "attachement;filename="
                    + new String(name.getBytes("GBK"), "ISO-8859-1"));
            File file = new File(Const.getCurrentUtterlyPath() + path);
            if (!file.exists()) {
                throw new IOException(fileName + ",所下载的文件不存在!");
            }
            response.setContentLength(Integer.parseInt(file.length() + ""));
            InputStream fs = new FileInputStream(file);
            OutputStream os = response.getOutputStream();
            byte[] buff = new byte[1024];
            int readCount = 0;
            while ((readCount = fs.read(buff)) != -1) {
                os.write(buff, 0, readCount);
            }
            if (fs != null) {
                fs.close();
            }
            if (os != null) {
                os.close();
            }
        } catch (IOException e) {
            LOG.error("error: " + e.getMessage() + ",path: " + path);
            throw e;
        }
        response.setStatus(response.SC_OK);
        response.flushBuffer();
    }

------解决方案--------------------
汗！！！ 网上一大把！！ 有人贴代码，我就不贴了

------解决方案--------------------
不用那么麻烦。。我以前写过。。直接在jsp上就能写
晚上回家帮你找找代码。。。