How to Use Color Palette

Colors and Palette

A palette is the set of colors available for use in creating an image. The use of a standardized palette in a presentation allows the user to create a consistent look. Each Microsoft Excel (97‑2003) file has a palette of 56 colors that can be applied to cells, fonts, gridlines, graphic objects, fills, and lines in a chart.

With Aspose.Cells for Python via .NET it is possible not only to use the palette’s existing colors but also to use custom colors. Before using a custom color, add it to the palette first.

This topic discusses how to add custom colors to the palette.

Add Custom Colors to Palette

Aspose.Cells for Python via .NET supports Microsoft Excel’s 56‑color palette. To use a custom color that is not defined in the palette, add the color to the palette.

Aspose.Cells for Python via .NET provides a class, Workbook, that represents a Microsoft Excel file. The Workbook class provides a change_palette method that takes the following parameters to add a custom color to the palette:

• Custom Color – the custom color to be added.
• Index – the index of the color in the palette that the custom color will replace. Should be between 0‑55.

The example below adds a custom color (Orchid) to the palette before applying it to a font.

The palette holds only 56 colors. When you add a custom color to the palette, the palette is changed and any element in the file formatted with the previous color is also changed. Therefore, when you modify the palette, please be very careful. Moreover, this limitation exists only in XLS (Excel 97‑2003) file format; there is no such limitation for XLSX or other advanced Microsoft Excel (2007, 2010, or 2013) file formats.