Excel 表格导出方法

导出Excel

//导出方法 public ExcelOption getOption(String data) { bbttVO vo =(bbttVO) VOUtils.getBeanFromJsonData(data, bbttVO.class); ExcelOption returnVO = new ExcelOption(); // 构造表头 LinkedHashMap<String, String> linkedHashMap = new LinkedHashMap<String, String>(); List<Map<String, Object>> list=null; linkedHashMap.put("grbh", "个人编号"); linkedHashMap.put("sfzh", "身份证号"); linkedHashMap.put("xm", "姓名"); linkedHashMap.put("fpzs", "发票张数"); linkedHashMap.put("ylfyze_hj", "医疗费用总额"); returnVO.setHeads(linkedHashMap); String sql=""; sql="SELECT * from tablename"; list = CommonJdbcDaoUtils.queryForList(sql.toString(), new Object[] {}); double ylfyze_hj=0.0; int fpzs=0; int j=0; for( Map<String, Object> m:list){ if(!"-".equals(m.get("fpzs").toString()) ){ fpzs+=Integer.valueOf( m.get("fpzs").toString() ); } ylfyze_hj=NumberTools.add( ylfyze_hj, Double.valueOf(m.get("ylfyze_hj").toString()) ); j++; } Map<String, Object> map_hj= new LinkedHashMap<String, Object>(); map_hj.put("grbh", " "); map_hj.put("sfzh", "人数："+j); map_hj.put("xm", " "); map_hj.put("fpzs", fpzs); map_hj.put("ylfyze_hj", ylfyze_hj); list.add(map_hj); /**数据处理 Integer i=0; int j=0; for(Map<String, Object> m:list){ if("9999999999".equalsIgnoreCase(m.get("xh").toString())) { list.get(j).put("xh", ""); }else{ i++; list.get(j).put("xh", i.toString()); } j++; } */ returnVO.setList(list); Calendar c = Calendar.getInstance(); SimpleDateFormat s=new SimpleDateFormat("yyyyMMddHHmmss"); String curDate = s.format(c.getTime()); String fileName = curDate+".xls"; returnVO.setFilename(fileName); String title = ""; returnVO.setTitle(title); return returnVO; }