î mÐR\ã @sQdZddlZd)Zededdks6t‚ejdddƒZejd d d ƒZejd d d ƒZd+ZGdd„deƒZ Gdd„de ƒZ Gdd„de ƒZ Gdd„de ƒZ Gdd„de ƒZ Gdd„de ƒZdd„Zdd„Zdd„Zd,Zd!d"„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 éNièÙ$é=ibß$éi¶ipiké ééé‚$-c@seZdZdZdS)Ú XLDateErrorz-A base class for all datetime-related errors.N)Ú__name__Ú __module__Ú __qualname__Ú__doc__©r r ú//var/www/dbchiro/venv/build/xlrd/xlrd/xldate.pyr#s rc@seZdZdZdS)ÚXLDateNegativez``xldate < 0.00``N)r r r r r r r rr's rc@seZdZdZdS)ÚXLDateAmbiguouszGThe 1900 leap-year problem ``(datemode == 0 and 1.0 <= xldate < 61.0)``N)r r r r r r r rr+s rc@seZdZdZdS)ÚXLDateTooLargezGregorian year 10000 or laterN)r r r r r r r rr/s rc@seZdZdZdS)ÚXLDateBadDatemodez#``datemode`` arg is neither 0 nor 1N)r r r r r r r rr3s rc@seZdZdS)ÚXLDateBadTupleN)r r r r r r rr7s rc Cs |dkrt|ƒ‚n|dkr+dS|dkrFt|ƒ‚nt|ƒ}||}tt|dƒƒ}d|ko‰dkns”t‚|dkr»d}}}|d7}n*t|dƒ\}}t|dƒ\}}|t|krt|ƒ‚n|dkr&ddd|||fS|dkrM|dkrMt|ƒ‚n|t |} | dd d d d| d dd } | d ddd} | ddd} | dL} | dkrå| d d| d| |||fS| d d| d | |||fSdS)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. rrggõ@i€Qé<réie/i±:éiSiµiiMi@éé iké ilN)rr)rrrrrr) rrÚintÚroundÚAssertionErrorÚdivmodÚ_XLDAYS_TOO_LARGErrÚ _JDN_delta) ÚxldateÚdatemodeÚxldaysÚfracÚsecondsÚhourÚminuteÚsecondÚminutesÚjdnZyregÚmpÚdr r rÚxldate_as_tuple;s:     "   *  "r,cCs…|rt}n|dkr$t}nt}t|ƒ}||}tt|dƒƒ}t|dƒ\}}|tj||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. rgp™”Aièr)Ú epoch_1904Ú epoch_1900Úepoch_1900_minus_1rrrÚdatetimeÚ timedelta)r r!ZepochÚdaysZfractionr$Ú millisecondsr r rÚxldate_as_datetime‚s      r4cCs.|drdS|drdS|dr*dSdS)Nrrédrir )Úyr r rÚ_leap¤s   r7éc Cs|\}}}|dkr*t|ƒ‚n|dkrR|dkrR|dkrRdSd|koidknstd|||ffƒ‚nd|ko¤dknsÈtd|||ffƒ‚n|dks |t|kr(|d ko|d kot|ƒ r(td |||ffƒ‚n|d }|}|d kr[|d}|d }n |d}d|dd|dd|d|dddd}|t|} | dkrØtd|||ffƒ‚n| dkr|dkrtd|||ffƒ‚nt| ƒ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: rrgili'zInvalid year: %rrzInvalid month: %réézInvalid day: %rilrriµriÓéé iTé¸r5zInvalid (year, month, day): %rrzBefore 1900-03-01: %r)rr)rrÚ_days_in_monthr7rrÚfloat) Z date_tupler!ÚyearÚmonthÚdayZYpÚMZMpr)r"r r rÚxldate_from_date_tuple­s2 $ 5     : rDcCs›|\}}}d|ko&dknr{d|koBdknr{d|ko^dknr{|d|d|dStd|||ffƒ‚dS)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 rérgN@g8@z"Invalid (hour, minute, second): %rN)r)Z time_tupler%r&r'r r rÚxldate_from_time_tupleÜs TrFcCs+t|dd…|ƒt|dd…ƒS)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)rDrF)Zdatetime_tupler!r r rÚxldate_from_datetime_tupleìs rGé«Ù$éaß$)rHrIéÌ-)rrJ) Nrr8rrrrrrrrrr)r r0rrr-r.r/rÚ ValueErrorrrrrrrr,r4r7r>rDrFrGr r r rÚs(  G "  /