java生成excel文件

	/**
	 * FunName:	createImportLog
	 * Description:	创建xls导入日志
	 * @param flag	判断是成功还是失败
	 * @param path	路径
	 * @return boolean
	 * @author jiale
	 * @throws Exception 
	 * @create Date 2013年12月31日 16:51:01
	 */
	public boolean createImportLog(String flag,String path,String pc) throws Exception{
		pc = "<Where> where 1=1 and cjpc='"+pc+"'</Where>";
		System.out.println(pc);

		
		int count =0;
		try{
			if(flag.equals("1"))
			{
				WritableWorkbook workBook_xs = null;
				WritableSheet sheet_xs = null;
				File file_xs = null;
				Label label = null;
				String sep = System.getProperty("file.separator");				// 分隔符
				file_xs = new File(path);
				file_xs.createNewFile();	
				workBook_xs = Workbook.createWorkbook(file_xs);
				sheet_xs = workBook_xs.createSheet("sheet1", 0);
				sheet_xs.setColumnView(0, 15);
				sheet_xs.setColumnView(1, 20);
				sheet_xs.setColumnView(2, 15);
				sheet_xs.setColumnView(3, 15);
				sheet_xs.setColumnView(4, 20);
				sheet_xs.setColumnView(5, 20);
				sheet_xs.setColumnView(6, 20);
				
				//设置字体
				WritableFont font = new WritableFont(WritableFont.TIMES, 10, WritableFont.BOLD, true);
				WritableCellFormat format = new WritableCellFormat(font); 
				//设置表头开始----------------------------------
				label = new Label(0, 0, "序号",format);	
				sheet_xs.addCell(label);
				label = new Label(1, 0, "采集编号",format);	
				sheet_xs.addCell(label);
				label = new Label(2, 0, "采集批次",format);		
				sheet_xs.addCell(label);
				label = new Label(3, 0, "所在社区",format);		
				sheet_xs.addCell(label);
				label = new Label(4, 0, "姓名",format);		
				sheet_xs.addCell(label);
				label = new Label(5, 0, "性别",format);		
				sheet_xs.addCell(label);
				label = new Label(6, 0, "身份证",format);		
				sheet_xs.addCell(label);
				List tempList = comparePCDAO.querySuccessLog2(pc);
		 		Object [] obj = null;
		 		if(tempList.size()>0){
			 		for(int k=0;k<tempList.size();k++){
			 			obj = (Object [])tempList.get(k);
			 			label = new Label(0, k+1, (k+1)+"");//序列号
						sheet_xs.addCell(label);
						label = new Label(1, k+1, obj[0]+"");//采集编号
						sheet_xs.addCell(label);
						label = new Label(2, k+1, obj[1]+"");//采集批次
						sheet_xs.addCell(label);
						label = new Label(3, k+1, obj[2]+"");//所在社区
						sheet_xs.addCell(label);
						label = new Label(4, k+1, obj[3]+"");//姓名
						sheet_xs.addCell(label);
						label = new Label(5, k+1, obj[4]+"");//性别
						sheet_xs.addCell(label);
						label = new Label(6, k+1, obj[5]+"");//身份证
						sheet_xs.addCell(label);
						
						WritableFont wf = new WritableFont(WritableFont.ARIAL);
						WritableCellFormat wcf = new WritableCellFormat(wf);
						label.setCellFormat(wcf);
						count++;
			 		}
		 		}
		 		//循环写数据结束
				workBook_xs.write();
				workBook_xs.close();
		 		
		 		
			}else if(flag.equals("2")){
				WritableWorkbook workBook_xs = null;
				WritableSheet sheet_xs = null;
				File file_xs = null;
				Label label = null;
				String sep = System.getProperty("file.separator");				// 分隔符
				file_xs = new File(path);
				file_xs.createNewFile();	
				workBook_xs = Workbook.createWorkbook(file_xs);
				sheet_xs = workBook_xs.createSheet("sheet1", 0);
				sheet_xs.setColumnView(0, 15);
				sheet_xs.setColumnView(1, 20);
				sheet_xs.setColumnView(2, 15);
				sheet_xs.setColumnView(3, 15);
				sheet_xs.setColumnView(4, 20);
				sheet_xs.setColumnView(5, 20);
				sheet_xs.setColumnView(6, 20);
				sheet_xs.setColumnView(7, 100);
				
				//设置字体
				WritableFont font = new WritableFont(WritableFont.TIMES, 10, WritableFont.BOLD, true);
				WritableCellFormat format = new WritableCellFormat(font); 
				//设置表头开始----------------------------------
				label = new Label(0, 0, "序号",format);	
				sheet_xs.addCell(label);
				label = new Label(1, 0, "采集编号",format);	
				sheet_xs.addCell(label);
				label = new Label(2, 0, "采集批次",format);		
				sheet_xs.addCell(label);
				label = new Label(3, 0, "所在社区",format);		
				sheet_xs.addCell(label);
				label = new Label(4, 0, "姓名",format);		
				sheet_xs.addCell(label);
				label = new Label(5, 0, "性别",format);		
				sheet_xs.addCell(label);
				label = new Label(6, 0, "身份证",format);		
				sheet_xs.addCell(label);
				label = new Label(7, 0, "错误原因",format);		
				sheet_xs.addCell(label);
				
				List tempList = comparePCDAO.querydefeatLog2(pc);
				Object [] obj = null;
		 		if(tempList!=null){
			 		for(int k=0;k<tempList.size();k++){
			 			obj = (Object [])tempList.get(k);
			 			label = new Label(0, k+1, (k+1)+"");//序列号
						sheet_xs.addCell(label);
						label = new Label(1, k+1, StrUtil.nullToEmpty(obj[0]+""));//采集编号
						sheet_xs.addCell(label);
						label = new Label(2, k+1, StrUtil.nullToEmpty(obj[1]+""));//采集批次
						sheet_xs.addCell(label);
						label = new Label(3, k+1, StrUtil.nullToEmpty(obj[2]+""));//所在社区
						sheet_xs.addCell(label);
						label = new Label(4, k+1, StrUtil.nullToEmpty(obj[3]+""));//姓名
						sheet_xs.addCell(label);
						label = new Label(5, k+1, StrUtil.nullToEmpty(obj[4]+""));//性别
						sheet_xs.addCell(label);
						label = new Label(6, k+1, StrUtil.nullToEmpty(obj[5]+""));//身份证
						sheet_xs.addCell(label);
						label = new Label(7, k+1, StrUtil.nullToEmpty(obj[6]+""));//错误原因
						sheet_xs.addCell(label);
						
						WritableFont wf = new WritableFont(WritableFont.ARIAL);
						WritableCellFormat wcf = new WritableCellFormat(wf);
						label.setCellFormat(wcf);
						count++;
			 		}
		 		}
		 		//循环写数据结束
				workBook_xs.write();
				workBook_xs.close();
		 		
			}
			System.out.println("生成excel文件，成功导出："+count+"条信息!");
			return true;
		}catch(Exception e){
			e.printStackTrace();
			throw new Exception();
		}
	}