|
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
| Returns | Signature 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.
|