java导出功能

/** * @param list 查询的列表集合(转范型之后的集合) * @param fileName 资源文件名 * @param headArray  头部数组 * @param widthArray  设置excel每列的宽度 * @param cols 显示多少列减1 * @param c 反射的类（通过它可以访问类中的属性以及方法） * @return * @throws Exception */@SuppressWarnings("rawtypes")public static String export(List list,String fileName,String[] headArray,int[] width,int cols,Class<?> c,HttpServletResponse response)throws Exception{try{ /*********创建excel阶段*********/  String exportfileName = fileName +"-"+ DateUtil.today() ;//设置响应方式response.setContentType("application/vnd.ms-excel;charset=utf-8");//String name = URLEncoder.encode(exportfileName, "UTF-8");String name=new String((exportfileName).getBytes("gbk"),"iso8859-1");response.setHeader("Content-Disposition", "attachment;filename="+name);    //创建execl第一行数句(标题)// 标题字体jxl.write.WritableFont wfc = new jxl.write.WritableFont(jxl.write.WritableFont.COURIER, 13, jxl.write.WritableFont.NO_BOLD, true);jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc);wcfFC.setAlignment(jxl.format.Alignment.CENTRE);wcfFC.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);wcfFC.setBackground(Colour.GREY_50_PERCENT);//创建一个excel文档WritableWorkbook book = Workbook.createWorkbook(response.getOutputStream());//创建sheet工作表+ ".xls"WritableSheet sheet = book.createSheet(exportfileName+"数据报表.xls", 0);//创建字体对象WritableFont font = new WritableFont(WritableFont.createFont("黑体"),13,WritableFont.NO_BOLD);WritableFont font2 = new WritableFont(WritableFont.createFont("黑体"),12,WritableFont.NO_BOLD);//创建格式化对象WritableCellFormat format = new WritableCellFormat();format.setFont(font);//设置字体format.setAlignment(Alignment.CENTRE);//设置居中format.setVerticalAlignment(VerticalAlignment.CENTRE);format.setBackground(Colour.GRAY_25);//设置背景色WritableCellFormat format2 = new WritableCellFormat();format2.setFont(font2);//设置字体format2.setAlignment(Alignment.CENTRE);//设置居中format2.setVerticalAlignment(VerticalAlignment.CENTRE);    /***********开始写第二行已下的数据************/for (int i = 0; i < headArray.length; i++) {sheet.addCell(new Label(i,cols,headArray[i],format));//添加表头sheet.setColumnView(i, width[i]);}    //得到类中所有的属性Field[] fields=c.getDeclaredFields();    for (int i = 0; i < list.size(); i++) {    Object object=list.get(i);    for (int j = 0; j < cols; j++) {       String sname = fields[j].getName(); // 获取属性的名字       sname = sname.substring(0, 1).toUpperCase() + sname.substring(1); // 将属性的首字符大写，方便构造get，set方法if(fields[j].getGenericType().toString().equals("class java.lang.String")){  Method m = (Method) object.getClass().getMethod("get" +sname);    String val = (String) m.invoke(object);  if (val != null) {    sheet.addCell(new Label(j,i+(cols+1),val,format2));                    }else{                    sheet.addCell(new Label(j,i+(cols+1),"",format2));                    }  } // 如果类型是Integer                  if (fields[j].getGenericType().toString().equals("class java.lang.Integer")) {                      Method m = (Method) object.getClass().getMethod("get" +sname);                      Integer val = (Integer) m.invoke(object);                      if (val != null) {                      sheet.addCell(new Label(j,i+(cols+1),val+"",format2));                    }else{                    sheet.addCell(new Label(j,i+(cols+1),0+"",format2));                    }                  }                  // 如果类型是Double                  if (fields[j].getGenericType().toString().equals("class java.lang.Double")) {                      Method m = (Method) object.getClass().getMethod("get" + sname);                      Double val = (Double) m.invoke(object);                      if (val != null) {                      sheet.addCell(new Label(j,i+(cols+1),val+"",format2));                    } else{                    sheet.addCell(new Label(j,i+(cols+1),0.0+"",format2));                    }                   }                  // 如果类型是Boolean 是封装类                  if (fields[j].getGenericType().toString().equals("class java.lang.Boolean")) {                      Method m = (Method) object.getClass().getMethod(sname);                      Boolean val = (Boolean) m.invoke(object);                      if (val != null) {                      sheet.addCell(new Label(j,i+(cols+1),val+"",format2));                    }  else{        sheet.addCell(new Label(j,i+(cols+1),"",format2));                    }                }                  // 如果类型是boolean 基本数据类型不一样 这里有点说名如果定义名是 isXXX的 那就全都是isXXX的                  // 反射找不到getter的具体名                  if (fields[j].getGenericType().toString().equals("boolean")) {                      Method m = (Method) object.getClass().getMethod(sname);                      Boolean val = (Boolean) m.invoke(object);                      if (val != null) {                      sheet.addCell(new Label(j,i+(cols+1),val+"",format2));                    }  else{sheet.addCell(new Label(j,i+(cols+1),"",format2));                    }                }                  // 如果类型是Short                  if (fields[j].getGenericType().toString().equals("class java.lang.Short")) {                      Method m = (Method) object.getClass().getMethod("get" + sname);                      Short val = (Short) m.invoke(object);                      if (val != null) {                      sheet.addCell(new Label(j,i+(cols+1),val+"",format2));                    }else{                    sheet.addCell(new Label(j,i+(cols+1),0+"",format2));                    }                    }                // 如果类型是Date                 if (fields[j].getGenericType().toString().equals("class java.util.Date")) {                      Method m = (Method) object.getClass().getMethod("get" + sname);                      Date val = (Date) m.invoke(object);                     SimpleDateFormat sfEnd = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");                    String time= sfEnd.format(val);                    if (val != null) {                      sheet.addCell(new Label(j,i+(cols+1),time+"",format2));                    }else{                    sheet.addCell(new Label(j,i+(cols+1),"",format2));                    }                    }      }}    // 加入标题    sheet.mergeCells(0, 0, cols-1, cols-1);    sheet.addCell(new jxl.write.Label(0, 0, fileName, wcfFC));    book.write();//写execel文档book.close(); return exportfileName;}catch(Exception e){e.printStackTrace();System.out.println("存储失败");return "false";}}

2.控制器中的写法。

      例：/********* 创建excel阶段 *********/
            // 创建第二行数据
            String head[] = { "活动", "参与人数", "日登陆玩家数", "互动参与度" };    //导出的列标题
            int[] width = new int[] { 25, 20, 20, 20 };
            ExportData.export(得到对象的集合, 导出的文件标题, head, width, 4（列标题的个数）, GetActiveData.class, response);

3.jsp//显示导出excel的dialog
function userExcelDialogShow(){
    if ($('input[name=nPlatformID]').val()=="" || $('input[name=nPlatformID]').val()==null) {
        $('#msg1').text('平台类型不能为空！');
        return false;
    }else{
        $('#msg1').text('*');
    }
    if ($('input[name=nAreaID]').val()=="" || $('input[name=nAreaID]').val()==null) {
        $('#msg2').text('所在区域不能为空！');
        return false;
    }else{
        $('#msg2').text('*');
    }
    $('#userFrm').form('submit',{
        url:'./userExports.do',
        success:function(request){
            if(request==false){
                $.messager.show({
                    title:'Error',
                    msg:'导出失败',
                    timeout:5000,
                    showType:'slide'
                });
            }
        }