ExcelDateUtil

java.lang.Object

com.sh.util.ExcelDateUtil

public class ExcelDateUtil extends Object

Description: Excel时间

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

从以下版本开始:: Oct 24, 2013

构造器概要

构造器

构造器

说明

ExcelDateUtil()
方法概要

修饰符和类型

方法

说明

static boolean

isADateFormat(int formatIndex, 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
clone, equals, finalize, 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, 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)