Show / Hide Table of Contents

Formatting Borders

Output: FormattingBorders.xlsx

public void Run()
{
    var workbook = new Workbook();
    var worksheet = workbook.Worksheets[0];
    worksheet.Columns[0].WidthCharacters = 11;

    worksheet["A1"].Value = "Left Thick Border";
    worksheet["B1"].Borders.Left = new Border(BorderStyle.Thick);

    worksheet["A3"].Value = "Right Thick Border";
    worksheet["B3"].Borders.Right = new Border(BorderStyle.Thick);

    worksheet["A5"].Value = "Top Thick Border";
    worksheet["B5"].Borders.Top = new Border(BorderStyle.Thick);

    worksheet["A7"].Value = "Bottom Thick Border";
    worksheet["B7"].Borders.Bottom = new Border(BorderStyle.Thick);

    worksheet["A9"].Value = "Diagonal Up Border";
    worksheet["B9"].Borders.SetDiagonalUpBorder(BorderStyle.Thick);

    worksheet["A11"].Value = "Diagonal Down Border";
    worksheet["B11"].Borders.SetDiagonalDownBorder(BorderStyle.Thick);

    worksheet["A13"].Value = "Slant Dash Dot";
    worksheet["B13"].Borders.SetBoxBorder(BorderStyle.SlantDashDot);

    worksheet["A15"].Value = "Box Red";
    worksheet["B15"].Borders.SetBoxBorder(BorderStyle.Thick, SpreadsheetColor.Red);

    worksheet["A17"].Value = "Thin Cross Green";
    worksheet["B17"].Borders.SetDiagonalCrossBorder(BorderStyle.Thin, SpreadsheetColor.Green);
    workbook.SaveAs("FormattingBorders.xlsx");
}
Back to top Generated by DocFX