title: adding hyperlinks in some cells openpyxl
body: <p>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.</p>
  
  <p>I managed to generate the excel with the right format but not generate the hyperlink in some of the cells</p>
  
  <p>My try:
  from openpyxl import Workbook</p>
  
  <pre><code>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],"/results.xlsx") 
  
  def excelMCP(self, sheets,foname):
              wb = Workbook()
              ws = wb.active
              #from here format options (a bit long)
  </code></pre>
  
  <p>My question is can I define that the value is a hyperlink when defining the Column in def summaryMCP and then in excelMCP the format of the link?? And in case, how ? I could not find it so far</p>