jxl解析Excel文件详解编程语言

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