Hashtable fileh = form.getMultipartRequestHandler().getFileElements();
//得到所有上传的xls 文件. 将其放入一个hashtable中 ManagerWorkLogVO vo = new ManagerWorkLogVO(); ContactDtVO cdVo = new ContactDtVO(); for (Enumeration e = fileh.keys(); e.hasMoreElements();) { String key = (String) e.nextElement(); try { FormFile file = (FormFile) fileh.get(key); if(file!=null){ Workbook book = Workbook.getWorkbook(file.getInputStream()); Sheet sheet = book.getSheet(0); long rows = sheet.getRows(); for (int i = 0; i < rows; i++) { for(int j=0;j<3;j++){ Cell cell = sheet.getCell(j,i); if(j == 0){ vo.setMobileNo(cell.getContents()); } if(j == 1){ DateCell c1 = (DateCell)cell; vo.setLogDT(c1.getDate()); }else{ vo.setLogContent(cell.getContents()); } cdVo.setMobileNo(vo.getMobileNo()); cdVo.setContactDT(vo.getLogDT()); } managerWorkLogService.addManagerWorkLog(vo, cdVo); } book.close(); } } catch (Exception ex) { ex.printStackTrace(); } }
