Skip to content

GitLab

  • Menu
Projects Groups Snippets
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • O openpyxl
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 233
    • Issues 233
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 3
    • Merge requests 3
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar

Mercurial Paris conference scheduled ! Main event : 2022-09-22. Call for papers deadline: 2022-06-17.

  • openpyxl
  • openpyxl
  • Merge requests
  • !43

Closed
Created Jan 26, 2015 by Bitbucket Importer@bitbucket_importerOwner
  • Report abuse
Report abuse

Make external_links accessible and usable

  • Overview 3
  • Commits 0
  • Changes 0

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.

Assignee
Assign to
Reviewer
Request review from
Time tracking
Source branch: bitbucket/declined-pr-43