Click or drag to resize

IWorkbook GetNearestColor Method (Color)

Gets the nearest color to the specified Color structure from Workbook palette.
Examples
The following code illustrates how to get the indexed color from ExcelColors for the given color from Color structure:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Get color</para><para>ExcelColors color = workbook.GetMatchingColor(System.Drawing.Color.Red);</para><para>//Set color</para><para>worksheet["B2"].Style.KnownColor = color;</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 
ExcelColors GetNearestColor(
	Color color
)

Parameters

color
Type: System.Drawing Color
System color.

Return Value

Type: ExcelColors
Color index from workbook palette.
See Also