Changeset 2e37e80 in rattail for rattail/excel.py

Timestamp:

06/24/2022 02:18:01 PM (7 months ago)

Author:

Lance Edgar <lance@…>

Branches:

master

Children:

a45fe4b

Parents:

f458072

Message:

Add basic date parsing for ExcelReaderXLSX

at least *try* to parse, if given a string value

File:

• rattail/excel.py (modified) (3 diffs)

rattail/excel.py

@@ -128 +128 @@
 
     def __init__(self, path, header_row=1, strip_fieldnames=True,
-                 **kwargs):
+                 datefmt='%Y-%m-%d', **kwargs):
         """
         Constructor; opens an Excel file for reading.
@@ -145 +145 @@
 
         self.header_row = header_row
+        self.datefmt = datefmt
 
         self.fields = None
@@ -183 +184 @@
     # and/or remove it though
     def parse_date(self, value, fmt=None):
+        if isinstance(value, six.string_types):
+            if not value:
+                return
+            return datetime.datetime.strptime(value, fmt or self.datefmt).date()
         return value