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

来源：互联网发布：linux 合并相同文件夹编辑：程序博客网时间：2024/05/19 19:15

最近遇到了导出数据到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();        }}}

1 0