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'
});
}
}

 

版权声明：本文为博主原创文章，未经博主允许不得转载。