openpyxl.shared.exc.NamedRangeException: Invalid named range string: "0"
Created originally on Bitbucket by Anonymous
I get this error when trying to open a particular xlsx file. Others have worked, but this one gives me this error. This is the traceback:
Traceback (most recent call last): File "C:\Users\uidg8525\workspace\XML_Builder\xmlbuilder.py", line 11, in wb = load_workbook(filename+'.xlsx', data_only=True) File "C:\Python27\myLibraries\ericgazoni-openpyxl-e3bec545653f\openpyxl\reader\excel.py", line 136, in load_workbook _load_workbook(wb, archive, filename, use_iterators, keep_vba) File "C:\Python27\myLibraries\ericgazoni-openpyxl-e3bec545653f\openpyxl\reader\excel.py", line 212, in _load_workbook wb._named_ranges = read_named_ranges(archive.read(ARC_WORKBOOK), wb) File "C:\Python27\myLibraries\ericgazoni-openpyxl-e3bec545653f\openpyxl\reader\workbook.py", line 117, in read_named_ranges destinations = split_named_range(node_text) File "C:\Python27\myLibraries\ericgazoni-openpyxl-e3bec545653f\openpyxl\namedrange.py", line 76, in split_named_range raise NamedRangeException('Invalid named range string: "%s"' % range_string) openpyxl.shared.exc.NamedRangeException: Invalid named range string: "0"
And this is the piece of code that I use to open the file:
from openpyxl import load_workbook import os
filename = raw_input("\nEnter filename: ") filename = os.path.splitext(filename)[0]
wb = load_workbook(filename+'.xlsx', use_iterators = True, data_only=True) ws = wb.get_sheet_by_name(wb.get_sheet_names()[0])
Attachments: SW.xlsx