A cell represents a rectangle in a Worksheet. Each cell is the intersection of a Row and a Column. It can be accessed by using an address (a combination of a letter and a number, like A1, B2, C3…, where the letter is the Column Id and the number is the Row Id) or by coordinates (by specifying the Row Id first & then the Column Id, for example, 0,0; 2,3; 5;5...). Note that indexes for rows & columns always start at 0.

'Declaration

 

Public Class Cell 

   Inherits StyledWorksheetElement

'Usage

 

Dim instance As Cell

public class Cell : StyledWorksheetElement 

using( var doc = Workbook.Load( "test.xlsx") )

  {

    var worksheet = doc.Worksheets[ 0 ];        

    worksheet.Cells[ "A1" ].Value =  new DateTime( 2021, 7, 1, 10, 22, 33 );  

    worksheet.Cells[0, 1].Formula = “SUM(A2*4%)”;

    doc.Save();

  }