1. 27 Feb, 2021 1 commit
    • 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
  2. 11 Jan, 2021 1 commit
  3. 06 Jan, 2021 1 commit
  4. 18 Dec, 2020 1 commit
    • Baudouin Giard's avatar
      Fix reading rows with skipped reference attribute · 462374fe7440
      Baudouin Giard authored
      Some Excel files generated with third-party libraries such as SpreadsheetGear - there could be other, skip the "r" attribute on "c" tags within rows. Excel seems to put this attribute on every cell, but I couldn't find any evidence that the standard commands it.
      
      openpyxl is not expecting these attributes to be skipped, so the result is that we end up with an invalid parsed row.
      
      To fix this, when we get coordinates, make sure col_counter reflects them so the reader knows which cell it has been reading.
      
      --HG--
      branch : 3.0
      462374fe7440
  5. 23 Oct, 2020 1 commit
  6. 22 Jul, 2020 2 commits
  7. 19 Jun, 2020 1 commit
  8. 03 Jun, 2020 1 commit
  9. 01 May, 2020 1 commit
  10. 10 Dec, 2019 2 commits
  11. 09 Dec, 2019 3 commits
  12. 21 Nov, 2019 1 commit
  13. 20 Nov, 2019 1 commit
  14. 17 Nov, 2019 2 commits
  15. 15 Nov, 2019 1 commit
  16. 12 Nov, 2019 3 commits
  17. 26 Jun, 2019 1 commit
  18. 09 Mar, 2019 1 commit
  19. 08 Mar, 2019 2 commits
  20. 27 Feb, 2019 1 commit
  21. 23 Feb, 2019 1 commit
  22. 21 Feb, 2019 1 commit
  23. 11 Feb, 2019 1 commit
  24. 30 Jan, 2019 1 commit
  25. 08 Jan, 2019 1 commit
  26. 04 Jan, 2019 1 commit
  27. 14 Dec, 2018 2 commits
  28. 07 Dec, 2018 1 commit
  29. 23 Nov, 2018 2 commits
  30. 22 Nov, 2018 1 commit