title: How to retrieve data from an hyperlink in an excel file?
body: <p>I have some hyperlinks stored in a local excel file. All of them are in one column. E.g</p>
  
  <pre><code>| A  
  | ----------------------------------| 
  | http://vocab.getty.edu/tgn/8699749|
  | http://vocab.getty.edu/tgn/8704811|
  | http://vocab.getty.edu/tgn/8702341|
  | http://vocab.getty.edu/tgn/1063874|
  | http://vocab.getty.edu/tgn/1063880|
  | http://vocab.getty.edu/tgn/7032551|
  |-----------------------------------|
  </code></pre>
  
  <p>Each link points to a page from which I would extract the information related to the field xl:prefLabel and store the result in the column B</p>
  
  <p>Openpyxl could be the solution?</p>
  
  <p>The expected result should be something similar to</p>
  
  <pre><code>| A                                 | B                      |
  | ----------------------------------| ------------------------
  | http://vocab.getty.edu/tgn/8699749| tgn_term:1005671253-fr |
  | http://vocab.getty.edu/tgn/8704811| tgn_term:1005683546-de | 
  | http://vocab.getty.edu/tgn/8702341| tgn_term:1005684314    |
  | http://vocab.getty.edu/tgn/1063874| tgn_term:64447         |
  | http://vocab.getty.edu/tgn/1063880| tgn_term:64453         |
  | http://vocab.getty.edu/tgn/7032551| tgn_term:1001213640    |
  |-----------------------------------|------------------------|
  </code></pre>