z = zipfile.ZipFile(fname)
strings = [el.text for e, el in iterparse(z.open('xl/sharedStrings.xml')) if
    el.tag.endswith('}t')]
rows = []
row = {}
value = ''
for e, el in iterparse(z.open('xl/worksheets/sheet1.xml')):
    if el.tag.endswith('}v'):
        value = el.text
if el.tag.endswith('}c'):
    if el.attrib.get('t') == 's':
        value = strings[int(value)]
letter = el.attrib['r']
while letter[-1].isdigit():
    letter = letter[:-1]
row[letter] = value
value = ''
if el.tag.endswith('}row'):
    rows.append(row)
row = {}
return rows
Reading xlsx files using Python