org.dromara.hutool.poi.excel

Class ExcelDateUtil

java.lang.Object

org.dromara.hutool.poi.excel.ExcelDateUtil

public class ExcelDateUtil
extends Object

Excel中日期判断、读取、处理等补充工具类

Since:

5.5.5

Author:

looly

Constructor Summary

Constructors

Constructor and Description
ExcelDateUtil()

Method Summary

Modifier and Type	Method and Description
static boolean	isDateFormat(org.apache.poi.ss.usermodel.Cell cell) 是否日期格式
static boolean	isDateFormat(org.apache.poi.ss.usermodel.Cell cell, org.apache.poi.ss.formula.ConditionalFormattingEvaluator cfEvaluator) 判断是否日期格式
static boolean	isDateFormat(org.apache.poi.ss.usermodel.ExcelNumberFormat numFmt) 判断是否日期格式
static boolean	isDateFormat(int formatIndex, String formatString) 判断日期格式

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ExcelDateUtil

public ExcelDateUtil()

Method Detail

isDateFormat

public static boolean isDateFormat(org.apache.poi.ss.usermodel.Cell cell)

是否日期格式

Parameters:

cell - 单元格

Returns:

是否日期格式

isDateFormat

public static boolean isDateFormat(org.apache.poi.ss.usermodel.Cell cell,
                                   org.apache.poi.ss.formula.ConditionalFormattingEvaluator cfEvaluator)

判断是否日期格式

Parameters:

cell - 单元格

cfEvaluator - ConditionalFormattingEvaluator

Returns:

是否日期格式

isDateFormat

public static boolean isDateFormat(org.apache.poi.ss.usermodel.ExcelNumberFormat numFmt)

判断是否日期格式

Parameters:

numFmt - ExcelNumberFormat

Returns:

是否日期格式

isDateFormat

public static boolean isDateFormat(int formatIndex,
                                   String formatString)

判断日期格式

Parameters:

formatIndex - 格式索引，一般用于内建格式

formatString - 格式字符串

Returns:

是否为日期格式

Since:

5.5.3