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


In This Topic
    Row Class
    In This Topic
    Represents a row in the Worksheet.
    Object Model
    Row ClassRowCellCollection ClassCell ClassDataValidation ClassStyle ClassStyle Class
    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 PropertyCellsGets the RowCellCollection.  
    Public PropertyDataValidationSets the DataValidation used by the Row.  
    Public PropertyHeightGets or sets the height of a specific Row.  
    Public PropertyIdGets 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 PropertyIsHiddenGets or sets if the Row or Column is hidden or not. (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Public PropertyStyleGets the Style used by the Worksheet element. (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Top
    Public Methods
     NameDescription
    Public MethodAddConditionalFormatting  
    Public MethodAutoFitOverloaded. Overridden. Adjusts the Height based on the highest Cell in the Row.   
    Public MethodClearRemoves specific elements from the LinearWorksheetElement. (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Public MethodClearConditionalFormattings  
    Public MethodGetConditionalFormattings  
    Public MethodRemoveConditionalFormatting  
    Public MethodReplaceContentSearches 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 MethodReplaceContents<TSearch,TNew>Searches 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 MethodAddCellOverridden.   
    Protected Internal MethodCanWriteOverridden.   
    Protected Internal MethodGetCellsOverridden.   
    Protected Internal MethodGetNewStyle (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Protected Internal MethodReadOverridden.   
    Protected Internal MethodReadStyleOverridden.   
    Protected Internal MethodRemoveCellOverridden.   
    Protected Internal MethodResetOverridden.   
    Protected Internal MethodUpdateChildrenStyleProperty (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Protected Internal MethodUpdateStyleBordersOverridden.   
    Protected Internal MethodWriteOverridden.   
    Protected Internal MethodWriteStyleOverridden.   
    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

    Row Members
    Xceed.Workbooks.NET Namespace

    Send Feedback