Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / Row Class
Members Example


In This Topic
    Row Class
    In This Topic
    Represents a row in the Worksheet.
    Syntax
    'Declaration
     
    
    Public Class Row 
       Inherits LinearWorksheetElement
    'Usage
     
    
    Dim instance As Row
    public class Row : LinearWorksheetElement 
    Remarks
    Derives from LinearWorksheetElement.
    Example
    using( var doc = Workbook.Load( "test.xlsx") )
      {
        var worksheet = doc.Worksheets[ 0 ];        
        worksheet.Rows[ 1 ].Cells[ 1 ].Value =  new DateTime( 2021, 7, 1, 10, 22, 33 );   // Sets “B2”.
        worksheet.Rows[ 2 ].Height = 65d;
        doc.Save();
      }
    Inheritance Hierarchy

    System.Object
       Xceed.Workbooks.NET.WorkbookElement
          Xceed.Workbooks.NET.WorksheetElement
             Xceed.Workbooks.NET.StyledWorksheetElement
                Xceed.Workbooks.NET.LinearWorksheetElement
                   Xceed.Workbooks.NET.Row

    Public Properties
     NameDescription
    Public PropertyGets the RowCellCollection.  
    Public PropertySets the DataValidation used by the Row.  
    Public PropertyGets or sets the height of a specific Row.  
    Public PropertyGets the Id of the row within the worksheet. The first row has an Id of 0 while last row has an Id of 1048575. (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Public PropertyGets or sets if the Row or Column is hidden or not. (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Public PropertyGets the Style used by the Worksheet element. (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Top
    Public Methods
     NameDescription
    Public Method  
    Public MethodOverloaded. Overridden. Adjusts the Height based on the highest Cell in the Row.   
    Public MethodRemoves specific elements from the LinearWorksheetElement. (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Public Method  
    Public Method  
    Public Method  
    Public MethodSearches into the content of the Row and replaces all occurences of a specific value with a new value. (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Public MethodSearches into the content of the LinearWorksheetElement and replaces all instances of the searchValues with their corresponding newValues. (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Top
    Protected Methods
     NameDescription
    Protected Internal MethodOverridden.   
    Protected Internal MethodOverridden.   
    Protected Internal MethodOverridden.   
    Protected Internal Method (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Protected Internal MethodOverridden.   
    Protected Internal MethodOverridden.   
    Protected Internal MethodOverridden.   
    Protected Internal MethodOverridden.   
    Protected Internal Method (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Protected Internal MethodOverridden.   
    Protected Internal MethodOverridden.   
    Protected Internal MethodOverridden.   
    Top
    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

    See Also