XlBorder.BottomColor Property

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

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public XlColor BottomColor { get; set; }

VB.NET

Public Property BottomColor As XlColor

Property Value

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

Remarks

Use the BottomColor property to set or obtain the bottom border color. If you specify the BottomColor for a border without setting it’s XlBordersBase.BottomLineStyle, 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 BottomColor 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-sales-analysis-report/CS/XLExportExample/Form1.cs#L46

headerRowFormatting.Border.TopLineStyle = XlBorderLineStyle.Medium;
headerRowFormatting.Border.BottomColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.0);
headerRowFormatting.Border.BottomLineStyle = XlBorderLineStyle.Medium;

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

headerRowFormatting.Border.TopLineStyle = XlBorderLineStyle.Medium;
headerRowFormatting.Border.BottomColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.0);
headerRowFormatting.Border.BottomLineStyle = XlBorderLineStyle.Medium;

excel-export-library-generate-sales-report/CS/XLExportExampleSalesReport/Form1.cs#L203

formatting.Border = new XlBorder();
formatting.Border.BottomColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.5);
formatting.Border.BottomLineStyle = XlBorderLineStyle.Medium;

VB.NET

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

headerRowFormatting.Border.TopLineStyle = XlBorderLineStyle.Medium
headerRowFormatting.Border.BottomColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.0)
headerRowFormatting.Border.BottomLineStyle = XlBorderLineStyle.Medium

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

headerRowFormatting.Border.TopLineStyle = XlBorderLineStyle.Medium
headerRowFormatting.Border.BottomColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.0)
headerRowFormatting.Border.BottomLineStyle = XlBorderLineStyle.Medium

excel-export-library-generate-sales-report/VB/XLExportExampleSalesReport/Form1.vb#L215

formatting.Border = New XlBorder()
formatting.Border.BottomColor = XlColor.FromTheme(XlThemeColor.Dark1, 0.5)
formatting.Border.BottomLineStyle = XlBorderLineStyle.Medium