Read about our upcoming Code of Conduct on this issue

  1. 04 Mar, 2021 1 commit
    • nmartensen's avatar
      implement reading of ISO 8601 durations · de0d343037af
      nmartensen authored
      This implements reading the limited subset of the ISO 8601 duration
      specification that seems to be used by Excel when writing in OOXML
      strict mode:
      
       - Only hours, minutes, and seconds are understood
       - Only the point is accepted as decimal separator
       - The duration string always starts with 'PT'
      
      --HG--
      branch : 3.0
      de0d343037af
  2. 03 Mar, 2021 1 commit
  3. 02 Mar, 2021 2 commits
  4. 01 Mar, 2021 2 commits
  5. 27 Feb, 2021 4 commits
    • nmartensen's avatar
      update documentation on datetime and timedelta handling · a686cd874ea0
      nmartensen authored
      --HG--
      branch : 3.0
      a686cd874ea0
    • nmartensen's avatar
      add heuristic for reading timedelta · efb8780f9f2a
      nmartensen authored
      Since dates, times, and elapsed time are all usually stored as simple
      numbers in XLSX, openpyxl uses a heuristic to recognize the values as
      date/time representation and returns datetime.datetime or datetime.time
      objects for them. The heuristic is based on inspecting the number format
      style string (is this a date format?) and the stored value itself (to
      distinguish times from datetimes).
      
      This commit refines the heuristic by adding support for recognizing and
      returning time interval durations as datetime.timedelta.
      
      --HG--
      branch : 3.0
      efb8780f9f2a
    • nmartensen's avatar
      adapt test · 299bf67d9fb2
      nmartensen authored
      --HG--
      branch : 3.0
      299bf67d9fb2
    • nmartensen's avatar
      with iso_dates=True, do not convert timedelta to time · 7e6242cab933
      nmartensen authored
      --HG--
      branch : 3.0
      7e6242cab933
  6. 26 Feb, 2021 1 commit
  7. 23 Feb, 2021 2 commits
  8. 19 Feb, 2021 9 commits
  9. 17 Feb, 2021 4 commits
  10. 14 Feb, 2021 1 commit
  11. 09 Feb, 2021 6 commits
  12. 08 Feb, 2021 2 commits
    • nmartensen's avatar
      datetime.from_excel(): round datetimes to full milliseconds · b45f0332b09f
      nmartensen authored
      According to the specification (section 18.17.4), fractional seconds in
      datetimes are stored with up to three decimals, which corresponds to
      millisecond precision. It does not make sense to pretend we could be
      more accurate than that.
      
      The condition for detecting desired time-only returns needs to be
      adapted because we might round up to a full day and should not return
      time only in that case.
      
      --HG--
      branch : 3.0
      b45f0332b09f
    • nmartensen's avatar
      update datetime tests for rounding to full milliseconds · 54947c80f6d8
      nmartensen authored
      --HG--
      branch : 3.0
      54947c80f6d8
  13. 12 Feb, 2021 1 commit
  14. 11 Feb, 2021 1 commit
  15. 08 Feb, 2021 2 commits
  16. 28 Jan, 2021 1 commit