Spire.XLS API
Spire.XLS namespace
Spire.Xls
Workbook Class
Workbook Methods
AcceptAllTrackedChanges Method
AddCustomFont Method
AddDigitalSignature Method
AddPivotTableStyle Method
CaculateFormulaValue Method
CalculateAllValue Method
CalculateFormulaValue Method
ChangePaletteColor Method
ClearFontCache Method
ColumnWidthToPixels Method
ContainsFont Method
CopyTheme Method
CopyThemeColor Method
CopyToClipboard Method
CreateEmptySheet Method
CreateEmptySheets Method
CreateFont Method
CreatePivotStyle Method
Dispose Method
FindAllBool Method
FindAllDateTime Method
FindAllNumber Method
FindAllString Method
FindAllTimeSpan Method
FindBool Method
FindDateTime Method
FindNumber Method
FindString Method
FindTimeSpan Method
GetChartSheetByName Method
GetCustomFontParsedResult Method
GetDigitalSignatures Method
GetMatchingColor Method
GetOleSize Method
GetPaletteColor Method
GetSafeSheetName Method
GetSplitPageInfo Method
GetSplitPageTable Method
GetThemeColor Method
InitCalcEngine Method
IsPasswordProtected Method
LoadFromFile Method
LoadFromHtml Method
LoadFromMHtml Method
LoadFromStream Method
LoadFromXml Method
LoadTemplateFromFile Method
PasteFromClipboard Method
PixelsToColumnWidth Method
Protect Method
ProtectWorkbook Method
RejectAllTrackedChanges Method
RemoveAllDigitalSignatures Method
Replace Method
ResetPalette Method
Save Method
SaveAsImage Method
SaveAsTemplate Method
SaveAsXml Method
SaveChartAsEmfImage Method
SaveChartAsImage Method
SaveToFile Method
SaveToHtml Method
SaveToHttpResponse Method
SaveToMarkdown Method
SaveToStream Method
SetGlobalCustomFontsFolders Method
SetMaxDigitWidth Method
SetOleSize Method
SetThemeColor Method
SetWriteProtectionPassword Method
SprBpcmUuRG9jLkRvY3Vt Method
UnProtect Method
UnProtectWorkbook Method
XlsPageToImagedg Method
Click or drag to resize

Workbook ChangePaletteColor Method

Changes the palette for the spreadsheet in the specified index.
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
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public void ChangePaletteColor(
	Color color,
	int index
)

Parameters

color
Type: System.Drawing Color
Color structure
index
Type: System Int32
Palette index,Value should be from 0 to 55
See Also