jxl解析Excel文件，jxl解析excel, package

jxl解析Excel文件，jxl解析excel, package

    package util;      import java.io.File;      import java.io.IOException;      import java.text.SimpleDateFormat;      import java.util.ArrayList;      import java.util.Date;      import java.util.List;      import pojo.UserInfo;      import jxl.Cell;      import jxl.CellType;      import jxl.DateCell;      import jxl.Sheet;      import jxl.Workbook;      import jxl.read.biff.BiffException;      public class ExcelUtil {          /**          * 获取excel表格的数据          * @param path 文件路径          * @return          * @throws IOException           * @throws BiffException           */          public static List<UserInfo> getExcelDate() throws BiffException, IOException{              String[] info=null;              List<UserInfo> list=new ArrayList<UserInfo>();              File file = new File("F:\\userInfo.xls");              Workbook book = Workbook.getWorkbook(file);              // 获得第一个工作表对象              Sheet sheet = book.getSheet(0);              Cell cell=null;              int a=sheet.getRows();              int b=sheet.getColumns();              for (int i = 1; i < a ; i++){                  info=new String[b];                  for(int j = 0;j < b ; j++){                      cell = sheet.getCell(j, i);                      if(cell.getType()==CellType.DATE){//时间的处理                          DateCell dc = (DateCell)cell;                          Date date = dc.getDate();                          SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");                          String sDate = sdf.format(date);                          info[j] = sDate;                      }else{                          info[j] = cell.getContents();                      }                  }                  UserInfo ui=arrayToObject(info);                  list.add(ui);              }              return list;          }          /**          * 数组转对象          * @param info          * @return          */          private static UserInfo arrayToObject(String[] info){              UserInfo ui=new UserInfo();              ui.setAccountNum(info[0]);              ui.setCustomerName(info[1]);              ui.setMobile(info[2]);              ui.setServiceSales(info[3]);              ui.setTerminal(info[4]);              ui.setRecommend(info[5]);              ui.setSource(info[6]);              ui.setRegDate(info[7]);              return ui;          }      }