corelibraries-devexpress-dot-export-dot-xl-dot-xlborder.md
Gets or sets the line color of the cell’s bottom border.
Namespace : DevExpress.Export.Xl
Assembly : DevExpress.Printing.v25.2.Core.dll
NuGet Package : DevExpress.Printing.Core
public XlColor BottomColor { get; set; }
Public Property BottomColor As XlColor
| Type | Description |
|---|---|
| XlColor |
An XlColor object that specifies the border line color.
|
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.
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.
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;
excel-export-library-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;
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
excel-export-library-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
See Also