Skip to content

Add background color to worksheet title tab

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

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.

Merge request reports