Skip to content
GitLab
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 264
    • Issues 264
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 6
    • Merge requests 6
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • openpyxl
  • openpyxl
  • Merge requests
  • !26

Add background color to worksheet title tab

  • Review changes

  • Download
  • Email patches
  • Plain diff
Closed Bitbucket Importer requested to merge bitbucket/declined-pr-26 into branch/default Oct 09, 2014
  • Overview 5
  • Commits 0
  • Pipelines 0
  • Changes 0

Created originally on Bitbucket by jphuart (jean pierre huart)

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

By default, the title tab background is white. Adding a property and a method to the worksheet class allow to handle this parameter. The only info to be defined is the desired RGB color code.

Then the Writer.write_properties has been modified to add the property of the generated xlsx file.

It could be useful to add a validation of the provided RGB code, but before proposing one, I wonder if this is not already present in the project, I haven't found it.

If the idea is accepted I can then propose a change to make sure that the tab_color is correctly filled when importing a workbook.

To have an idea on how it works, just have a look at the change in tutorial.rst.

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