java读取excel表格（不同版本的Excel，多个Sheet ，合拼单元格，单元格里面是公式等情况都有处理）

废话不多说，直接上代码

import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.text.SimpleDateFormat;
import java.util.*;


public class ExcelRead {

    private Workbook workbook;//workbook = WorkbookFactory.create(is);这种方式 Excel 2003/2007/2010 都是可以处理的
    private Sheet sheet;
    private FormulaEvaluator formulaEvaluator;

    public ExcelRead(String filePath) {
        File file = new File(filePath);
        try {
            InputStream is = new FileInputStream(file);
            if (file.getName().endsWith("xlsx")) {
                workbook = new XSSFWorkbook(is);
                formulaEvaluator = new XSSFFormulaEvaluator((XSSFWorkbook) workbook);
            } else {
                workbook = new HSSFWorkbook(is);
                formulaEvaluator = new HSSFFormulaEvaluator((HSSFWorkbook) workbook);
            }
        } catch (Exception e) {
            System.out.println("错误 : " + e);
        }
    }


    /**
     * 获取合并单元格的值
     *
     * @param sheet
     * @param row
     * @param column