Set-OfficeExcelRow

Namespace PSWriteOffice

Inputs

None

Outputs

System.Object

Writes a row of values to the current worksheet.

Remarks

Writes a row of values to the current worksheet.

Examples

Write a row starting at column A.


PS>ExcelSheet 'Data' { Set-OfficeExcelRow -Row 2 -Values 'North', 1200 }

Writes two values into row 2, columns A and B.

Common Parameters

This command supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable.

For more information, see about_CommonParameters.

Syntax

Set-OfficeExcelRow -Row <Int32> [-StartColumn <Int32>] -Values <Object[]> [<CommonParameters>]

Parameter set: All Parameter Sets

Parameters

Row Int32 requiredposition: 0pipeline: False: 1-based row index.
StartColumn Int32 optionalposition: namedpipeline: False: Starting column index (1-based).
Values Object[] requiredposition: 1pipeline: False: Values to write across the row.

Outputs

System.Object