1、读取数据
import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.DateUtil;
import org.apache.poi.ss.usermodel.FormulaEvaluator;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.apache.poi.xssf.streaming.SXSSFFormulaEvaluator;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Objects;
public final class POIUtils {
private static FormulaEvaluator getCellFormulaEvaluator(Cell cell) {
Workbook workbook = cell.getRow().getSheet().getWorkbook();
FormulaEvaluator evaluator;
if (workbook instanceof HSSFWorkbook) {
evaluator = new HSSFFormulaEvaluator(((HSSFWorkbook) workbook));
} else if (workbook instanceof SXSSFWorkbook) {
evaluator = new SXSSFFormulaEvaluator(((SXSSFWorkbook) workbook));
} else if (workbook instanceof XSSFWorkbook) {
evaluator = new XSSFFormulaEvaluator(((XSSFWorkbook) workbook));
} else {
throw new RuntimeException("Workbook类型不正确");
}
return evaluator;
}
private static String getCellValue(Cell cell) {
Stri