openpyxl
openpyxl copied to clipboard
Not a valid coordinate or range
=IFERROR(VLOOKUP(A8,temptb!$A$1:$Z$37,temptb!H$1,FALSE),"")
def compute_cell_value(input: Union[Cell, Tuple]):
if isinstance(input, Tuple):
return tuple(map(compute_cell_value, input))
if not has_formula(input):
return input.value
func = formulas.Parser().ast(input.value)[1].compile()
args = []
sheet = input.parent
for key in func.inputs.keys():
args.append(compute_cell_value(sheet[key]))
return func(*args)
Please check this formula and function.
The error is occur from args.append(compute_cell_value(sheet[key]))
It's not getting the value from other sheet.