Evotec

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-OfficeExcelTable

Namespace PSWriteOffice
Inputs
OfficeIMO.Excel.ExcelDocument
Outputs
System.Management.Automation.PSObject
Source
Sources/PSWriteOffice/Cmdlets/Excel/GetOfficeExcelTableCommand.cs:18 Edit on GitHub

Gets Excel tables defined in a workbook.

Remarks

Gets Excel tables defined in a workbook.

Examples

Authored help example

List tables in a workbook.

PS>


Get-OfficeExcelTable -Path .\report.xlsx

Returns table metadata (name, range, sheet).

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-OfficeExcelTable -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 table name filter.
Sheet String optionalposition: namedpipeline: False
Optional sheet name filter.
SheetIndex Nullable`1 optionalposition: namedpipeline: False
Optional sheet index (0-based) filter.

Outputs

System.Management.Automation.PSObject

Get-OfficeExcelTable -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 table name filter.
Sheet String optionalposition: namedpipeline: False
Optional sheet name filter.
SheetIndex Nullable`1 optionalposition: namedpipeline: False
Optional sheet index (0-based) filter.

Outputs

System.Management.Automation.PSObject