XlThemeColor Enum

Lists the base colors of the document theme.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v18.1.Core.dll

Declaration

C#

public enum XlThemeColor

VB.NET

Public Enum XlThemeColor

Members

Name	Description
None	Specifies that theme colors are not used to set a foreground or background color.
Light1	Specifies the Light 1 text/background color.
Dark1	Specifies the Dark 1 text/background color.
Light2	Specifies the Light 2 text/background color.
Dark2	Specifies the Dark 2 text/background color.
Accent1	Specifies the Accent 1 theme color.
Accent2	Specifies the Accent 2 theme color.
Accent3	Specifies the Accent 3 theme color.
Accent4	Specifies the Accent 4 theme color.
Accent5	Specifies the Accent 5 theme color.
Accent6	Specifies the Accent 6 theme color.
Hyperlink	Specifies the theme color used to highlight the inserted hyperlink.
FollowedHyperlink	Specifies the theme color used to highlight the visited hyperlink.

Related API Members

The following properties accept/return XlThemeColor values:

• XlColor.ThemeColor

Remarks

The values listed by this enumeration are used by following methods:

• XlCellFormatting.Themed - specifies themed formatting for a cell (for details, refer to the How to: Apply Themed Formatting to a Cell example).
• XlColor.FromTheme - creates an XlColor object, which can be used to set the color of different spreadsheet elements (e.g., cell background color, border line color, etc.). To obtain the theme color used to create an XlColor instance, use the XlColor.ThemeColor property.

If you change the document theme by using the IXlDocument.Theme property, the new set of colors corresponding to the selected theme, will be used.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the XlThemeColor enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/SparklineActions.cs#L53

headerRowFormatting.Font.Bold = true;
headerRowFormatting.Font.Color = XlColor.FromTheme(XlThemeColor.Light1, 0.0);
headerRowFormatting.Fill = XlFill.SolidFill(XlColor.FromTheme(XlThemeColor.Accent1, 0.0));

how-to-use-the-excel-export-api-to-generate-a-sales-report-t251810/CS/XLExportExampleSalesReport/Form1.cs#L30

headerRowFormatting.Font.Bold = true;
headerRowFormatting.Font.Color = XlColor.FromTheme(XlThemeColor.Light1, 0.0);
headerRowFormatting.Fill = XlFill.SolidFill(XlColor.FromTheme(XlThemeColor.Accent1, 0.0));

how-to-use-the-excel-export-api-to-perform-a-sales-analysis-t252486/CS/XLExportExample/Form1.cs#L35

oddRowFormatting.CopyFrom(evenRowFormatting);
oddRowFormatting.Fill = XlFill.SolidFill(XlColor.FromTheme(XlThemeColor.Light1, -0.15));

how-to-use-the-excel-export-api-to-generate-a-list-of-employees-t251723/CS/XLExportExample/Form1.cs#L35

oddRowFormatting.CopyFrom(evenRowFormatting);
oddRowFormatting.Fill = XlFill.SolidFill(XlColor.FromTheme(XlThemeColor.Light1, -0.15));

excel-export-library-getting-started-t242354/CS/XLExportExamples/Program.cs#L56

headerRowFormatting.Font.Bold = true;
headerRowFormatting.Font.Color = XlColor.FromTheme(XlThemeColor.Light1, 0.0);
headerRowFormatting.Fill = XlFill.SolidFill(XlColor.FromTheme(XlThemeColor.Accent2, 0.0));

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/SparklineActions.vb#L45

headerRowFormatting.Font.Bold = True
headerRowFormatting.Font.Color = XlColor.FromTheme(XlThemeColor.Light1, 0.0)
headerRowFormatting.Fill = XlFill.SolidFill(XlColor.FromTheme(XlThemeColor.Accent1, 0.0))

how-to-use-the-excel-export-api-to-generate-a-sales-report-t251810/VB/XLExportExampleSalesReport/Form1.vb#L32

headerRowFormatting.Font.Bold = True
headerRowFormatting.Font.Color = XlColor.FromTheme(XlThemeColor.Light1, 0.0)
headerRowFormatting.Fill = XlFill.SolidFill(XlColor.FromTheme(XlThemeColor.Accent1, 0.0))

how-to-use-the-excel-export-api-to-perform-a-sales-analysis-t252486/VB/XLExportExample/Form1.vb#L37

oddRowFormatting.CopyFrom(evenRowFormatting)
oddRowFormatting.Fill = XlFill.SolidFill(XlColor.FromTheme(XlThemeColor.Light1, -0.15))

how-to-use-the-excel-export-api-to-generate-a-list-of-employees-t251723/VB/XLExportExample/Form1.vb#L37

oddRowFormatting.CopyFrom(evenRowFormatting)
oddRowFormatting.Fill = XlFill.SolidFill(XlColor.FromTheme(XlThemeColor.Light1, -0.15))

excel-export-library-getting-started-t242354/VB/XLExportExamples/Program.vb#L53

headerRowFormatting.Font.Bold = True
headerRowFormatting.Font.Color = XlColor.FromTheme(XlThemeColor.Light1, 0.0)
headerRowFormatting.Fill = XlFill.SolidFill(XlColor.FromTheme(XlThemeColor.Accent2, 0.0))