-
Notifications
You must be signed in to change notification settings - Fork 3
Description
Parsing the formula
=SUBSTITUTE(ASCI!B5,"/","_")&"_"&ASCI!B2&"_"&ASCI!B7 results in an exception:
Traceback (most recent call last):
File "C:\svn\custom\ISP\modules\excel-analyse\src\parse_formulas.py", line 20, in
formula = efp.Formula(cell.value)
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\svn\custom\ISP\modules\excel-analyse.venv\Lib\site-packages\ExcelFormulaParser\Models\formula.py", line 13, in init
self.parser = Parser(input_data)
^^^^^^^^^^^^^^^^^^
File "C:\svn\custom\ISP\modules\excel-analyse.venv\Lib\site-packages\ExcelFormulaParser\Models\parser.py", line 18, in init
self.parsed_formula = self.parse()
^^^^^^^^^^^^
File "C:\svn\custom\ISP\modules\excel-analyse.venv\Lib\site-packages\ExcelFormulaParser\Models\parser.py", line 26, in parse
return self.parse_expression(self.formula)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\svn\custom\ISP\modules\excel-analyse.venv\Lib\site-packages\ExcelFormulaParser\Models\parser.py", line 72, in parse_expression
"components": [self.parse_expression(part) for part in expression_obj.expression]
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\svn\custom\ISP\modules\excel-analyse.venv\Lib\site-packages\ExcelFormulaParser\Models\parser.py", line 36, in parse_expression
expr = self.parse_expression(expr['components'])
~~~~^^^^^^^^^^^^^^
KeyError: 'components'