IWorkbook Palette Property |
Get Palette of colors which an Excel document can have.
Here is a table of color indexes to places in the color tool box
provided by Excel application:
--------------------------------------------
|| 1| 2| 3| 4| 5| 6| 7| 8|
---+----------------------------------------
|1 | 00 | 51 | 50 | 49 | 47 | 10 | 53 | 54 |
|2 | 08 | 45 | 11 | 09 | 13 | 04 | 46 | 15 |
|3 | 02 | 44 | 42 | 48 | 41 | 40 | 12 | 55 |
|4 | 06 | 43 | 05 | 03 | 07 | 32 | 52 | 14 |
|5 | 37 | 39 | 35 | 34 | 33 | 36 | 38 | 01 |
---+----------------------------------------
|6 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 |
|7 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |
--------------------------------------------
Examples
Examples
The following code illustrates how to access the default colors of excel color palette:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Get colors</para><para>System.Drawing.Color[] colors = workbook.Colors;</para><para>//Get color</para><para>System.Drawing.Color color = colors[2];</para><para>//Set color</para><para>worksheet["B2"].Style.Color = 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
See Also
