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
Example 1: 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 <Nullable`1>] [-ClearHeight] [-FirstColumn <Nullable`1>] [-FontName <String>] [-Height <Nullable`1>] [-Hidden <Nullable`1>] [-Italic <Nullable`1>] [-LastColumn <Nullable`1>] -Row <Int32> [-StartColumn <Int32>] [-Underline <Nullable`1>] [-Values <Object[]>] [-WrapText <Nullable`1>] [<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 Nullable`1
- Apply or clear bold styling across the target row span.
- ClearHeight SwitchParameter
- Clear any custom row height.
- FirstColumn Nullable`1
- First 1-based column affected by style options.
- FontName String
- Apply a font family across the target row span.
- Height Nullable`1
- Explicit row height in points.
- Hidden Nullable`1
- Hide or unhide the row. Use -Hidden:$false to unhide.
- Italic Nullable`1
- Apply or clear italic styling across the target row span.
- LastColumn Nullable`1
- Last 1-based column affected by style options.
- Row Int32
- 1-based row index.
- StartColumn Int32
- Starting column index (1-based).
- Underline Nullable`1
- Apply or clear underline styling across the target row span.
- Values Object[]
- Values to write across the row.
- WrapText Nullable`1
- Apply or clear wrap text across the target row span.