Forums     Knowledge Base     OfficeWriter Online     
 
 
This documentation is for
OfficeWriter v3.8.1
.NET Platform

View Docs for Another
Version or Platform

Programmer's Reference > ExcelApplication API > RowProperties

The RowProperties Object


The RowProperties class represents a single row in a worksheet. To return a RowProperties object, use Worksheet.GetRowProperties.



Examples:

[csharp]
ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Create();
Worksheet ws = wb.Worksheets[0];
RowProperties rowProps = ws.GetRowProperties(0);
[vbnet]
Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Create()
Dim ws As Worksheet = wb.Worksheets(0)
Dim rowProps As RowProperties = ws.GetRowProperties(0)


RowProperties Properties

Property Type Access Description
Height double read
write

Sets or returns the height of the row in points (1/72 of an inch)

Hidden boolean read
write

Sets or returns whether or not the row will be hidden when the workbook is opened in Excel

OutlineCollapsed boolean read
write

Sets or returns whether the row's outlined row group is collapsed

OutlineLevel int read
write

Sets or returns the outline level of the row, as a value between 0 and 7

RowNumber int read

Returns the row's 0-based index

Style Style read
write

Sets or returns a Style object that determines how cells in the row look, including number format, font, orientation, etc



RowProperties Methods

ReturnsSignature and Description
void ApplyStyle ( Style style )

Applies a style to the row

void AutoFitHeight ( )

Sets the width of the row to the height of the tallest cell value in the row



Copyright 2007 © SoftArtisans, Inc. All Rights Reserved.