Enum CellBorderType

CellBorderType enumeration

Enumerates a cell’s border type.

public enum CellBorderType

Values

NameValueDescription
DashDot9Represents thin dash-dotted line.
DashDotDot11Represents thin dash-dot-dotted line.
Dashed3Represents dashed line.
Dotted4Represents dotted line.
Double6Represents double line.
Hair7Represents hair line.
MediumDashDot10Represents medium dash-dotted line.
MediumDashDotDot12Represents medium dash-dot-dotted line.
MediumDashed8Represents medium dashed line.
None0Represents no line.
Medium2Represents medium line.
SlantedDashDot13Represents slanted medium dash-dotted line.
Thick5Represents thick line.
Thin1Represents thin line.

Examples

namespace AsposeCellsExamples
{
    using Aspose.Cells;
    using System;
    using System.Drawing;

    public class CellBorderTypeDemo
    {
        public static void CellBorderTypeExample()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();

            // Access the first worksheet
            Worksheet worksheet = workbook.Worksheets[0];

            // Create a range (A1:D4)
            Aspose.Cells.Range range = worksheet.Cells.CreateRange("A1", "D4");

            // Get the style of the range
            Style style = workbook.CreateStyle();

            // Set different border styles for the range
            style.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thick;
            style.Borders[BorderType.TopBorder].Color = Color.Black;

            style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Dashed;
            style.Borders[BorderType.BottomBorder].Color = Color.Blue;

            style.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Dotted;
            style.Borders[BorderType.LeftBorder].Color = Color.Green;

            style.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Double;
            style.Borders[BorderType.RightBorder].Color = Color.Red;

            // Apply the style to the range
            StyleFlag styleFlag = new StyleFlag();
            styleFlag.Borders = true;
            range.ApplyStyle(style, styleFlag);

            // Save the workbook
            workbook.Save("CellBorderTypeExample.xlsx");
            workbook.Save("CellBorderTypeExample.pdf");
        }
    }
}

See Also