CellCollection Class

Represents a collection of Cell.

Object Model

Syntax

Visual Basic
C#

'Declaration

 

<DefaultMemberAttribute("Item")>

Public Class CellCollection 

   Inherits WorksheetElement

'Usage

 

Dim instance As CellCollection

[DefaultMember("Item")]

public class CellCollection : WorksheetElement

Example

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

  {

    var worksheet = doc.Worksheets[ 0 ];        

    worksheet.Cells[ 1, 0 ].Value =  new DateTime( 2021, 7, 1, 10, 22, 33 );   // Sets cell at “A2”.

    worksheet.Cells[ “B2” ].Value =  125;

    doc.Save();

  }

Inheritance Hierarchy

System.Object
   Xceed.Workbooks.NET.WorkbookElement
      Xceed.Workbooks.NET.WorksheetElement
         Xceed.Workbooks.NET.CellCollection

Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

CellCollection Members
Xceed.Workbooks.NET Namespace