Set-SLRowValue


Synopsis

Set Row values.

Syntax

Description

Set Row values..
values cannot span multiple rows.Values are set on a single row moving from left to right until the value enumeration stops.

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

-CellReference

The CellReference that specifies the start row and start column. Eg: A5 or AB10

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

-value

User can specify single or multiple values. Value assignment flow is from top to bottom.

Required? True
Position? 3
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,SpreadsheetLight.SLDocument

Outputs

SpreadsheetLight.SLDocument

Notes

Examples

Example 1

Since we specified 3 values(jan,feb & march) the cell values start from b3 and flow right as shown above.

Example 2

Create a table with 3 rows and 3 columns.

Example 3

We build on the previous example by applying some alignment and cellstyles to our table.
Note the above result can be achieved using a gaint piepline but for the sake of legibility the task has been split into various steps.

Example 4

Instead of styling individual rows and columns we can set a tablestyle by specifying the range.

Related links

Stay in touch

Linkedin // RSS Feed