XlBorder.TopColor Property

Gets or sets the line color of the cell’s top border.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v23.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public XlColor TopColor { get; set; }

VB.NET

Public Property TopColor As XlColor

Property Value

Type	Description
XlColor	An XlColor object that specifies the border line color.

Remarks

Use the TopColor property to set or obtain the top border color. If you specify the TopColor for a border without setting it’s XlBordersBase.TopLineStyle, the border will not be displayed.

For more information on how to customize cell borders, refer to the How to: Add Cell Borders example.

Related GitHub Examples

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

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-library-generate-an-invoice/CS/XLExportExample/Form1.cs#L344

// Set the top border color to white.
border.TopColor = Color.White;
// Specify the medium border line style.

excel-export-library-generate-sales-analysis-report/CS/XLExportExample/Form1.cs#L44

headerRowFormatting.Border = new XlBorder();
headerRowFormatting.Border.TopColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.0);
headerRowFormatting.Border.TopLineStyle = XlBorderLineStyle.Medium;

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

headerRowFormatting.Border = new XlBorder();
headerRowFormatting.Border.TopColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.0);
headerRowFormatting.Border.TopLineStyle = XlBorderLineStyle.Medium;

VB.NET

excel-export-library-generate-an-invoice/VB/XLExportExample/Form1.vb#L357

' Set the top border color to white.
border.TopColor = Color.White
' Specify the medium border line style.

excel-export-library-generate-sales-analysis-report/VB/XLExportExample/Form1.vb#L49

headerRowFormatting.Border = New XlBorder()
headerRowFormatting.Border.TopColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.0)
headerRowFormatting.Border.TopLineStyle = XlBorderLineStyle.Medium

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

headerRowFormatting.Border = New XlBorder()
headerRowFormatting.Border.TopColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.0)
headerRowFormatting.Border.TopLineStyle = XlBorderLineStyle.Medium