Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / RowCollection Class
Example


In This Topic
    RowCollection Class
    In This Topic
    Represents a collection of Rows in the Worksheet.  
    Object Model
    RowCollection ClassRow Class
    Syntax
    '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

    Public Properties
     NameDescription
    Public PropertyCountGets the number of Rows in the RowCollection.     
    Public PropertyItemOverloaded. Gets a specific Row or RowRange from the RowCollection.  
    Top
    Public Methods
     NameDescription
    Public MethodGetEnumerator  
    Top
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also

    Reference

    RowCollection Members
    Xceed.Workbooks.NET Namespace

    Send Feedback