xZi^SrSSKrSr\S\S- S:Xde\R"SSS5r\R"SSS 5r\R"SSS 5rS r"S S \5r"SS\5r "SS\5r "SS\5r "SS\5r "SS\5r SrSrSrSrSrSrSrg)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\rSrSrSrSrg) XLDateError#z-A base class for all datetime-related errors.N__name__ __module__ __qualname____firstlineno____doc____static_attributes__r e/var/www/eduai.edurigo.com/question_generate/ques_gen_env/lib/python3.13/site-packages/xlrd/xldate.pyrr#s3rrc\rSrSrSrSrg)XLDateNegative'z``xldate < 0.00``r Nr r rrrr'srrc\rSrSrSrSrg)XLDateAmbiguous+zGThe 1900 leap-year problem ``(datemode == 0 and 1.0 <= xldate < 61.0)``r Nr r rrrr+sMrrc\rSrSrSrSrg)XLDateTooLarge/zGregorian year 10000 or laterr Nr r rrrr/s#rrc\rSrSrSrSrg)XLDateBadDatemode3z#``datemode`` arg is neither 0 nor 1r Nr r rrrr3s)rrc\rSrSrSrg)XLDateBadTuple7r N)r r rrrr rrr!r!7srr!clUS;a [U5eUS:XagUS:a [U5e[U5nX- n[[US-55nSUs=::aS::de eUS:Xa S=n=pgUS- nO[ US5up[ US5upVU[ U:a [ U5eUS:XaSSSXVU4$US :aUS:Xa [U5eU[U-n U S -S -S -S -S -U -S-S -S -n U S-S -S-S-n U S-S-S-n U S-n U S:aU S-S- U S- XXg4$U S-S- U S -XXg4$)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. rr)rrrrrrg@riQr<=ie/i:iSiiMi@ ik l) rrintrounddivmod_XLDAYS_TOO_LARGErr _JDN_delta) xldatedatemodexldaysfracsecondshourminutesecondminutesjdnyregmpds rxldate_as_tuplerA;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%rAvqGGrcU(a[nOUS:a[nO[n[U5nX- n[[ US-55n[ US5upVU[ R"X5SU5-$)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. r&gpAir) epoch_1904 epoch_1900epoch_1900_minus_1r/r0r1datetime timedelta)r4r5epochdaysfractionr8 millisecondss rxldate_as_datetimerLsp B;E'E v;D}H%:-./G"7D1G 8%%dQ E EErcFUS-(agUS-(agUS-(agg)Nr(rdrir )ys r_leaprPs 1uQ3wq3wq r) NrrrrrrrrrrrcvUup#nUS;a [U5eUS:Xa US:XaUS:XagSUs=::aS::dO [SX#U4<35eSUs=::aS::dO [S X#U4<35eUS:d)U[U:a-US :XaUS :Xa[U5(d[S X#U4<35eUS -nUnUS ::a US- nUS-nOUS- nSU-S-SU-S-S--U-S- US-S-S-S-- nU[U- n U S::a[SX#U4<35eU S:aUS:Xa[ SX#U4<35e[ U 5$)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: r$rr%ili'zInvalid year: rrzInvalid month: z Invalid day: r.r-r)r*r(i iTrNzInvalid (year, month, day): r'zBefore 1900-03-01: )rr!_days_in_monthrPr3rfloat) date_tupler5yearmonthdayYpMMpr=r6s rxldate_from_date_tupleras"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 =rcUupnSUs=::aS:a4O O1SUs=::aS:a$O O!SUs=::aS:aO OUS- U-S- U-S- $[SXU4<35e)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 rr&gN@g8@z Invalid (hour, minute, second): )r!) time_tupler9r:r;s rxldate_from_time_tupleresc&D&D~2~!v**qF/?R/?$'4/$6$>> $PVAWY ZZrc>[USSU5[USS5-$)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))rare)datetime_tupler5s rxldate_from_datetime_tuplerhs. ~bq18<~ab12 3r)rrFr3rCrDrEr2 ValueErrorrrrrrr!rArLrPrXrarerhr rrrjs  ( !}z!}$,,,  tQ *   tR , &&tR4.4*4[NkN$[$* * [ DHNFD H,^ [ r