EXT结合POI导出数据到Excel表格

最近遇到了导出数据到excel的情况，刚好前台用到了EXT，就使用EXT结合POI导出数据了：

前台js代码如下：

    function exportExcel(){  
         var gridpanel = grid;   //'Ext.grid.Panel'  
           
         var cm=gridpanel.columns;  
         //封装表格数据  
         var data=[];  
         var store = gridpanel.getStore();  
         store.each(function(record){  
             data.push(record.data);  
            
         },this);  
         //获取表头的dataIndex  
         var headerIndex=[];  
         Ext.Array.forEach( cm, function(item){  
            
             if (item.xtype == "gridcolumn"&&!item.isHidden()) {  
                 headerIndex.push(item.dataIndex);  
             }  
            
         });  
         //获取表头的Text  
         var headText=[];  
         Ext.Array.forEach( cm, function(item){  
            
             if (item.xtype == "gridcolumn"&&!item.isHidden()) {  
                 headText.push(item.text);  
             }  
            
         });  
         if (!Ext.fly('frmDummy')) {  
             var frm = document.createElement('form');  
             frm.id = 'frmDummy';  
             frm.name = gridpanel.getId();  
             frm.className = 'x-hidden';  
             document.body.appendChild(frm);  
         }  
            
         Ext.Ajax.request({  
             disableCaching: true ,  
             url: path+'/exportExcelByExtAndPOI/exportExcel.do',  
             method: 'POST',  
             isUpload: true,  
             form: Ext.fly('frmDummy'),  
             params: {  
                 excleData:Ext.JSON.encode(data),  
                 excleHeader:Ext.JSON.encode(headerIndex),  
                 excleText:Ext.JSON.encode(headText)  
             }  
         });  
    }  

接下来就是后台POI解析代码了：

    package com.hrtel.framework.util;  
      
    import java.io.OutputStream;  
      
    import javax.servlet.http.HttpServletRequest;  
    import javax.servlet.http.HttpServletResponse;  
      
    import org.apache.log4j.Logger;  
    import org.apache.poi.hssf.usermodel.HSSFCell;  
    import org.apache.poi.hssf.usermodel.HSSFRow;  
    import org.apache.poi.hssf.usermodel.HSSFSheet;  
    import org.apache.poi.hssf.usermodel.HSSFWorkbook;  
    import org.springframework.stereotype.Controller;  
    import org.springframework.web.bind.annotation.RequestMapping;  
      
    import net.sf.json.JSONArray;  
    import net.sf.json.JSONObject;  
      
    @Controller  
    @RequestMapping("/exportExcelByExtAndPOI")  
    public class ExportExcelByExtAndPOI {  
          
        private static final Logger logger = Logger.getLogger(ExportExcelByExtAndPOI.class);  
          
        @RequestMapping("/exportExcel")  
        public void exportExcel(HttpServletRequest request, HttpServletResponse response){  
            logger.info("*******into method exportExcel**********");  
            String excleData  = request.getParameter("excleData");  
            String excleHeader = request.getParameter("excleHeader");  
            String excleText = request.getParameter("excleText");  
            JSONArray excle = JSONArray.fromObject(excleData);  
            HSSFWorkbook workbook = new HSSFWorkbook();  
            HSSFSheet sheet = workbook.createSheet();  
            // 解析表头  
            JSONArray dataHeader = JSONArray.fromObject(excleText);  
            HSSFRow headrow = sheet.createRow(0);  
            for (int col = 0; col < dataHeader.size(); col++) {  
                String mycell = dataHeader.getString(col);  
                HSSFCell cell = headrow.createCell(col);  
                // 定义单元格为字符串类型  
                cell.setCellType(HSSFCell.CELL_TYPE_STRING);  
                // 在单元格中输入一些内容  
                cell.setCellValue(mycell);  
            }  
            int r=0;  
            for(Object o : excle) {  
                JSONObject excleObj = (JSONObject)o;  
                HSSFRow row=sheet.createRow((short)r+1);  
                   
                //解析列  
                JSONArray dataIndex = JSONArray.fromObject(excleHeader);  
                   
                for(int col=0;col<dataIndex.size();col++){  
                    String mycell=dataIndex.getString(col);  
                    mycell=excleObj.getString(mycell);  
                    HSSFCell cell = row.createCell(col);  
                    // 定义单元格为字符串类型  
                    cell.setCellType(HSSFCell.CELL_TYPE_STRING);  
                    // 在单元格中输入一些内容  
                    cell.setCellValue(mycell);  
                       
                }  
                r++;  
            };  
            //通过Response把数据以Excel格式保存  
            response.reset();  
            response.setContentType("application/msexcel;charset=UTF-8");  
            response.setCharacterEncoding("UTF-8");  
            try {  
                response.addHeader("Content-Disposition", "attachment;filename=\""  
                        + new String(("test" + ".xls").getBytes("UTF-8"),  
                                "ISO8859_1") + "\"");  
                OutputStream out = response.getOutputStream();  
                workbook.write(out);  
                out.flush();  
                out.close();  
            } catch (Exception e) {  
                e.printStackTrace();  
            }  
        }  
    }