'Declaration
Public Class Row Inherits LinearWorksheetElement
'Usage
Dim instance As Row
public class Row : LinearWorksheetElement
'Declaration
Public Class Row Inherits LinearWorksheetElement
'Usage
Dim instance As Row
public class Row : LinearWorksheetElement
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(); }
System.Object
Xceed.Workbooks.NET.WorkbookElement
Xceed.Workbooks.NET.WorksheetElement
Xceed.Workbooks.NET.StyledWorksheetElement
Xceed.Workbooks.NET.LinearWorksheetElement
Xceed.Workbooks.NET.Row
Name | Description | |
---|---|---|
![]() | Cells | Gets the RowCellCollection. |
![]() | DataValidation | Sets the DataValidation used by the Row. |
![]() | Height | Gets or sets the height of a specific Row. |
![]() | Id | Gets 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) |
![]() | IsHidden | Gets or sets if the Row or Column is hidden or not. (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement) |
![]() | Style | Gets the Style used by the Worksheet element. (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement) |
Name | Description | |
---|---|---|
![]() | AddConditionalFormatting | |
![]() | AutoFit | Overloaded. Overridden. Adjusts the Height based on the highest Cell in the Row. |
![]() | Clear | Removes specific elements from the LinearWorksheetElement. (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement) |
![]() | ClearConditionalFormattings | |
![]() | GetConditionalFormattings | |
![]() | RemoveConditionalFormatting | |
![]() | ReplaceContent | Searches into the content of the Row and replaces all occurences of a specific value with a new value. (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement) |
![]() | ReplaceContents<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) |
Name | Description | |
---|---|---|
![]() | AddCell | Overridden. |
![]() | CanWrite | Overridden. |
![]() | GetCells | Overridden. |
![]() | GetNewStyle | (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement) |
![]() | Read | Overridden. |
![]() | ReadStyle | Overridden. |
![]() | RemoveCell | Overridden. |
![]() | Reset | Overridden. |
![]() | UpdateChildrenStyleProperty | (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement) |
![]() | UpdateStyleBorders | Overridden. |
![]() | Write | Overridden. |
![]() | WriteStyle | Overridden. |
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