def process_xls(filepath): """ find dde links in excel ole file """ result = [] for stream in xls_parser.XlsFile(filepath).get_streams(): if not isinstance(stream, xls_parser.WorkbookStream): continue for record in stream.iter_records(): if not isinstance(record, xls_parser.XlsRecordSupBook): continue if record.support_link_type in ( xls_parser.XlsRecordSupBook.LINK_TYPE_OLE_DDE, xls_parser.XlsRecordSupBook.LINK_TYPE_EXTERNAL): result.append(record.virt_path.replace(u'\u0003', u' ')) return u'\n'.join(result)
def process_xls(filepath): """find dde links in excel ole file""" result = [] xls_file = None try: xls_file = xls_parser.XlsFile(filepath) for stream in xls_file.iter_streams(): if not isinstance(stream, xls_parser.WorkbookStream): continue for record in stream.iter_records(): if not isinstance(record, xls_parser.XlsRecordSupBook): continue if record.support_link_type in (xls_parser.XlsRecordSupBook.LINK_TYPE_OLE_DDE, xls_parser.XlsRecordSupBook.LINK_TYPE_EXTERNAL): result.append(record.virt_path.replace(u"\u0003", u" ")) return u"\n".join(result) finally: if xls_file is not None: xls_file.close()