API Reference
Cmdlet
Get-OfficeExcelTemplateMarker
Lists Excel template markers such as {{Name}} and optionally shows whether supplied values bind to them.
Remarks
Lists Excel template markers such as {{Name}} and optionally shows whether supplied values bind to them.
Examples
Inspect template markers before filling a workbook.
PS>
Get-OfficeExcelTemplateMarker -Path .\Invoice.xlsx -Sheet Invoice -Value @{ Number = 'INV-001'; Total = 123.45 }
Returns one object per marker with address, format, and binding metadata.
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
Get-OfficeExcelTemplateMarker [-MissingOnly] [-Sheet <String>] [-SheetIndex <Int32>] [-Value <Hashtable>] [<CommonParameters>]Parameter set:
ContextParameters
- MissingOnly SwitchParameter
- Only returns markers that are not supplied by -Value.
- Sheet String
- Worksheet name to inspect. Defaults to the current DSL sheet or all workbook sheets.
- SheetIndex Int32
- Worksheet index (0-based) to inspect. Defaults to the current DSL sheet or all workbook sheets.
- Value Hashtable
- Optional marker values used to report which markers are bound and which are still missing.
Outputs
System.Management.Automation.PSObject
Get-OfficeExcelTemplateMarker [-MissingOnly] -Path <String> [-Sheet <String>] [-SheetIndex <Int32>] [-Value <Hashtable>] [<CommonParameters>]Parameter set:
PathParameters
- MissingOnly SwitchParameter
- Only returns markers that are not supplied by -Value.
- Path String
- Workbook path to inspect.
- Sheet String
- Worksheet name to inspect. Defaults to the current DSL sheet or all workbook sheets.
- SheetIndex Int32
- Worksheet index (0-based) to inspect. Defaults to the current DSL sheet or all workbook sheets.
- Value Hashtable
- Optional marker values used to report which markers are bound and which are still missing.
Outputs
System.Management.Automation.PSObject
Get-OfficeExcelTemplateMarker -Document <ExcelDocument> [-MissingOnly] [-Sheet <String>] [-SheetIndex <Int32>] [-Value <Hashtable>] [<CommonParameters>]Parameter set:
DocumentParameters
- Document ExcelDocument
- Workbook to inspect outside the DSL context.
- MissingOnly SwitchParameter
- Only returns markers that are not supplied by -Value.
- Sheet String
- Worksheet name to inspect. Defaults to the current DSL sheet or all workbook sheets.
- SheetIndex Int32
- Worksheet index (0-based) to inspect. Defaults to the current DSL sheet or all workbook sheets.
- Value Hashtable
- Optional marker values used to report which markers are bound and which are still missing.
Outputs
System.Management.Automation.PSObject