Flex Excel下载

　　　　　　<servlet>   
	    <servlet-name>ExcelServlet</servlet-name>   
	    <servlet-class>com.test.ExcelServlet</servlet-class>   
	</servlet>   
	  
	<servlet-mapping>   
	    <servlet-name>ExcelServlet</servlet-name>   
	    <url-pattern>/servlet/ExcelServlet</url-pattern>   
	</servlet-mapping> 

package com.test;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

public class ExcelServlet extends HttpServlet {
	 private static final long serialVersionUID = 1L;

	    public ExcelServlet() {
	        super();
	    }

	    public void destroy() {
	        super.destroy(); // Just puts "destroy" string in log
	        // Put your code here
	    }

	    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	        doMainDispatch(request, response);
	    }

	    public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	        doMainDispatch(request, response);
	    }

	    public void init() throws ServletException {
	        // Put your code here
	    }

	    protected void doMainDispatch(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
	        String filename = "excel.xls";
	        resp.reset();
	        req.setCharacterEncoding("UTF-8");
	        resp.setCharacterEncoding("UTF-8");
	        resp.setContentType("application/vnd.ms-excel");
	        resp.addHeader("Content-Disposition", "attachment; filename="" + filename + """);
	        String head = req.getParameter("head");
	        String data = req.getParameter("data");
	        HSSFWorkbook wb = generateExcel(head,data);
	        wb.write(resp.getOutputStream());
	        resp.getOutputStream().flush();
	        resp.getOutputStream().close();
	        req.getInputStream().close();
	    }

	    private HSSFWorkbook generateExcel(String head, String data) throws IOException {
	        String tmp = (new File("")).getCanonicalPath();
	        //如果不是只有一级 如："d:	omcat6in"
	        if(tmp.indexOf("bin") != -1)
	        {
	            tmp = tmp.substring(0, tmp.lastIndexOf("\"))
	                + "\webapps\Demo\model\Model.xls";
	        }
	        else //只有一级 如："d:	omcat6"
	        {
	            tmp += "\webapps\Demo\model\Model.xls";
	        }

	        //创建输出数据文件
			File modelFile =new File(tmp);
			// 路径下不存在此模板文件
			if (!modelFile.getParentFile().exists()) {
				return null;
			}
			else{
		        FileInputStream fileinputstream = new FileInputStream(tmp);
		        POIFSFileSystem poifsfilesystem = new POIFSFileSystem(fileinputstream);
		        HSSFWorkbook wb = new HSSFWorkbook(poifsfilesystem);
		        HSSFSheet sheet = wb.getSheetAt(0);

		        String[] headArr = head.split(";");
		        String[] dataArr = data.split(";");

		        for(int rowNum=0; rowNum<=dataArr.length/headArr.length; rowNum++)
		        {
		            HSSFRow row = sheet.getRow(rowNum);
		            HSSFCellStyle rowstyle=null;
		            if(row == null)  //如果模板中没有这一行，则新建
		              {
		                row = sheet.createRow(rowNum);
		            }
		            else  //如果有这一行，获取样式
		              {
		                rowstyle = row.getRowStyle();
		            }

		            for(int colNum=0; colNum<headArr.length; colNum++)
		            {
		                HSSFCell cell = row.getCell(colNum);
		                HSSFCellStyle cellstyle=null;
		                if(cell == null){
		                    cell = row.createCell(colNum);
		                }else{
		                    cellstyle = cell.getCellStyle();
		                }

		                if(cellstyle != null)
		                	cell.setCellStyle(cellstyle);
		                else if(rowstyle != null)
		                    cell.setCellStyle(rowstyle);
		            }
		        }
		        return wb;
			}
	    }
}