View Source Exceed.Util (Exceed v0.7.0)

Helpers for converting Elixir data formats to Excel.

Summary

Types

erl_datetime_t()

Functions

to_excel_datetime(datetime)

Converts a Date, DateTime, or NaiveDateTime to a float representing days since 1900, correcting for the Lotus 123 bug (Excel treats 1900 as a leap year).

Types

erl_datetime_t()

@type erl_datetime_t() ::
  {{pos_integer(), pos_integer(), pos_integer()},
   {non_neg_integer(), non_neg_integer(), non_neg_integer()}}

Functions

to_excel_datetime(datetime)

@spec to_excel_datetime(
  erl_datetime_t()
  | Date.t()
  | DateTime.t()
  | NaiveDateTime.t()
) :: float()

Converts a Date, DateTime, or NaiveDateTime to a float representing days since 1900, correcting for the Lotus 123 bug (Excel treats 1900 as a leap year).

Examples