Jav 利用poi讀取excel，javpoi讀取excel

Jav 利用poi讀取excel，javpoi讀取excel

package com.taotaosou.core.zipcode;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ExcelReader {

    public static HSSFSheet readHssfExcel(String path) {
        File file = new File(path);
        FileInputStream is = null;
        HSSFSheet childSheet = null;
        try {
            is = new FileInputStream(file);
            HSSFWorkbook wbs = new HSSFWorkbook(is);
            childSheet = wbs.getSheetAt(0);

        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            if (is != null) {
                try {
                    is.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
                is = null;
            }
        }

        return childSheet;
    }

    public static XSSFSheet readXssfExcel(String path) {
        File file = new File(path);
        FileInputStream is = null;
        XSSFSheet childSheet = null;
        try {
            is = new FileInputStream(file);
            XSSFWorkbook wbs = new XSSFWorkbook(is);
            childSheet = wbs.getSheetAt(0);

        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            if (is != null) {
                try {
                    is.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
                is = null;
            }
        }

        return childSheet;
    }

    public static XSSFSheet readXssfExcel(FileInputStream is) {
        XSSFSheet childSheet = null;
        try {
            XSSFWorkbook wbs = new XSSFWorkbook(is);
            childSheet = wbs.getSheetAt(0);

        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            if (is != null) {
                try {
                    is.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
                is = null;
            }
        }

        return childSheet;
    }

    public static XSSFSheet readXssfExcel(InputStream is) {
        XSSFSheet childSheet = null;
        try {
            XSSFWorkbook wbs = new XSSFWorkbook(is);
            childSheet = wbs.getSheetAt(0);

        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            if (is != null) {
                try {
                    is.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
                is = null;
            }
        }

        return childSheet;
    }

    public static void main(String[] args) {
        XSSFSheet sheet = ExcelReader
                .readXssfExcel(Thread.currentThread().getContextClassLoader().getResourceAsStream("postcode.xlsx"));

        for (int i = 0, num = sheet.getLastRowNum(); i < num; i++) {
            XSSFRow row = sheet.getRow(i);
            System.out.println(row.getCell(0).getNumericCellValue()); 
            System.out.println(row.getCell(1).getStringCellValue()); 
        }
    }
}