Skip to content

Make external_links accessible and usable

Bitbucket Importer requested to merge bitbucket/declined-pr-43 into branch/default

Created originally on Bitbucket by lefticus (Jason Turner)

Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.

On the excel documents I'm working with, external links are stored like:

[1]sheet!A1:Z2

The _external_links member of the workbook object contains the loaded links, however they appear to be in a somewhat random order.

To solve the problem of relating the [1] link to the proper link object, I'm sorting the set of links numerically, such that externalLink1 is loaded in the 1st place and externalLink2 is loaded second, etc. This allows me to use parse the [1] link name from the formula and refer back to external_links[parsed_index - 1] and get to the actual URL.

My python is very weak, so I don't know if I'm sorting them in any way that makes sense, but it Works For Me.

Merge request reports