This example demonstrates several ways to access individual cells.
- By row and column indexes of a cell via the Worksheet.Item property.
- By a cell reference (for example, A1, B2, etc.) or by row and column indexes from the worksheet's collection of cells. Use the CellCollection.Item property.
-
By a column index or column heading from the specified row. Use the Row.Item property.
By a row index or row heading from the specified column. Use the Column.Item property.
See the How to: Access a Row or Column example to learn how to get an individual row or column.
- By a cell index or by row and column indexes from the specified range of cells. Use the Range.Item property. See the How to: Access a Range of Cells document to learn how to access an individual range of cells in a worksheet.
| C# |
using DevExpress.Spreadsheet;
IWorkbook workbook = spreadsheetControl1.Document;
Worksheet worksheet = workbook.Worksheets[0];
Cell cellA1 = worksheet[0, 0];
Cell cellB2 = worksheet.Cells["B2"];
Cell cellC2 = worksheet.Cells[1, 2];
Cell cellD3 = worksheet.Cells[2, 3];
Cell cellE4 = worksheet.Rows[3]["E"];
Cell cellF4 = worksheet.Rows["4"][5];
Cell cellG5 = worksheet.Columns[6][4];
Cell cellH6 = worksheet.Columns["H"][5];
Cell cellI7 = worksheet.Columns["I"]["7"];
Cell cellB5 = worksheet.Range["B3:D6"][6];
Cell cellD6 = worksheet.Range["B3:D6"][3, 2];
|
| VB |
Imports DevExpress.Spreadsheet
Dim workbook As IWorkbook = spreadsheetControl1.Document
Dim worksheet As Worksheet = workbook.Worksheets(0)
Dim cellA1 As Cell = worksheet(0, 0)
Dim cellB2 As Cell = worksheet.Cells("B2")
Dim cellC2 As Cell = worksheet.Cells(1, 2)
Dim cellD3 As Cell = worksheet.Cells(2, 3)
Dim cellE4 As Cell = worksheet.Rows(3)("E")
Dim cellF4 As Cell = worksheet.Rows("4")(5)
Dim cellG5 As Cell = worksheet.Columns(6)(4)
Dim cellH6 As Cell = worksheet.Columns("H")(5)
Dim cellI7 As Cell = worksheet.Columns("I")("7")
Dim cellB5 As Cell = worksheet.Range("B3:D6")(6)
Dim cellD6 As Cell = worksheet.Range("B3:D6")(3, 2)
|
The following images demonstrate how rows and columns are indexed in a worksheet and in a cell range.
| Row and Column Indexes and Names in Worksheet |
Cell, Row and Column Indexes in a Cell Range |
 |
 |
See Also