API Reference
Cmdlet
Set-OfficeExcelRow
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 [-AutoFit] [-BackgroundColor <String>] [-Bold <Boolean>] [-ClearHeight] [-FirstColumn <Int32>] [-FontName <String>] [-Height <Double>] [-Hidden <Boolean>] [-Italic <Boolean>] [-LastColumn <Int32>] [-PassThru] -Row <Int32> [-StartColumn <Int32>] [-Underline <Boolean>] [-Values <Object[]>] [-WrapText <Boolean>] [<CommonParameters>]Parameter set:
All Parameter SetsParameters
- AutoFit SwitchParameter
- Auto-fit row height after writing values and applying style.
- BackgroundColor String
- Apply a background color across the target row span.
- Bold Boolean
- Apply or clear bold styling across the target row span.
- ClearHeight SwitchParameter
- Clear any custom row height.
- FirstColumn Int32
- First 1-based column affected by style options.
- FontName String
- Apply a font family across the target row span.
- Height Double
- Explicit row height in points.
- Hidden Boolean
- Hide or unhide the row. Use -Hidden:$false to unhide.
- Italic Boolean
- Apply or clear italic styling across the target row span.
- LastColumn Int32
- Last 1-based column affected by style options.
- PassThru SwitchParameter
- Emit the object created or changed by the command.
- Row Int32
- 1-based row index.
- StartColumn Int32
- Starting column index (1-based).
- Underline Boolean
- Apply or clear underline styling across the target row span.
- Values Object[]
- Values to write across the row.
- WrapText Boolean
- Apply or clear wrap text across the target row span.