Skip to content

KeyError exception parsing =SUBSTITUTE(ASCI!B5,"/","_")&"_"&ASCI!B2&"_"&ASCI!B7 #6

@hvbtup

Description

@hvbtup

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'

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions