python的openpyxl模块设置超链接,在某些单元格openpyxl中添加超链接

I have to generate an excel with summary results. The results are included in a list. Some of the elements are values and some links.

I managed to generate the excel with the right format but not generate the hyperlink in some of the cells

My try:

from openpyxl import Workbook

from openpyxl.styles import PatternFill, Border, Side, Alignment, Protection, Font, Fill

from openpyxl.cell import get_column_letter

def summaryMCP(self,result):

c1=Column('Name',[result[0]])

c2=Column('R2 check',[result[1]])

c3=Column('Dir Diff.',[result[2]])

c4=Column('CHI2 Sm-Sc',[result[3]])#Lets say this one is a hyperlink to one image png

c5=Column('Rose Sm-Sc',[result[4]])

s=Sheet("MCP main results", [c1,c2,c3,c4,c5]

excelMCP([s],"/resul