XlBorderLineStyle Enum

Lists values used to specify the line styles for cell borders.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

public enum XlBorderLineStyle

VB.NET

Public Enum XlBorderLineStyle

Members

Name	Description
None	Specifies that a border is not painted.
Thin	Specifies the thin solid border line.
Medium	Specifies the medium solid border line.
Dashed	Specifies the thin dashed border line.
Dotted	Specifies the thin dotted border line.
Thick	Specifies the thick solid border line.
Double	Specifies the double border line.
Hair	Specifies the hair border line.
MediumDashed	Specifies the medium dashed border line.
DashDot	Specifies the thin dash-dotted border line.
MediumDashDot	Specifies the medium dash-dotted border line.
DashDotDot	Specifies the thin dash-dot-dotted border line.
MediumDashDotDot	Specifies the medium dash-dot-dotted border line.
SlantDashDot	Specifies the medium slanted dash-dotted border line.

Related API Members

The following properties accept/return XlBorderLineStyle values:

• XlBordersBase.BottomLineStyle
• XlBordersBase.DiagonalDownLineStyle
• XlBordersBase.DiagonalLineStyle
• XlBordersBase.DiagonalUpLineStyle
• XlBordersBase.HorizontalLineStyle
• XlBordersBase.LeftLineStyle
• XlBordersBase.RightLineStyle
• XlBordersBase.TopLineStyle
• XlBordersBase.VerticalLineStyle

Remarks

To specify the line style for a particular border, use the corresponding property of the XlBorder class, which inherits the border line style options from the XlBordersBase class.

• XlBordersBase.BottomLineStyle - sets the line style of a bottom border.
• XlBordersBase.TopLineStyle - sets the line style of a top border.
• XlBordersBase.LeftLineStyle - sets the line style of a left border.
• XlBordersBase.RightLineStyle - sets the line style of a right border.
• XlBordersBase.DiagonalUpLineStyle - sets the line style of an upward diagonal border.
• XlBordersBase.DiagonalDownLineStyle - sets the line style of a downward diagonal border.
• XlBordersBase.DiagonalLineStyle - sets the line style of both upward and downward diagonal borders.

You can also set several borders at once using the XlBorder.OutlineBorders and XlBorder.AllBorders methods. These methods accept the XlBorderLineStyle enumeration member as a parameter.

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 XlBorderLineStyle 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/ConditionalFormattingActions.cs#L290

headerRowFormatting.Border.BottomColor = Color.Black;
headerRowFormatting.Border.BottomLineStyle = XlBorderLineStyle.Thin;
for(int i = 0; i < 3; i++) {

how-to-use-the-excel-export-api-to-generate-an-invoice-t252983/CS/XLExportExample/Form1.cs#L54

// Specify the medium border line style.
headerRowFormatting.Border.TopLineStyle = XlBorderLineStyle.Medium;
// Specify the bottom border for the header row.

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

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

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

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

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

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

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/ConditionalFormattingActions.vb#L289

headerRowFormatting.Border.BottomColor = Color.Black
headerRowFormatting.Border.BottomLineStyle = XlBorderLineStyle.Thin
For i As Integer = 0 To 2

how-to-use-the-excel-export-api-to-generate-an-invoice-t252983/VB/XLExportExample/Form1.vb#L56

' Specify the medium border line style.
headerRowFormatting.Border.TopLineStyle = XlBorderLineStyle.Medium
' Specify the bottom border for the header row.

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

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

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

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

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

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