search

vinci1it2000 / formulas

Excel formulas interpreter in Python.
https://formulas.readthedocs.io/
European Union Public License 1.1
358 stars 75 forks source link

Getting AttributeError: 'DefinedNameDict' object has no attribute 'definedName' error in xl_model = formulas.ExcelModel().loads(file_path).finish() #116

Closed sbdongre closed 10 months ago

sbdongre commented 1 year ago

Traceback (most recent call last): File "/home/dongre/Documents/Sandeep/Trading_System/Zerodha/learnsql.py", line 291, in secure_data = single_secure_data(file_name,name) File "/home/dongre/Documents/Sandeep/Trading_System/Zerodha/learnsql.py", line 205, in single_secure_data xl_model = formulas.ExcelModel().loads(file_path).finish() #formulas.ExcelModel().loads(file_path).finish() File "/home/dongre/Documents/Sandeep/Trading_System/Zerodha/venv/lib/python3.10/site-packages/formulas/excel/init.py", line 108, in loads self.load(filename) File "/home/dongre/Documents/Sandeep/Trading_System/Zerodha/venv/lib/python3.10/site-packages/formulas/excel/init.py", line 112, in load book, context = self.add_book(filename) File "/home/dongre/Documents/Sandeep/Trading_System/Zerodha/venv/lib/python3.10/site-packages/formulas/excel/init.py", line 188, in add_book data['references'] = self.add_references(book, context=context) File "/home/dongre/Documents/Sandeep/Trading_System/Zerodha/venv/lib/python3.10/site-packages/formulas/excel/init.py", line 93, in add_references for n in book.defined_names.definedName: AttributeError: 'DefinedNameDict' object has no attribute 'definedName'

MizsakPeterEcon commented 1 year ago

This is duplicate of issue #114 (which is already handled in the 'dev' branch, just not released yet).

sbdongre commented 1 year ago

okay thanks. for now i have downgraded openpyxl to 3.0.10

vinci1it2000 commented 10 months ago

duplicate of issue https://github.com/vinci1it2000/formulas/issues/114