Click or drag to resize

IWorkbook SetPaletteColor Method

Set user color for specified element in Color table.
Examples
The following code snippet illustrates how to set palette color:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Set palette color</para><para>workbook.ChangePaletteColor(System.Drawing.Color.Red , 10);</para><para>//Set color</para><para>worksheet["B2"].Style.Color = workbook.Colors[10];</para><para>//Save to file</para><para>workbook.SaveToFile("CellFormats.xlsx");</para>

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
void SetPaletteColor(
	int index,
	Color color
)

Parameters

index
Type: System Int32
Index of Color in array.
color
Type: System.Drawing Color
New color which must be set.
See Also