[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Collapse]Office File API
  Demo Application
  Redistribution and Deployment
 [Collapse]Spreadsheet Document API
   Product Structure
   Getting Started
  [Expand]Spreadsheet Document
   Supported Formats
  [Expand]Cell Basics
  [Expand]Spreadsheet Formulas
   Defined Names
   Data Binding
  [Expand]Pivot Tables
   Charting
   Shapes
  [Expand]Mail Merge
  [Collapse]Examples
   [Expand]Files
   [Expand]Workbooks
   [Expand]Worksheets
   [Expand]Rows and Columns
   [Collapse]Cells
     How to: Access a Cell in a Worksheet
     How to: Access a Range of Cells
     How to: Insert a Cell or Cell Range
     How to: Delete a Cell or Range of Cells
     How to: Create a Named Range of Cells
     How to: Change a Cell or Cell Range Value
     How to: Add Formulas to Cells
     How to: Add a Hyperlink to a Cell
     How To: Add a Comment To a Cell
     How to: Clear Cells of Content, Formatting, Hyperlinks and Comments
     How to: Copy Cell Data Only, Cell Style Only, or Cell Data with Style
     How to: Merge Cells or Split Merged Cells
   [Expand]Formulas
   [Expand]Import and Export Data
   [Expand]Data Binding
    Sorting
   [Expand]Mail Merge
    Search
   [Expand]Shapes
   [Expand]Charts
   [Expand]Sparklines
   [Expand]Formatting Cells
   [Expand]Conditional Formatting
   [Expand]Grouping
   [Expand]Filtering
   [Expand]Tables
   [Expand]Pivot Tables
   [Expand]Printing
   [Expand]Pictures
   [Expand]Protection
 [Expand]Word Processing Document API
 [Expand]PDF Document API
 [Expand]Excel Export Library
 [Expand]Snap Report API
 [Expand]Zip Compression and Archive API
 [Expand]Barcode Generation API
 [Expand]Unit Conversion API
 [Expand]API Reference
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

How to: Access a Cell in a Worksheet

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.

The following images demonstrate how rows and columns are indexed in a worksheet and in a specified range of cells (the workbook is opened in Microsoft® Excel®).

Row and Column Indexes and Names in Worksheet

Cell, Row and Column Indexes in a Cell Range

Expanded See Also

Is this topic helpful?​​​​​​​