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
  • !26

Closed
Created Oct 09, 2014 by Bitbucket Importer@bitbucket_importerOwner
  • Report abuse
Report abuse

Add background color to worksheet title tab

  • Overview 5
  • Commits 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
Reviewer
Request review from
Time tracking
Source branch: bitbucket/declined-pr-26