org.dhatim.fastexcel

Class TimestampUtil

java.lang.Object

org.dhatim.fastexcel.TimestampUtil

public final class TimestampUtil
extends Object

Excel timestamp utility methods. For more information, check this out.

Field Summary

Fields

Modifier and Type	Field and Description
static long	DAY_MILLISECONDS
static int	HOURS_PER_DAY
static int	MINUTES_PER_HOUR
static int	SECONDS_PER_DAY
static int	SECONDS_PER_MINUTE

Constructor Summary

Constructors

Constructor and Description
TimestampUtil()

Method Summary

Modifier and Type	Method and Description
static Double	convertDate(Date date) Convert a Date to a serial number.
static Double	convertDate(LocalDate date) Convert a LocalDate to a serial number.
static Double	convertDate(LocalDateTime date)
static Double	convertZonedDateTime(ChronoZonedDateTime<?> zdt) Convert a ChronoZonedDateTime to a serial number.

Methods inherited from class java.lang.Object

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

Field Detail

SECONDS_PER_MINUTE

public static final int SECONDS_PER_MINUTE

See Also:

Constant Field Values

MINUTES_PER_HOUR

public static final int MINUTES_PER_HOUR

See Also:

Constant Field Values

HOURS_PER_DAY

public static final int HOURS_PER_DAY

See Also:

Constant Field Values

SECONDS_PER_DAY

public static final int SECONDS_PER_DAY

See Also:

Constant Field Values

DAY_MILLISECONDS

public static final long DAY_MILLISECONDS

See Also:

Constant Field Values

Constructor Detail

TimestampUtil

public TimestampUtil()

Method Detail

convertDate

public static Double convertDate(Date date)

Convert a Date to a serial number. Note Excel timestamps do not carry any timezone information; this method uses the system timezone to convert the timestamp to a serial number. If you need a specific timezone, prefer using convertZonedDateTime(java.time.chrono.ChronoZonedDateTime).

Parameters:

date - Date value.

Returns:

Serial number value.

convertDate

public static Double convertDate(LocalDateTime date)

convertDate

public static Double convertDate(LocalDate date)

Convert a LocalDate to a serial number.

Parameters:

date - Local date value.

Returns:

Serial number value.

convertZonedDateTime

public static Double convertZonedDateTime(ChronoZonedDateTime<?> zdt)

Convert a ChronoZonedDateTime to a serial number.

Parameters:

zdt - Date and timezone values.

Returns:

Serial number value.