API Reference
Cmdlet
Set-OfficeExcelSmartHyperlink
Sets an external hyperlink using a smart display strategy.
Remarks
Sets an external hyperlink using a smart display strategy.
Examples
Link to an RFC with generated display text.
PS>
ExcelSheet 'Data' { Set-OfficeExcelSmartHyperlink -Address 'A2' -Url 'https://datatracker.ietf.org/doc/html/rfc7208' }
Creates a hyperlink that displays RFC 7208 instead of the full URL.
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-OfficeExcelSmartHyperlink [-Address <String>] [-Column <Nullable`1>] [-NoStyle] [-PassThru] [-Row <Nullable`1>] [-Title <String>] -Url <String> [<CommonParameters>]Parameter set:
ContextParameters
- Address String
- A1-style cell address (e.g., A1, C5).
- Column Nullable`1
- 1-based column index.
- NoStyle SwitchParameter
- Skip hyperlink styling (blue + underline).
- PassThru SwitchParameter
- Emit the worksheet after setting the link.
- Row Nullable`1
- 1-based row index.
- Title String
- Optional preferred display text.
- Url String
- External URL to link to.
Outputs
System.Object
Set-OfficeExcelSmartHyperlink [-Address <String>] [-Column <Nullable`1>] -Document <ExcelDocument> [-NoStyle] [-PassThru] [-Row <Nullable`1>] [-Sheet <String>] [-SheetIndex <Nullable`1>] [-Title <String>] -Url <String> [<CommonParameters>]Parameter set:
DocumentParameters
- Address String
- A1-style cell address (e.g., A1, C5).
- Column Nullable`1
- 1-based column index.
- Document ExcelDocument
- Workbook to operate on outside the DSL context.
- NoStyle SwitchParameter
- Skip hyperlink styling (blue + underline).
- PassThru SwitchParameter
- Emit the worksheet after setting the link.
- Row Nullable`1
- 1-based row index.
- Sheet String
- Worksheet name when using Document.
- SheetIndex Nullable`1
- Worksheet index (0-based) when using Document.
- Title String
- Optional preferred display text.
- Url String
- External URL to link to.
Outputs
System.Object