API Reference
Cmdlet
Set-OfficeExcelInternalLinks
Converts cells in a range into internal workbook links.
Remarks
Converts cells in a range into internal workbook links.
Examples
Link a summary range to same-named sheets.
PS>
ExcelSheet 'Summary' { Set-OfficeExcelInternalLinks -Range 'A2:A10' }
Turns each non-empty cell in A2:A10 into an internal link to the sheet with the same name.
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-OfficeExcelInternalLinks [-DestinationSheetScript <ScriptBlock>] [-DisplayScript <ScriptBlock>] [-NoStyle] [-PassThru] -Range <String> [-TargetAddress <String>] [<CommonParameters>]Parameter set:
ContextParameters
- DestinationSheetScript ScriptBlock
- Optional mapping from cell text to destination sheet name.
- DisplayScript ScriptBlock
- Optional mapping from cell text to display text.
- NoStyle SwitchParameter
- Skip hyperlink styling (blue + underline).
- PassThru SwitchParameter
- Emit the worksheet after creating links.
- Range String
- A1 range containing values to convert into internal links.
- TargetAddress String
- Destination cell on the target sheet.
Outputs
OfficeIMO.Excel.ExcelSheet
Set-OfficeExcelInternalLinks [-DestinationSheetScript <ScriptBlock>] [-DisplayScript <ScriptBlock>] -Document <ExcelDocument> [-NoStyle] [-PassThru] -Range <String> [-Sheet <String>] [-SheetIndex <Nullable`1>] [-TargetAddress <String>] [<CommonParameters>]Parameter set:
DocumentParameters
- DestinationSheetScript ScriptBlock
- Optional mapping from cell text to destination sheet name.
- DisplayScript ScriptBlock
- Optional mapping from cell text to display text.
- Document ExcelDocument
- Workbook to operate on outside the DSL context.
- NoStyle SwitchParameter
- Skip hyperlink styling (blue + underline).
- PassThru SwitchParameter
- Emit the worksheet after creating links.
- Range String
- A1 range containing values to convert into internal links.
- Sheet String
- Worksheet name when using Document.
- SheetIndex Nullable`1
- Worksheet index (0-based) when using Document.
- TargetAddress String
- Destination cell on the target sheet.
Outputs
OfficeIMO.Excel.ExcelSheet