XLRowCollection Class

Represents a collection of XLRow objects that represent the individual rows in each XLSheet.

Object Model

Syntax

Visual Basic
C#

'Declaration
 
<System.Reflection.DefaultMemberAttribute("Item")>
Public Class XLRowCollection

[System.Reflection.DefaultMember("Item")]
public class XLRowCollection

Remarks

The collection has methods for counting, enumerating, adding, and removing rows from the collection.

Example

Note that you can create rows automatically by using the sheet's indexer. For example, the following code retrieves the cell at coordinates (3,3) and in doing so automatically creates four rows and four columns automatically:

C1XLBook book = new C1XLBook();
sheet = book.Sheets[0];
XLCell cell   = sheet[3,3]; // creates 4 rows and 4 columns

Inheritance Hierarchy

System.Object
C1.WPF.Excel.XLRowCollection

Requirements

Target Platforms: 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

XLRowCollection Members
C1.WPF.Excel Namespace