excel报表下载

1, 首先,需要在jsp页面中添加一个超链接: 

<a href="javascript:getExcel();">导出excle</a>

2, 添加方法

    function getExcel() {
	debugger;
	var startTime = $("#startTime").val();
	var endTime = $("#endTime").val();
	var name = $("#name").val();
	window.location.href="<%=path%>/data/downloadDetailDate?startTime="+startTime+"&&endTime="+endTime+"&&name="+name; 
}

3, 后台正常的控制层

/**
	 * @Description 获取司机在线时间明细数据
	 * @param request
	 * @return
	 */
	@RequestMapping("/downloadDetailDate")
	public  void downloadDetailDate(HttpServletRequest request,HttpServletResponse response){
		String startTime = request.getParameter("startTime");
		String endTime = request.getParameter("endTime");
		String name = request.getParameter("name");
		try {
			List<DriverWorkeTime> allDataList = dataServise.getDetailDate(startTime,endTime,name);
			String [] titleList = {"司机名称","司机uuid","司机上班时间点","司机上班时间点(字符串)","司机下班时间点","司机下班时间点(字符串)","司机工作时间(字符串)","司机工作时间","上下班相隔的时间(分钟)","一天的上班时间(小时)","司机类型(社招/基地)","司机注册时间"};
			ExcelUtil.dataToExcel("司机上下班打卡记录", "司机上下班打卡记录", titleList, allDataList, response, 12);
		} catch (Exception e) {
			// TODO: handle exception
		}
	}

4, excel工具类的导出excel报表方法

/**
	 * @warning 想用此工具类,必须保证实体类中所有属性都有值,并且属性的顺序与titleList的顺序相同
	 * 
	 * @param <T>
	 * @Description 将数据导出为Excel  
	 * @param fileName  文件名
	 * @param titleList 列名集合
	 * @param list      想要导出的数据
	 * @param i         对象的属性个数
	 * @param titleName 标题名         
	 * @param response  
	 */
	public static <T> void dataToExcel(String fileName,String titleName,String[] titleList,List list,HttpServletResponse response,int i) {
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		String today = sdf.format(new Date());
		OutputStream os = null;
		try {
			os = response.getOutputStream();  
			String localFileName = titleName;  

			//设置Excel文件名称
			response.setCharacterEncoding("UTF-8");//设置相应内容的编码格式
			response.setContentType("application/octet-stream;charset=utf-8");  
			response.setHeader("Content-Disposition", "attachment;filename=" +today 
					+ new String(fileName.getBytes(),"iso-8859-1") + ".xls");  
			// 开始写入excel  
			// 加标题  
			// 标题字体  18--代表的是标题的高度
			jxl.write.WritableFont wfc = new jxl.write.WritableFont(  
					WritableFont.COURIER, 18, WritableFont.NO_BOLD, false);  
			jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(  
					wfc);  
			wcfFC.setAlignment(jxl.format.Alignment.CENTRE);  
			wcfFC.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);  
			// 字段字体  10--指的为内容的字体大小
			jxl.write.WritableFont wfc1 = new jxl.write.WritableFont(  
					WritableFont.COURIER, 10, WritableFont.NO_BOLD, false);  
			jxl.write.WritableCellFormat wcfFC1 = new jxl.write.WritableCellFormat(  
					wfc1);  
			wcfFC1.setAlignment(jxl.format.Alignment.CENTRE);  
			wcfFC1.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);  
			// 结果字体  
			jxl.write.WritableCellFormat wcfFC2 = new jxl.write.WritableCellFormat();  
			wcfFC2.setAlignment(jxl.format.Alignment.CENTRE);  
			wcfFC2.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);  
			WritableWorkbook wbook = Workbook.createWorkbook(os);  
			// 写sheet名称  
			WritableSheet wsheet = wbook.createSheet(localFileName, 0);  
			for (int m = 0; m < titleList.length; m++) {  
				//18--设置每个单元格的宽度
				wsheet.setColumnView(m, 18);  
				//500--设置每个单元格的高度
				wsheet.setRowView(m, 500);
			}  
			// 加入字段名  
			for (int n = 0; n < titleList.length; n++) {  
				//此处数字为修改  列名所在行数   的地方
				wsheet.addCell(new jxl.write.Label(n, 1, titleList[n], wcfFC1));  
			}  
			// 加入标题  
			wsheet.mergeCells(0, 0, i - 1, 0);  
			wsheet.addCell(new Label(0, 0, localFileName, wcfFC));  
			/*// 加入打印时间  
			wsheet.addCell(new Label(i - 2, 1, "打印日期:"));  
			wsheet.addCell(new Label(i - 1, 1, today)); */ 
			// 写入流中  
			int row = 0;  
			for (int r = 0; r < list.size(); r++) {  
				Object[] obj = getFiledValues(list.get(r));
				for (int x = 0; x < titleList.length; x++) {  
					//此处 row + n  n代表从第几行开始写具体数据
					wsheet.addCell(new jxl.write.Label(x, row + 2,obj[x] == null ? " " : obj[x].toString(), wcfFC1));  
				}  
				row++;  
				if (row % 60000 == 0) {  
					row = 0;  
					// 写sheet名称  
					wsheet = wbook.createSheet(localFileName, 0);  
					i = 3;  
					for (int m = 0; m < titleList.length; m++) {  
						wsheet.setColumnView(m, 30);  
					}  
					// 加入字段名  
					for (int n = 0; n < titleList.length; n++) {  
						wsheet.addCell(new jxl.write.Label(n, 3, titleList[n],  
								wcfFC1));  
					}  
					// 加入标题  
					wsheet.mergeCells(0, 0, i - 1, 0);  
					wsheet.addCell(new Label(0, 0, localFileName, wcfFC));  
					/*// 加入打印时间  
					wsheet.addCell(new Label(i - 2, 1, "打印日期:"));  
					wsheet.addCell(new Label(i - 1, 1, today)); */ 
				}  
			}  
			wbook.write();  
			wbook.close();  
			os.flush();  
		} catch (Exception e) {
			// TODO: handle exception
		}finally {
			if (os == null) {  
				System.out.println("os is null!");  
			} else {  
				try {  
					os.close();  
					os = null;  
				} catch (IOException e) {  
					e.printStackTrace();  
				}  
			}  
		}

	}

5, 注意事项:

    1, 注意工具类使用时的要求: 标题列表和实体类属性的顺序

    2,注意jsp页面中添加超链接,试过用button,没有成功,并且方法中试过ajax,没有成功