DateUtil

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

jet.report.xls
Class DateUtil

java.lang.Object
  jet.report.xls.DateUtil

public class DateUtil
extends java.lang.Object
extends java.lang.Object

Contains methods for dealing with Excel dates. It is a tool by which converting the Date to Excel file needs to convert to double values.

Method Summary
`static double`	`getExcelDate(java.util.Date date)` Converts the given date into a double value of its internal Excel representation, which is the number of days since 1/1/1900.
`static java.util.Date`	`getJavaDate(double date)` Converts the given Excel date into the Java representation of a date.
`static boolean`	`isValidExcelDate(double value)` Checks if the given double value is a valid Excel date.

Methods inherited from class java.lang.Object
`equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Method Detail

getExcelDate

public static double getExcelDate(java.util.Date date)

Converts the given date into a double value of its internal Excel representation, which is the number of days since 1/1/1900. Fractional days represent hours, minutes, and seconds.

Parameters:: date - the Date
Returns:: Excel representation of Date (-1 if error - test for error by checking for less than 0)

getJavaDate

public static java.util.Date getJavaDate(double date)

Converts the given Excel date into the Java representation of a date.

Parameters:: date - the Excel Date
Returns:: Java representation of a date (null if error)

isValidExcelDate

public static boolean isValidExcelDate(double value)

Checks if the given double value is a valid Excel date.

Parameters:: value - the double value
Returns:: true if valid