Help > 开发指南 > Excel > API > 示例 > Cell单元格 >

如何：访问工作表中的单元格

此示例演示了访问单个单元格的几种方法。

• 通过 Worksheet.Item 属性按单元格的行和列索引。
• 按单元格引用（例如，A1、B2 等）或按工作表的单元格集合中的行和列索引。使用 CellCollection.Item 属性。
• 按指定行中的列索引或列标题。使用 Row.Item 属性。
  按指定列中的行索引或行标题。使用 Column.Item 属性。
  请参阅如何：访问行或列示例，了解如何获取单个行或列。
• 按单元格索引或按指定单元格范围的行和列索引。使用 CellRange.Item 属性。请参阅如何：访问单元格区域文档，了解如何访问工作表中的单个单元格区域。

Vb.Net

Dim workbook As DevExpress.Spreadsheet.IWorkbook = spreadsheetControl1.Document Dim worksheet As DevExpress.Spreadsheet.Worksheet = workbook.Worksheets(0) Dim cellA1 As DevExpress.Spreadsheet.Cell = worksheet(0, 0) ' Cell A1 Dim cellB2 As DevExpress.Spreadsheet.Cell = worksheet.Cells("B2") ' Cell B2 Dim cellC2 As DevExpress.Spreadsheet.Cell = worksheet.Cells(1, 2) ' Cell C2 Dim cellD3 As DevExpress.Spreadsheet.Cell = worksheet.Cells(2, 3) ' Cell D3 Dim cellE4 As DevExpress.Spreadsheet.Cell = worksheet.Rows(3)("E") ' Cell E4 Dim cellF4 As DevExpress.Spreadsheet.Cell = worksheet.Rows("4")(5) ' Cell F4 Dim cellG5 As DevExpress.Spreadsheet.Cell = worksheet.Columns(6)(4) ' Cell G5 Dim cellH6 As DevExpress.Spreadsheet.Cell = worksheet.Columns("H")(5) ' Cell H6 Dim cellI7 As DevExpress.Spreadsheet.Cell = worksheet.Columns("I")("7") ' Cell I7 ' 访问单元格范围中的单元格。 Dim cellB5 As DevExpress.Spreadsheet.Cell = worksheet.Range("B3:D6")(6) ' Cell B5 Dim cellD6 As DevExpress.Spreadsheet.Cell = worksheet.Range("B3:D6")(3, 2) ' Cell D6

C#

DevExpress.Spreadsheet.IWorkbook workbook = spreadsheetControl1.Document; DevExpress.Spreadsheet.Worksheet worksheet = workbook.Worksheets[0]; DevExpress.Spreadsheet.Cell cellA1 = worksheet[0, 0]; // Cell A1 DevExpress.Spreadsheet.Cell cellB2 = worksheet.Cells["B2"]; // Cell B2 DevExpress.Spreadsheet.Cell cellC2 = worksheet.Cells[1, 2]; // Cell C2 DevExpress.Spreadsheet.Cell cellD3 = worksheet.Cells[2, 3]; // Cell D3 DevExpress.Spreadsheet.Cell cellE4 = worksheet.Rows[3]["E"]; // Cell E4 DevExpress.Spreadsheet.Cell cellF4 = worksheet.Rows["4"][5]; // Cell F4 DevExpress.Spreadsheet.Cell cellG5 = worksheet.Columns[6][4]; // Cell G5 DevExpress.Spreadsheet.Cell cellH6 = worksheet.Columns["H"][5]; // Cell H6 DevExpress.Spreadsheet.Cell cellI7 = worksheet.Columns["I"]["7"]; // Cell I7 //访问单元格范围中的单元格。 DevExpress.Spreadsheet.Cell cellB5 = worksheet.Range["B3:D6"][6]; // Cell B5 DevExpress.Spreadsheet.Cell cellD6 = worksheet.Range["B3:D6"][3, 2]; // Cell D6

下图演示了如何在工作表和单元格区域中为行和列编制索引。

工作表中的行和列索引和名称 

单元格区域中的单元格、行和列索引