aboutsummaryrefslogtreecommitdiffstats
path: root/python/collateral/__init__.py
diff options
context:
space:
mode:
Diffstat (limited to 'python/collateral/__init__.py')
-rw-r--r--python/collateral/__init__.py14
1 files changed, 14 insertions, 0 deletions
diff --git a/python/collateral/__init__.py b/python/collateral/__init__.py
index 99550bc8..bb57df28 100644
--- a/python/collateral/__init__.py
+++ b/python/collateral/__init__.py
@@ -4,3 +4,17 @@ except KeyError:
sys.exit("Please set 'DAILY_DIR' and 'LOG_DIR' in the environment")
from serenitas.utils.remote import SftpClient, SftpClient2
+
+
+# monkeypatching until https://github.com/pandas-dev/pandas/issues/39001 is fixed
+from pandas.io.excel._openpyxl import OpenpyxlReader
+
+old_get_sheet_data = OpenpyxlReader.get_sheet_data
+
+
+def new_get_sheet_data(self, sheet, convert_float):
+ sheet.reset_dimensions()
+ return old_get_sheet_data(self, sheet, convert_float)
+
+
+OpenpyxlReader.get_sheet_data = new_get_sheet_data