A Cell object represents a single cell in a worksheet. To return a Cell object use Worksheet.Cells. Specify the cell by 0-based row and column indexes or by Excel-style reference:

 public sealed class Cell
Public NotInheritable Class Cell

          //--- Get Cell by Excel-style reference
          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          Worksheet ws = wb.Worksheets[0];
          Cell cellA1 = ws.Cells[0,0];

          //--- Get Cell by Excel-style reference
          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          Worksheet ws = wb.Worksheets[0];
          Cell cellA1 = ws.Cells["A1"];
        

          '--- Get Cell by Excel-style reference
          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim ws As Worksheet = wb.Worksheets(0)
          Dim cellA1 As Cell = ws.Cells(0, 0)

          '--- Get Cell by Excel-style reference
          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim ws As Worksheet = wb.Worksheets(0)
          Dim cellA1 As Cell = ws.Cells("A1")
        

Name

Description

ColumnNumber

Comment

ConditionalFormat

DataValidation

Formula

HasComment

HasConditionalFormat

HasDataValidation

IsMerged

Name

RowNumber

Style

Value

ValueType

Name

Description

ApplyStyle(Style)

ClearContent()

ClearRichTextFormatting()

CreateAnchor(Int32, Int32)

CreateHyperlink(String)

GetCharacters(Int32)

GetCharacters(Int32, Int32)

RemoveComment()

RemoveConditionalFormat()

RemoveDataValidation()

SetConditionalFormat(ConditionalFormat)

ToString()

Unmerge()

Name

Description

CellValueType