Project

PSWriteOffice

PSWriteOffice is an open-source PowerShell and .NET project with packages, release history, and technical documentation.

View on GitHub Releases Get package

Stars 144

Forks 12

Open issues 16

PowerShell Gallery downloads 150,904

Release v0.2.0

Language: C# Updated: 2026-04-06

API Reference

Cmdlet

Get-OfficeExcelNamedRange

Namespace PSWriteOffice

Inputs

OfficeIMO.Excel.ExcelDocument

Outputs

System.Management.Automation.PSObject

Source

Sources/PSWriteOffice/Cmdlets/Excel/GetOfficeExcelNamedRangeCommand.cs:19 Edit on GitHub

Gets defined names (named ranges) from an Excel workbook.

Remarks

Gets defined names (named ranges) from an Excel workbook.

Examples

Authored help example

List named ranges.

PS>


Get-OfficeExcelNamedRange -Path .\report.xlsx

Returns workbook-level named ranges.

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-OfficeExcelNamedRange -InputPath <String> [-Name <String>] [-Sheet <String>] [-SheetIndex <Nullable`1>] [<CommonParameters>]

Parameter set: Path

Parameters

InputPath String requiredposition: 0pipeline: Falsealiases: FilePath, Path: Path to the workbook.
Name String optionalposition: namedpipeline: False: Optional named range to retrieve.
Sheet String optionalposition: namedpipeline: False: Optional sheet name for sheet-scoped names.
SheetIndex Nullable`1 optionalposition: namedpipeline: False: Optional sheet index (0-based) for sheet-scoped names.

Outputs

System.Management.Automation.PSObject

Get-OfficeExcelNamedRange -Document <ExcelDocument> [-Name <String>] [-Sheet <String>] [-SheetIndex <Nullable`1>] [<CommonParameters>]

Parameter set: Document

Parameters

Document ExcelDocument requiredposition: namedpipeline: True (ByValue): Workbook to inspect.
Name String optionalposition: namedpipeline: False: Optional named range to retrieve.
Sheet String optionalposition: namedpipeline: False: Optional sheet name for sheet-scoped names.
SheetIndex Nullable`1 optionalposition: namedpipeline: False: Optional sheet index (0-based) for sheet-scoped names.

Outputs

System.Management.Automation.PSObject