title: hyperlink in pandas (dataframe to excel)
body: <p>I'm trying to create a excel file with url link in a specific column.
  Like this</p>
  
  <p><a href="https://i.stack.imgur.com/eURiC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eURiC.png" alt="Table with lionk"></a></p>
  
  <pre><code>def fill_table(table):
      if elapsed_time &gt; datetime.timedelta(minutes=args.mtime):
          table.loc[len(table)] = [hostname, int(trigger_id), description, eventStartDate, eventEndDate, elapsed_time, message, useralias, link]
  ...
  writer = pd.ExcelWriter(args.output, engine='xlsxwriter')
  </code></pre>
  
  <p>I tried to use the excel hyperlink formula in the link variable</p>
  
  <pre><code>link = '=HYPERLINK(\"{0}/tr_events.php?triggerid={1}&amp;eventid={2}\"; \"{3}\")'.format(args.url, trigger_id,event['eventid'], event['name'])
  </code></pre>
  
  <p>But I get a error message when open the file and the column 'link' fill with zero's</p>