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.

Method Summary

Modifier and Type	Method and Description
static Double	convertDate(Date date) Convert a Date to a serial number.
static Double	convertZonedDateTime(ZonedDateTime zdt) Convert a ZonedDateTime to a serial number.

Methods inherited from class java.lang.Object

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

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.ZonedDateTime).

Parameters:

date - Date value.

Returns:

Serial number value.

convertZonedDateTime

public static Double convertZonedDateTime(ZonedDateTime zdt)

Convert a ZonedDateTime to a serial number.

Parameters:

zdt - Date and timezone values.

Returns:

Serial number value.