openpyxl.utils.datetime module

class openpyxl.utils.datetime.GMT[source]

Bases: datetime.tzinfo

dst(dt)[source]

datetime -> DST offset in minutes east of UTC.

tzname(dt)[source]

datetime -> string name of time zone.

utcoffset(dt)[source]

datetime -> timedelta showing offset from UTC, negative values indicating West of UTC

openpyxl.utils.datetime.W3CDTF_to_datetime(formatted_string)[source]

Convert from a timestamp string to a datetime object.

openpyxl.utils.datetime.datetime_to_W3CDTF(dt)[source]

Convert from a datetime to a timestamp string.

openpyxl.utils.datetime.days_to_time(value)[source]
openpyxl.utils.datetime.from_excel(value, offset=2415018.5)[source]
openpyxl.utils.datetime.time_to_days(value)[source]

Convert a time value to fractions of day

openpyxl.utils.datetime.timedelta_to_days(value)[source]

Convert a timedelta value to fractions of a day

openpyxl.utils.datetime.to_excel(dt, offset=2415018.5)[source]