java poi 解析excel

自己copy改的东西

 

 

public class LeadExcel {
         public static void main(String args[])throws IOException{
             LeadExcel leadExcel=new LeadExcel();
             String surl="D:/工程.xls";
             leadExcel.read(surl);
         }

    private void read(String surl) throws IOException{
        if(surl.endsWith("xlsx")){
            readxlsx(surl);
        } else if(surl.endsWith("xls")){
            readxls(surl);
        }
    }
    private void readxls(String surl) throws IOException {

        InputStream issurl = new FileInputStream(surl);
         HSSFWorkbook hssfWorkbook = new HSSFWorkbook(issurl);
        // 循环工作表Sheet
        for(int numSheet = 0; numSheet < hssfWorkbook.getNumberOfSheets(); numSheet++){
            HSSFSheet hssfSheet = hssfWorkbook.getSheetAt( numSheet);
            if(hssfSheet == null){
                continue;
            }

            // 循环行Row
            for(int rowNum = 0; rowNum <= hssfSheet.getLastRowNum(); rowNum++){
                HSSFRow hssfRow = hssfSheet.getRow( rowNum);
                if(hssfRow == null){
                    continue;
                }

                // 循环列Cell
                for(int cellNum = 0; cellNum <= hssfRow.getLastCellNum(); cellNum++){
                    HSSFCell hssfCell = hssfRow.getCell( cellNum);
                    if(hssfCell == null){
                        continue;
                    }

                    System.out.print("   " + getValuehs( hssfCell));
                }
                System.out.println();
            }
        }
    }

 

    private String getValuehs(HSSFCell hssfCell){
        if(hssfCell.getCellType() == hssfCell.CELL_TYPE_BOOLEAN){
            return String.valueOf( hssfCell.getBooleanCellValue());
        }else if(hssfCell.getCellType() == hssfCell.CELL_TYPE_NUMERIC){
            return String.valueOf(hssfCell.getNumericCellValue());
        }else if(hssfCell.getCellType() == hssfCell.CELL_TYPE_FORMULA){
            return String.valueOf(hssfCell.getCellFormula());
        }else{
            return String.valueOf(hssfCell.getStringCellValue());
        }
    }

    private void readxlsx(String surl) throws IOException {

        XSSFWorkbook xssfWorkbook = new XSSFWorkbook(surl);
        // 循环工作表Sheet
        for(int numSheet = 0; numSheet < xssfWorkbook.getNumberOfSheets(); numSheet++){
            XSSFSheet xssfSheet = xssfWorkbook.getSheetAt( numSheet);
            if(xssfSheet == null){
                continue;
            }

            // 循环行Row
            for(int rowNum = 0; rowNum <= xssfSheet.getLastRowNum(); rowNum++ ){
                XSSFRow xssfRow = xssfSheet.getRow( rowNum);
                if(xssfRow == null){
                    continue;
                }

                // 循环列Cell
                for(int cellNum = 0; cellNum <= xssfRow.getLastCellNum(); cellNum++){
                    XSSFCell xssfCell = xssfRow.getCell( cellNum);
                    if(xssfCell == null){
                        continue;
                    }
                    System.out.print("   "+getValuexs( xssfCell));
                }
                System.out.println();
            }
        }
    }

    private String getValuexs(XSSFCell xssfCell){
        if(xssfCell.getCellType() == xssfCell.CELL_TYPE_BOOLEAN){
            return String.valueOf(xssfCell.getBooleanCellValue());
        }else if(xssfCell.getCellType() == xssfCell.CELL_TYPE_NUMERIC){
            return String.valueOf(xssfCell.getNumericCellValue());
        }else if(xssfCell.getCellType() == xssfCell.CELL_TYPE_FORMULA){
            return String.valueOf(xssfCell.getCellFormula());
        }else{
            return String.valueOf(xssfCell.getStringCellValue());
        }
    }

 

}