o ȷe@sdZddlZdZededdksJedddZeddd Zeddd Zd ZGd d d eZGdddeZ GdddeZ GdddeZ GdddeZ GdddeZ ddZddZddZdZdd Zd!d"Zd#d$ZdS)%a Tools for working with dates and times in Excel files. The conversion from ``days`` to ``(year, month, day)`` starts with an integral "julian day number" aka JDN. FWIW: - JDN 0 corresponds to noon on Monday November 24 in Gregorian year -4713. More importantly: - Noon on Gregorian 1900-03-01 (day 61 in the 1900-based system) is JDN 2415080.0 - Noon on Gregorian 1904-01-02 (day 1 in the 1904-based system) is JDN 2416482.0 N)i$ia$iipik )i$-i-c@eZdZdZdS) XLDateErrorz-A base class for all datetime-related errors.N__name__ __module__ __qualname____doc__r r B/var/www/ideatree/venv/lib/python3.10/site-packages/xlrd/xldate.pyr#rc@r)XLDateNegativez``xldate < 0.00``Nrr r r rr'rrc@r)XLDateAmbiguouszGThe 1900 leap-year problem ``(datemode == 0 and 1.0 <= xldate < 61.0)``Nrr r r rr+rrc@r)XLDateTooLargezGregorian year 10000 or laterNrr r r rr/rrc@r)XLDateBadDatemodez#``datemode`` arg is neither 0 nor 1Nrr r r rr3rrc@s eZdZdS)XLDateBadTupleN)r r r r r r rr7src Cs|dvrt||dkrdS|dkrt|t|}||}tt|d}d|kr1dks4JJ|dkrCd}}}|d7}nt|d\}}t|d\}}|t|kr[t||dkrgddd|||fS|d krs|dkrst||t|} | d d d d d | dd d } | dd dd} | ddd} | dL} | dkr| dd| d| |||fS| dd| d | |||fS)aU Convert an Excel number (presumed to represent a date, a datetime or a time) into a tuple suitable for feeding to datetime or mx.DateTime constructors. :param xldate: The Excel number :param datemode: 0: 1900-based, 1: 1904-based. :raises xlrd.xldate.XLDateNegative: :raises xlrd.xldate.XLDateAmbiguous: :raises xlrd.xldate.XLDateTooLarge: :raises xlrd.xldate.XLDateBadDatemode: :raises xlrd.xldate.XLDateError: :returns: Gregorian ``(year, month, day, hour, minute, nearest_second)``. .. warning:: When using this function to interpret the contents of a workbook, you should pass in the :attr:`~xlrd.book.Book.datemode` attribute of that workbook. Whether the workbook has ever been anywhere near a Macintosh is irrelevant. .. admonition:: Special case If ``0.0 <= xldate < 1.0``, it is assumed to represent a time; ``(0, 0, 0, hour, minute, second)`` will be returned. .. note:: ``1904-01-01`` is not regarded as a valid date in the ``datemode==1`` system; its "serial number" is zero. rr)rrrrrrg@riQr<=ie/i:iSiiMi@ ik l) rrintrounddivmod_XLDAYS_TOO_LARGErr _JDN_delta) xldatedatemodexldaysfracsecondshourminutesecondminutesjdnyregmpdr r rxldate_as_tuple;s:     (r2cCs^|rt}n |dkr t}nt}t|}||}tt|d}t|d\}}|t||d|S)z Convert an Excel date/time number into a :class:`datetime.datetime` object. :param xldate: The Excel number :param datemode: 0: 1900-based, 1: 1904-based. :returns: A :class:`datetime.datetime` object. rgpAir) epoch_1904 epoch_1900epoch_1900_minus_1r r!r"datetime timedelta)r%r&epochdaysfractionr) millisecondsr r rxldate_as_datetimes r<cCs(|drdS|dr dS|drdSdS)Nrrdrir )yr r r_leaps   r?) Nrrrrrrrrrrrc Cs|\}}}|dvr t||dkr|dkr|dkrdSd|kr%dks0ntd|||ffd|kr:dksEntd |||ff|dks[|t|kre|d kr[|d kr[t|setd |||ff|d }|}|d krx|d}|d}n|d}d|dd|dd|d|dddd}|t|} | dkrtd|||ff| dkr|dkrtd|||fft| S)a Convert a date tuple (year, month, day) to an Excel date. :param year: Gregorian year. :param month: ``1 <= month <= 12`` :param day: ``1 <= day <= last day of that (year, month)`` :param datemode: 0: 1900-based, 1: 1904-based. :raises xlrd.xldate.XLDateAmbiguous: :raises xlrd.xldate.XLDateBadDatemode: :raises xlrd.xldate.XLDateBadTuple: ``(year, month, day)`` is too early/late or has invalid component(s) :raises xlrd.xldate.XLDateError: rrrili'zInvalid year: %rrrzInvalid month: %rzInvalid day: %rrrrrri iTr=zInvalid (year, month, day): %rrzBefore 1900-03-01: %r)rr_days_in_monthr?r$rfloat) date_tupler&yearmonthdayYpMMpr.r'r r rxldate_from_date_tuples> $  rOcCs~|\}}}d|krdkr5nn$d|krdkr5nnd|kr'dkr5nn |d|d|dStd|||ff)a- Convert a time tuple ``(hour, minute, second)`` to an Excel "date" value (fraction of a day). :param hour: ``0 <= hour < 24`` :param minute: ``0 <= minute < 60`` :param second: ``0 <= second < 60`` :raises xlrd.xldate.XLDateBadTuple: Out-of-range hour, minute, or second rrgN@g8@z"Invalid (hour, minute, second): %r)r) time_tupler*r+r,r r rxldate_from_time_tuples HrRcCs"t|dd|t|ddS)a+ Convert a datetime tuple ``(year, month, day, hour, minute, second)`` to an Excel date value. For more details, refer to other xldate_from_*_tuple functions. :param datetime_tuple: ``(year, month, day, hour, minute, second)`` :param datemode: 0: 1900-based, 1: 1904-based. Nr)rOrR)datetime_tupler&r r rxldate_from_datetime_tuples rT)r r6r$r3r4r5r# ValueErrorrrrrrrr2r<r?rFrOrRrTr r r rs*G"/