java中jxl将数据库中的数据导入到excel中

java中将数据库中的数据导入到excel中有好几种的方法：

这里介绍jxl的方法：

举个例子

	@RequestMapping("/exam_monitor/user/inner/o_export.jspx")
	public void exam_monitor_user_export(Integer examId,HttpServletRequest request,HttpServletResponse response){
		CmsSite site=CmsUtils.getSite(request);//与主题无关代码
		FrontUtils.frontData(request,model,site);//与主题无关代码
		Calendar c=Calendar.getInstance();
		int year=c.get(Calendar.YEAR);
		int month=c.get(Calendar.MONTH);
		int day=c.get(Calendar.DATE);
		int hour=c.get(Calendar.HOUR_OF_DAY);
		int minute=c.get(Calendar.MINUTE);
		int second=c.get(Calendar.SECOND);
		String date=year+"-"+month+"-"+day+"-"+hour+"-"+minute+"-"+second;
		String filename = "exam_" + examId + "_" + CmsUtils.getUserId(request) +"_"+date+ ".xls";
		CmsExam bean=manager.findById(examId);
		List<CmsExamUser> list=examUserMng.getList(examId, null); 
		try {
			jxl.write.WritableWorkbook workbook=jxl.Workbook.createWorkbook(new java.io.FileOutputStream(filename));  //创建一个工作簿			
			jxl.write.WritableSheet sheet = workbook.createSheet("考试人员列表", 0);	//在工作簿中创建一个叫name的表	
			sheet.addCell(new jxl.write.Label(0, 0, "考试名称:"));//这里Lebel中第一个参数是列，第二个参数是行
			sheet.addCell(new jxl.write.Label(1, 0, bean.getName()));
			sheet.addCell(new jxl.write.Label(0, 1, "培训班开始时间:"));
			sheet.addCell(new jxl.write.Label(1, 1, bean.getStartTime().toString()));
			sheet.addCell(new jxl.write.Label(0, 2, "培训班结束时间:"));
			sheet.addCell(new jxl.write.Label(1, 2, bean.getEndTime().toString()));
			sheet.addCell(new jxl.write.Label(0, 3, "考试总人数:"));
			sheet.addCell(new jxl.write.Label(1, 3, String.valueOf(list.size())));
			sheet.addCell(new jxl.write.Label(2, 3, "考试时长:"));
			sheet.addCell(new jxl.write.Label(3, 3, String.valueOf(bean.getTimes())));
			sheet.addCell(new jxl.write.Label(0, 4, "考试合格人数:"));
			sheet.addCell(new jxl.write.Label(1, 4, String.valueOf(bean.getExamCount().getStandards())));
			sheet.addCell(new jxl.write.Label(2, 4, "合格分数:"));
			sheet.addCell(new jxl.write.Label(3, 4, String.valueOf(bean.getPassScore())));
			
			sheet.addCell(new jxl.write.Label(0, 5, "培训班学员如下"));
			sheet.addCell(new jxl.write.Label(0, 6, "用户ID"));
			sheet.addCell(new jxl.write.Label(1, 6, "学员姓名"));
			sheet.addCell(new jxl.write.Label(2, 6, "学员单位"));
			sheet.addCell(new jxl.write.Label(3, 6, "部门"));
			sheet.addCell(new jxl.write.Label(4, 6, "职务"));
			sheet.addCell(new jxl.write.Label(5, 6, "行政级别"));			
			sheet.addCell(new jxl.write.Label(6, 6, "分数"));
			sheet.addCell(new jxl.write.Label(7, 6, "排名"));								
			for (int i = 0; i < list.size(); i++) {
				CmsExamUser u = list.get(i);   //这里循环将数据库中的数据加入到excel中
				sheet.addCell(new jxl.write.Label(0, i + 7, u.getUser().getUsername()));
				sheet.addCell(new jxl.write.Label(1, i + 7, u.getUser().getRealname()));
				sheet.addCell(new jxl.write.Label(2, i + 7, u.getUser().getOrg().getName()));
				sheet.addCell(new jxl.write.Label(3, i + 7, u.getUser().getUserExt().getDepartment()));
				sheet.addCell(new jxl.write.Label(4, i + 7, u.getUser().getUserExt().getJob()));
				sheet.addCell(new jxl.write.Label(5, i + 7, u.getUser().getGrand().getName()));
				sheet.addCell(new jxl.write.Label(6, i + 7, u.getScore().toString()));
				sheet.addCell(new jxl.write.Label(7, i + 7, String.valueOf(i+1)));							
			}
			workbook.write();   //写入文件
			workbook.close();	//记得关闭	
		} catch (Exception e) {			
			e.printStackTrace();
		}
		//设置文件下载属性
		response.setContentType("multipart/form-data");
		response.setHeader("Content-Disposition", "attachment;fileName=" + filename);
		ServletOutputStream out;
		try {
			java.io.FileInputStream file = new java.io.FileInputStream(filename);
			out = response.getOutputStream();//调用方法getOutputStream（）可以获取一个指向客户的输出流
			int b = 0;
			byte[] buffer = new byte[10240];
			while (true) {
				b = file.read(buffer); 
				if (b == -1) {
					break;
				}
				out.write(buffer, 0, b);//将文件写入到流中
			}
			file.close();
			out.close();
			out.flush();
		} catch (IOException e) {
			e.printStackTrace();
		}	
		
	}
	

补上几个不错的帖子：

http://www.iteye.com/problems/54701

http://yaofeng911.iteye.com/blog/472492

http://blog.csdn.net/feichexia/article/details/7105741

http://zhangjunhd.blog.51cto.com/113473/19631