Evotec

Project

PSWriteOffice

PSWriteOffice is an open-source PowerShell and .NET project with packages, release history, and technical documentation.

View on GitHub Releases Get package
Stars 144
Forks 12
Open issues 16
PowerShell Gallery downloads 150,904
Release v0.2.0
Language: C# Updated: 2026-04-06

API Reference

Cmdlet

Set-OfficeExcelRow

Namespace PSWriteOffice
Inputs
None
Outputs
System.Object
Source
Sources/PSWriteOffice/Cmdlets/Excel/SetOfficeExcelRowCommand.cs:17 Edit on GitHub

Writes a row of values to the current worksheet.

Remarks

Writes a row of values to the current worksheet.

Examples

Authored help example

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