openpyxl.shared.exc.NamedRangeException: Invalid named range string: "0"

Issue #235 duplicate
Malte Nuhn
created an issue

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!$A$1,0,0,COUNTA([2]Employees!$A$1:$A$65536),1) True

What can I do to read the file?

Comments (2)

  1. Log in to comment