Sets borders on one or more excel cells, taking cell position into account.

Parameters

multipleBorders

Borders to set.

lineColor

Line color.

lineStyle

Line style.

Example

Following code creates horizontal, vertical and rectangular cell ranges and demonstrates how indexing works different in different context. SetBorders method is used to mark outside borders of the rectangular range.

[Visual Basic]
    Dim cr As CellRange = excelFile.Worksheets(0).Rows(1).Cells

    cr(0).Value = cr.IndexingMode
    cr(3).Value = "D2"
    cr("B").Value = "B2"

    cr = excelFile.Worksheets(0).Columns(4).Cells

    cr(0).Value = cr.IndexingMode
    cr(2).Value = "E3"
    cr("5").Value = "E5"

    cr = excelFile.Worksheets(0).Cells.GetSubrange("F2", "J8")
    cr.SetBorders(MultipleBorders.Outside, Color.Navy, LineStyle.Dashed)

    cr("I7").Value = cr.IndexingMode
    cr(0, 0).Value = "F2"
    cr("G3").Value = "G3"
    cr(5).Value = "F3" ' Cell range width is 5 (F G H I J).

[C#]
    CellRange cr = excelFile.Worksheets[0].Rows[1].Cells;                

    cr[0].Value = cr.IndexingMode;
    cr[3].Value = "D2";
    cr["B"].Value = "B2";

    cr = excelFile.Worksheets[0].Columns[4].Cells;

    cr[0].Value = cr.IndexingMode;
    cr[2].Value = "E3";
    cr["5"].Value = "E5";

    cr = excelFile.Worksheets[0].Cells.GetSubrange("F2", "J8");
    cr.SetBorders(MultipleBorders.Outside, Color.Navy, LineStyle.Dashed);

    cr["I7"].Value = cr.IndexingMode;
    cr[0,0].Value = "F2";
    cr["G3"].Value = "G3";
    cr[5].Value = "F3"; // Cell range width is 5 (F G H I J).

See Also

CellRange Class | GemBox.Spreadsheet Namespace

---