openpyxl.shared.exc.NamedRangeException: Invalid named range string: "0"
Created originally on Bitbucket by mnuhn (Malte Nuhn)
I'm trying to open an xlsx file with openpyxl. I get the error message:
openpyxl.shared.exc.NamedRangeException: Invalid named range string: "0"
I added a print statement to retrieve the variable "range_string":
OFFSET([2]Employees!$A1,0,0,COUNTA([2]Employees!
A1:
A$65536),1) True
What can I do to read the file?