+ œizRt^RItRt]^,]^,, R8XgQh]P!R^^4t]P!R^ ^4t]P!R^ ^4tRt!RR]4t!RR]4t !R R ]4t !R R ]4t !R R]4t !RR]4t RtRtRtRtRtRtRtR#)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 Niipikc]tRt^#tRtRtR#) XLDateErrorz-A base class for all datetime-related errors.N__name__ __module__ __qualname____firstlineno____doc____static_attributes__rT/Users/mibo/.openclaw/workspace/.venv-ak/lib/python3.14/site-packages/xlrd/xldate.pyrr#s3r rc]tRt^'tRtRtR#)XLDateNegativez``xldate < 0.00``rNrrr r rr'sr rc]tRt^+tRtRtR#)XLDateAmbiguouszGThe 1900 leap-year problem ``(datemode == 0 and 1.0 <= xldate < 61.0)``rNrrr r rr+sMr rc]tRt^/tRtRtR#)XLDateTooLargezGregorian year 10000 or laterrNrrr r rr/s#r rc]tRt^3tRtRtR#)XLDateBadDatemodez#``datemode`` arg is neither 0 nor 1rNrrr r rr3s)r rc]tRt^7tRtR#)XLDateBadTuplerN)rrrr r rr r rr7sr rclVR 9d \V4hVR8XdR#VR8d \V4h\V4pW, p\\VR,44p^Tu;8:d R8:gQhQhVR8Xd^;p;rgV^, pM\ V^<4wr\ V^<4wrVV\ V,8d \ V4hV^8Xd^^^WVV3#V^=8dV^8Xd \V4hV\V,,p V ^,R,R,^,^,V ,R,^,^,p V R,^,R,R ,p V R ,R,^,p V ^,p V ^ 8dV R,R , V ^ , WWg3#V R,R , V ^,WWg3#)a 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. g@iQie/i:iSiiMi@ikl)rrrrrr) rrintrounddivmod_XLDAYS_TOO_LARGErr _JDN_delta) xldatedatemodexldaysfracsecondshourminutesecondminutesjdnyregmpds && r xldate_as_tupler1;s@v)) ~!! }V$$ [F ?D%w'(G  5   %!"""v! !"-gr*  "8,,V$$ {1av.. {x1}f%% :h' 'CQwF*a /1 4 ;d Ba G! KD $;1  #c )B u* !A2IB Rx%rAvqGG%rAvqGGr cV'd\pMV^<8d\pM\p\V4pW, p\\ VR,44p\ VR4wrVV\ P!W5^V4,#)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. gpAi) epoch_1904 epoch_1900epoch_1900_minus_1rr r!datetime timedelta)r$r%epochdaysfractionr( millisecondss&& r xldate_as_datetimer<sp B;E'E v;D}H%:-./G"7D1G 8%%dQ E EEr clV^,'d^#V^d,'d^#VR,'d^#^#)ir)ys&r _leapr@s&1uuQ3wwq3wwq r c:Vwr#pVR 9d \V4hV^8XdV^8Xd V^8XdR#RTu;8:dR8:gM\RW#V3: 24h^Tu;8:d^ 8:gM\RW#V3: 24hV^8g2V\V,8d1V^8XdV^8Xd\V4'g\RW#V3: 24hVR,pTpV^8:dV^, pV^ ,pM V^, pRV,^,R V,^,^ ,,V,R , V^,^d,^,^,, pV\V,, p V ^8:d\R W#V3: 24hV ^=8dV^8Xd\ R W#V3: 24h\ V 4#)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: rili'zInvalid year: zInvalid month: z Invalid day: rriiTzInvalid (year, month, day): zBefore 1900-03-01: r)rr_days_in_monthr@r#rfloat) date_tupler%yearmonthdayYpMMpr-r&s && r xldate_from_date_tuplerKs"Dv)) qyUaZC1H D D D3EGHH  " T#4FHII q u% %cRiEQJ5QU;;42DFGG B AAv !V U U "9>sRx"}3 4   SS(A-2 4C :h' 'F {$sASUVV {x1}$s9KMNN =r cVwrp^Tu;8:d^8dMMMI^Tu;8:d^<8d;MM7^Tu;8:d^<8d)MM%VR, V,R, V,R, #\RWV3: 24h)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 gN@g8@z Invalid (hour, minute, second): )r) time_tupler)r*r+s& r xldate_from_time_tuplerNsc&D&D~2~!v**qF/?R/?$'4/$6$>> $PVAWY ZZr cV\VR,V4\VR,4,#)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. :NN:rPNN)rKrN)datetime_tupler%s&&r xldate_from_datetime_tuplerRs* ~b18<~b12 3r )i$ia$)i$-i-) NrSrSrUrSrSrUrSrUrS)r r6r#r3r4r5r" ValueErrorrrrrrrr1r<r@rBrKrNrRrr r rWs  ( !}z!}$,,,  tQ *   tR , &&tR4.4*4[NkN$[$* * [ DHNFD H,^ [ r