Set-SLRowHeight


Synopsis

Set Row height by index.

Syntax

Description

Set Row height by index.A single row or a range of rows can be specified as input.

Parameters

-WorkBookInstance

Instance of an excel document that can be used for editing.

Required? True
Position? 0
Default value  
Accept pipeline input? true (ByValue)
Accept wildcard characters? False

-WorksheetName

Name of the Worksheet that is to be processed.

Required? False
Position? 1
Default value  
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? False

-RowIndex

The row index. Eg: 2 or 5.

Required? True
Position? 2
Default value  
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? False

-RowHeight

Specifies the row height to be applied. Eg: 20.

Required? True
Position? named
Default value  
Accept pipeline input? false
Accept wildcard characters? False

-StartRowIndex

Specifies the start index of the row range. Eg: 1 .

Required? True
Position? named
Default value  
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? False

-ENDRowIndex

Specifies the end index of the row range. Eg: 7.

Required? True
Position? named
Default value  
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? False

This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).

Inputs

String,Int,SpreadsheetLight.SLDocument

Outputs

SpreadsheetLight.SLDocument

Notes

Examples

Example 1

Set Rowheight of row 3 to 30.

Example 2

Set Rowheight of a range 4 – 6 to 15.

Related links