def read_sheets_titles(xml_source):
 root = fromstring(xml_source)
 titles_root = root.find(QName('http://schemas.openxmlformats.org/officeDocument/2006/extended-properties', 'TitlesOfParts').text)
 vector = titles_root.find(QName(NAMESPACES['vt'], 'vector').text)
 (parts, names) = get_number_of_parts(xml_source)
 size = parts[names[0]]
 children = [c.text for c in vector.getchildren()]
 return children[:size]

def read_sheets_titles ( xml_source ) : root = fromstring ( xml_source ) titles_root = root . find ( QName ( 'http://schemas.openxmlformats.org/officeDocument/2006/extended-properties' , 'TitlesOfParts' ) . text ) vector = titles_root . find ( QName ( NAMESPACES [ 'vt' ] , 'vector' ) . text ) ( parts , names ) = get_number_of_parts ( xml_source ) size = parts [ names [ 0 ] ] children = [ c . text for c in vector . getchildren ( ) ] return children [ : size ]
read titles for all sheets .