Namespace: GemBox.SpreadsheetAssembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 37.3.30.1035
public enum RangeIndexingMode
public enum RangeIndexingMode
Public Enumeration RangeIndexingMode
Public Enumeration RangeIndexingMode
|
| Member name | Value | Description |
|---|
| Rectangular | 0 |
Rectangular indexing mode. Rectangular cell range is higher than one row and wider than one column.
|
| Horizontal | 1 |
Horizontal indexing mode. Horizontal cell range has
CellRange.Height equal to 1.
|
| Vertical | 2 |
Vertical indexing mode. Vertical cell range has
CellRange.Width equal to 1.
|
Following code creates horizontal, vertical and rectangular cell ranges and demonstrates how indexing works different in different context.
SetBorders(MultipleBorders, Color, LineStyle) method is used to mark outside borders of the rectangular range.
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"; 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).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" 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).