show dimension of an xlsx file

show_xlsx_dimension.py

import zipfile
import xml.sax
import sys

NS = 'http://schemas.openxmlformats.org/spreadsheetml/2006/main'


class NonLocalExit(Exception):
    pass


class H(xml.sax.handler.ContentHandler):
    def startElementNS(self, name, qname, attrs):
        if name == (NS, 'dimension'):
            self.ref = attrs.get((None, 'ref'))
            raise NonLocalExit('found')


parser = xml.sax.make_parser()
parser.setFeature(xml.sax.handler.feature_namespaces, True)
handler = H()
parser.setContentHandler(handler)

with zipfile.ZipFile(sys.argv[1]) as z:
    with z.open('xl/worksheets/sheet1.xml') as f:
        try:
            parser.parse(f)
        except NonLocalExit:
            pass

print(handler.ref)