jxt解析上传的xls文件

源地址：http://ozzzo.javaeye.com/blog/420892

jxt解析上传的xls文件

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();
   }
  }