Module org.dhatim.fastexcel

Package 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	Description
static long	DAY_MILLISECONDS	Deprecated.
static int	HOURS_PER_DAY	Deprecated.
static int	MINUTES_PER_HOUR	Deprecated.
static int	SECONDS_PER_DAY	Deprecated.
static int	SECONDS_PER_MINUTE	Deprecated.

Constructor Summary

Constructors

Constructor	Description
TimestampUtil()

Method Summary

Modifier and Type	Method	Description
static Double	convertDate(LocalDate localDate)	Convert a LocalDate to a serial number.
static Double	convertDate(LocalDateTime localDateTime)	Convert a LocalDateTime to a serial number.
static Double	convertDate(Date date)	Convert a Date to a serial number.
static Double	convertInstant(Instant instant)	Convert an Instant to a serial number.
static Double	convertZonedDateTime(ZonedDateTime zonedDateTime)	Convert a ZonedDateTime 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

@Deprecated
public static final int SECONDS_PER_MINUTE

Deprecated.

See Also:

Constant Field Values

MINUTES_PER_HOUR

@Deprecated
public static final int MINUTES_PER_HOUR

Deprecated.

See Also:

Constant Field Values

HOURS_PER_DAY

@Deprecated
public static final int HOURS_PER_DAY

Deprecated.

See Also:

Constant Field Values

SECONDS_PER_DAY

@Deprecated
public static final int SECONDS_PER_DAY

Deprecated.

See Also:

Constant Field Values

DAY_MILLISECONDS

@Deprecated
public static final long DAY_MILLISECONDS

Deprecated.

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

Parameters:

date - Date value.

Returns:

Serial number value.

convertDate

public static Double convertDate(LocalDateTime localDateTime)

Convert a LocalDateTime to a serial number.

Parameters:

localDateTime - Local date time value.

Returns:

Serial number value.

convertDate

public static Double convertDate(LocalDate localDate)

Convert a LocalDate to a serial number.

Parameters:

localDate - Local date value.

Returns:

Serial number value.

convertZonedDateTime

public static Double convertZonedDateTime(ZonedDateTime zonedDateTime)

Convert a ZonedDateTime to a serial number.

Parameters:

zonedDateTime - Date and timezone values.

Returns:

Serial number value.

convertInstant

public static Double convertInstant(Instant instant)

Convert an Instant to a serial number. This method does care about timestamp information, all conversions are done in UTC.

Parameters:

instant - Instant value.

Returns:

Serial number value.