Cmdlet

Get-OfficeExcelDataModel

Aliases: ExcelDataModel, ExcelPowerQuery

Module PSWriteOffice

Aliases

ExcelDataModel ExcelPowerQuery

Inputs

OfficeIMO.Excel.ExcelDocument

Outputs

System.Management.Automation.PSObject

Source

GetOfficeExcelDataModelCommand.cs:21 Edit on GitHub

Inspects workbook data model, query, connection, and external-link package parts.

Syntax

Get-OfficeExcelDataModel [-Path] <String> [<CommonParameters>]

Parameter set: Path

Get-OfficeExcelDataModel -Document <ExcelDocument> [<CommonParameters>]

Parameter set: Document

Examples

Authored help example

Detect query/model metadata that OfficeIMO preserves but does not execute.

$model = Get-OfficeExcelDataModel -Path .\WorkbookWithQueries.xlsx
if ($model.HasDataModelOrQueries) {
    $model.Details | ForEach-Object { "Preserved package part: $_" }
}

Separates preserved connection/query/data-model parts from executable refresh behavior so automation can decide whether Excel refresh is required.

Parameters

-Path String requiredposition: 0aliases: FilePath, InputPathsets: Path: Workbook path.
-Document ExcelDocument requiredpipeline: True (ByValue)sets: Document: Workbook document.

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.