title: Extracting Hyperlinks From Excel (.xlsx) with Python
body: <p>I have been looking at mostly the xlrd and openpyxl libraries for Excel file manipulation. However, xlrd currently does not support <code>formatting_info=True</code> for .xlsx files, so I can not use the xlrd <code>hyperlink_map</code> function. So I turned to openpyxl, but have also had no luck extracting a hyperlink from an excel file with it. Test code below (the test file contains a simple hyperlink to google with hyperlink text set to "test"):</p>
  
  <pre><code>import openpyxl
  
  wb = openpyxl.load_workbook('testFile.xlsx')
  
  ws = wb.get_sheet_by_name('Sheet1')
  
  r = 0
  c = 0
  
  print ws.cell(row = r, column = c). value
  print ws.cell(row = r, column = c). hyperlink
  print ws.cell(row = r, column = c). hyperlink_rel_id
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>test
  
  None
  </code></pre>
  
  <p>I guess openpyxl does not currently support formatting completely either? Is there some other library I can use to extract hyperlink information from Excel (.xlsx) files?</p>