'Declaration Public Property DefaultWorkbookPaletteMode As WorkbookPaletteMode
public WorkbookPaletteMode DefaultWorkbookPaletteMode {get; set;}
This property determines whether a custom palette will be created or whether to use the standard Excel palette of colors when exporting.
A custom palette will make the exported Excel Workbook appear exactly like the exported grid. However, using a custom palette can cause problems when copying and pasting from one Excel Workbook to another. Since the two workbooks are unlikely to share exactly the same palette, colors may change.
Using the standard Excel palette means that the colors in the Excel Workbook will not exactly match those in the grid. For each color used by the grid, the closest matching color in the standard palette will be used in Excel. Copy and Paste using a Workbook creating using the Standard palette will not result in any color changes - unless the pasting is done onto a Workbook with a custom palette.
Note that the palette mode is determined by the WorkBook. So this property will only be used when the ExcelExport creates a new workbook. If a workbook is passed in to the Export method, then the palette mode of the Workbook is used. To change the palette mode of a Workbook created in code, pass a Infragistics.Documents.Excel.WorkbookPaletteMode into the Workbook constructor.
Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2