RowCollection Class

Represents a collection of Row in a worksheet.

Object Model

Syntax

Visual Basic
C#

'Declaration

 

<DefaultMemberAttribute("Item")>

Public Class RowCollection 

   Inherits WorksheetElement

'Usage

 

Dim instance As RowCollection

[DefaultMember("Item")]

public class RowCollection : WorksheetElement

Example

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

  {

    var worksheet = doc.Worksheets[ 0 ];        

    worksheet.Rows[ 1 ].Height = 25d;    // Sets second row height.

    worksheet.Rows[ 2 ].Cells[ 3 ].Value = 33d;  // Sets “D3” value.

    doc.Save();

  }

Inheritance Hierarchy

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

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

RowCollection Members
Xceed.Workbooks.NET Namespace