from openpyxl import Workbook,load_workbook
wb=load_workbook(r'C:\Users\s\Desktop\设置单元格格式\SCT-I10A-B301-LABAE-2.xlsx') #载入excel文件,仅支持.xlsx
print(wb.sheetnames) #取所有sheet名称
lb1=wb['血常规'] #获取一个sheet
lb1['A1'].value='=hyperlink("#血生化!A1","mingcheng")'
excel添加超链接
最新推荐文章于 2022-08-17 20:29:11 发布