Excel导入数据自己定义的

来源：互联网发布：淘宝95小嫩模全集编辑：程序博客网时间：2024/05/16 15:46
// TODO 批量导入数据public String batchImport() throws Exception {SessionInfo sessionInfo = (SessionInfo) ServletActionContext.getRequest().getSession().getAttribute("sessionInfo");sysDepartList = new LinkedList<SysDepartEntity>();Properties config = getImportConfig();ExcelImporter importer = new ExcelImporter(config);try {String excelPath = this.excelFile.getAbsolutePath();importer.open(excelPath);while (importer.hasMore()) {Map<String, String> record = importer.get();// System.out.println(record);                                  /转换为什么实体                                SysDepartEntity sde = new SysDepartEntity();sde = EntityUtil.buildEntity(record, SysDepartEntity.class);                                也可以自己转换                            // sde.setDepartName(record.get("departName"));sde.setDepartParent(parentId);sde.setCreateBy(sessionInfo.getUserId());sde.setCreateDate(new Date());// 验证编码if (sysDepartImplBiz.validateDepartCode(sde.getId(), parentId, sde.getDepartCode())&& sysDepartImplBiz.validateDepartCode(sde.getId(), parentId, sde.getDepartCode())) {sysDepartImplBiz.saveSysDepart(sde);countR++;} else {sysDepartList.add(sde);countE++;}}} catch (Exception e) {throw e;} finally {if (importer != null) {importer.close();}}// sysDepartEntity.setDepartParent(parentId);// sysDepartList = sysDepartImplBiz.querySysDepartList(sysDepartEntity,// pageResult);flg = 1;return LIST;}Properties getImportConfig() {Properties config = new Properties();// sheet.name : sheet1// sheet.num : 0// config.setProperty("sheet.name", "sheet1");               //读取的是第个sheet表              config.setProperty("sheet.num", "0");// # start row or column number // row.begin : 2 // col.begin : 0             //第几行开始              config.setProperty("row.begin", "2");           //第几列            config.setProperty("col.begin", "0");                  //每一列所填的字段是是什么config.setProperty("import.departName", "0");config.setProperty("import.departCode", "1");config.setProperty("import.fullName", "2");config.setProperty("import.telephone", "3");config.setProperty("import.fax", "4");config.setProperty("import.address", "5");config.setProperty("import.zip", "6");return config;}
0 0