title: Python openpyxl lose hyperlink when modifying existed files
body: <p>Strangely, when load an existed excel with openpyxl and save it again, the hyperlinks in the file disappears.</p>
  
  <p>Either openpyxl 1.7.2 or the newest 1.8.5 has this problem.</p>
  
  <p>Anyone can help with this problem?</p>
  
  <p>Or is there any better choice than openpyxl?</p>
  
  <p>I know xlrd/xlwt and XlsxWriter, but xlwt doesn't support .xlsx files, and XlsxWriter can't read existed files. I need modify a file many times in my application.</p>
  
  <p>[UPDATED]: Look <a href="https://bitbucket.org/openpyxl/openpyxl/issues/152/hyperlink-returns-empty-string-instead-of" rel="nofollow noreferrer">here</a>. Seems this is bug not yet fixed?</p>
  
  <p>The following code may be helpfull for your test.</p>
  
  <pre><code>#-*- coding: utf-8 -*-
  import openpyxl
  
  def create():
      wb = openpyxl.Workbook()
      ws = wb.worksheets[0]
  
      ws.cell('A1').value = 'Click Me'
      ws.cell('A1').hyperlink = 'http://www.google.com'
  
      wb.save('test1.xlsx')
  
  def rewrite():
      wb = openpyxl.load_workbook('test1.xlsx')
      ws = wb.worksheets[0]
  
      wb.save('test2.xlsx')
  
  if __name__ == '__main__':
      create()
      rewrite()
  </code></pre>
  
  <p>[2017-03-07 UPDATED]: The <a href="https://bitbucket.org/openpyxl/openpyxl/issues/152/hyperlink-returns-empty-string-instead-of" rel="nofollow noreferrer">bug</a> has been fixed, and the problem does not exist any more.</p>