GemBox.Spreadsheet

RangeIndexingMode Enumeration

Indexing modes used by CellRange.

public enum RangeIndexingMode

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).

Members

Member Name Description
Rectangular Rectangular indexing mode. Rectangular cell range is higher than one row and wider than one column.
Horizontal Horizontal indexing mode. Horizontal cell range has CellRange.Height equal to 1.
Vertical Vertical indexing mode. Vertical cell range has CellRange.Width equal to 1.

Requirements

Namespace: GemBox.Spreadsheet

Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll)

See Also

GemBox.Spreadsheet Namespace | IndexingMode