xlrd 读取内容的超链接

import xlrd

mainData_book = xlrd.open_workbook(‘工作表.xls‘,formatting_info=True)
maindata_sheet = mainData_book.sheet_by_index(0)

# rowVals=maindata_sheet.row_values(0,start_colx=0,end_colx=1)
# print(rowVals)
link = maindata_sheet.hyperlink_map.get((1,0))
url=‘‘ if link is None else link.url_or_path
print(url)

原文：https://www.cnblogs.com/chenxiyuxiao/p/11343727.html