导出数据到excel

XXCmd.java

public void exportExcel(){

    HttpServletResponse res= ActionContext.getActionContext().getHttpServletResponse();

    httpServletRequest = ActionContext.getActionContext().getHttpServletRequest();

    DateFormat dataFormat = new SimpleDateFormat("yyyyMMddHHmmss");

    try{

        Workbook wb=XXService.exportToExcel();

        String filename="数据"+dateFormat.format(new Date());

        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;");

        response.setHeader("Content-disposition","attachment;filename="+new String(filename.getBytes("gb2312"),"ISO8859-1")+".xlsx");

        OutputStream = response.getOutputStream();

        wb.write(outputStream);

        outputStream.flush();

        outputStream,close();

    }catch (Exception e){

        e.printStackTrace();

    }

}

XXService.java

 public static Workbook exportToExcel(HttpServletRequest req) {

    List<Map<String,Object>> list= new ArrayList<Map<String,Object>>();    //try,catch 语句包围

    String[] title = new String[]{"姓名"，“身份证号”}；

   List<String[]> dataList = new ArrayList<String[]>(list.size());

    if(list.size()>0){

        String[] data = null;

        for(int i=0;i<list.size();i++){

            Map<String,Object> info = list.get(i);

            data= new String[title.length];

            data[0] = jyNull(info.get("NAME"));

            data[1] = jyNull(info.get("ID"));

            dataList.add(data);

        }

    }   

    return exportWorkBookByList(title,dataList);

}

//判断是否有null情况

private static String jyNull(Object o){

    if(null == o || "".equals(o)){

        return "";

    }

    return String.valueOf(o);

}