java读取EXCEl中的内容

package com.send.action;//包名称可以自己取


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

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

/**
 * @author (版权归原作者) 用于读取excel
 */
public class ExcelReader {
    private HSSFWorkbook wb = null;// book [includes sheet]

    private HSSFSheet sheet = null;
    private HSSFRow row = null;
    private int sheetNum = 0; // 第sheetnum个工作表

    private int rowNum = 0;
    private FileInputStream fis = null;
    private File file = null;
    public ExcelReader() {
    }
    public ExcelReader(File file) {
        this.file = file;
    }
    public void setRowNum(int rowNum) {
        this.rowNum = rowNum;
    }
    public void setSheetNum(int sheetNum) {
        this.sheetNum = sheetNum;
    }
    public void setFile(File file) {
        this.file = file;
    }
    /**
     * 读取excel文件获得HSSFWorkbook对象
     */
    public void open() throws IOException {
        fis = new FileInputStream(file);
        wb = new HSSFWorkbook(new POIFSFileSystem(fis));
        fis.close();
    }
    /**
     * 返回sheet表数目
     *
     * @return int
     */
    public int getSheetCount() {
        int sheetCount = -1;
        sheetCount = wb.getNumberOfSheets();
        return sheetCount;
    }
    /**
     * sheetNum下的记录行数
     *
     * @return int
     */
    public int getRowCount() {
        if (wb == null)
            System.out.println("=============>WorkBook为空");
        HSSFSheet sheet = wb.getSheetAt(this.sheetNum);
        int rowCount = -1;
        rowCount = sheet.getLastRowNum();
        return rowCount;
    }
    /**
     * 读取指定sheetNum的rowCount
     *
     * @param sheetNum
     * @return int
     */
    public int getRowCount(int sheetNum) {
        HSSFSheet sheet = wb.getSheetAt(sheetNum);
        int rowCount = -1;
        rowCount = sheet.getLastRowNum();
        return rowCount;
    }
    /**
     * 得到指定行的内容
     *
     * @param lineNum
     * @return String[]
     */
    public String[] readExcelLine(int lineNum) {
        return readExcelLine(this.sheetNum, lineNum);
    }
    /**
     * 指定工作表和行数的内容
     *
     * @param sheetNum
     * @param lineNum
     * @return String[]
     */
    public String[] readExcelLine(int sheetNum, int lineNum) {
        if (sheetNum < 0 || lineNum < 0)
            return null;
        String[] strExcelLine = null;
        try {
            sheet = wb.getSheetAt(sheetNum);
            row = sheet.getRow(lineNum);

            int cellCount = row.getLastCellNum();
            strExcelLine = new String[cellCount + 1];
            for (int i = 0; i <= cellCount; i++) {
                strExcelLine[i] = readStringExcelCell(lineNum, i);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return strExcelLine;
    }
    /**
     * 读取指定列的内容
     *
     * @param cellNum
     * @return String
     */
    public String readStringExcelCell(int cellNum) {
        return readStringExcelCell(this.rowNum, cellNum);
    }
    /**
     * 指定行和列编号的内容
     *
     * @param rowNum
     * @param cellNum
     * @return String
     */
    public String readStringExcelCell(int rowNum, int cellNum) {
        return readStringExcelCell(this.sheetNum, rowNum, cellNum);
    }
    /**
     * 指定工作表、行、列下的内容
     *
     * @param sheetNum
     * @param rowNum
     * @param cellNum
     * @return String
     */
    public String readStringExcelCell(int sheetNum, int rowNum, int cellNum) {
        if (sheetNum < 0 || rowNum < 0)
            return "";
        String strExcelCell = "";
        try {
            sheet = wb.getSheetAt(sheetNum);
            row = sheet.getRow(rowNum);

            if (row.getCell((short) cellNum) != null) { // add this condition

                // judge

                switch (row.getCell((short) cellNum).getCellType()) {
                case HSSFCell.CELL_TYPE_FORMULA:
                    strExcelCell = "FORMULA ";
                    break;
                case HSSFCell.CELL_TYPE_NUMERIC: {
                    strExcelCell = String.valueOf(row.getCell((short) cellNum)
                            .getNumericCellValue());
                }
                    break;
                case HSSFCell.CELL_TYPE_STRING:
                    strExcelCell = row.getCell((short) cellNum)
                            .getStringCellValue();
                    break;
                case HSSFCell.CELL_TYPE_BLANK:
                    strExcelCell = "";
                    break;
                default:
                    strExcelCell = "";
                    break;
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return strExcelCell;
    }
    // 主函数用于测试,一般用这里面的函数来进行操作

    public static void main(String args[]) {
        //标示文件路径

        File file = new File("C:\\importperson.xls");
        ExcelReader readExcel = new ExcelReader(file);
        //打开文件

        try {
            readExcel.open();
        } catch (IOException e) {
            e.printStackTrace();
        }
        readExcel.setSheetNum(0); // 设置读取索引为0的工作表

        // 总行数

        int count = readExcel.getRowCount();
        //循环读取Excel文件中的内容

        for (int i = 0; i <= count; i++) {
            String[] rows = readExcel.readExcelLine(i);
            for (int j = 0; j < rows.length; j++) {
                System.out.print(rows[j] + " ");
            }
            System.out.print("\n");
        }
    }
}