com.sh.util

类 ExcelDateUtil

java.lang.Object

com.sh.util.ExcelDateUtil

public class ExcelDateUtil
extends java.lang.Object

Description: Excel时间

Title:聚天业务架构平台(SHGather)

从以下版本开始:

Oct 24, 2013

版本:

3.0

作者:

江兴春

构造器概要

构造器

构造器和说明
ExcelDateUtil()

方法概要

限定符和类型	方法和说明
static boolean	isADateFormat(int formatIndex, java.lang.String formatString) Given a format ID and its format String, will check to see if the format represents a date format or not.
static boolean	isCellDateFormatted(org.apache.poi.ss.usermodel.Cell cell)
static boolean	isInternalDateFormat(int format)
static boolean	isValidExcelDate(double value) Given a double, checks if it is a valid Excel date.

从类继承的方法 java.lang.Object

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

构造器详细资料

ExcelDateUtil

public ExcelDateUtil()

方法详细资料

isCellDateFormatted

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

isValidExcelDate

public static boolean isValidExcelDate(double value)

Given a double, checks if it is a valid Excel date.

参数:

value - the double value

返回:

true if valid

isADateFormat

public static boolean isADateFormat(int formatIndex,
                                    java.lang.String formatString)

Given a format ID and its format String, will check to see if the format represents a date format or not. Firstly, it will check to see if the format ID corresponds to an internal excel date format (eg most US date formats) If not, it will check to see if the format string only contains date formatting characters (ymd-/), which covers most non US date formats.

参数:

formatIndex - The index of the format, eg from ExtendedFormatRecord.getFormatIndex

formatString - The format string, eg from FormatRecord.getFormatString

返回:

boolean

另请参阅:

isInternalDateFormat(int)

isInternalDateFormat

public static boolean isInternalDateFormat(int format)