Get-OfficeExcelDataModel

Aliases: ExcelDataModel, ExcelPowerQuery

Namespace PSWriteOffice

Aliases

ExcelDataModel ExcelPowerQuery

Inputs

OfficeIMO.Excel.ExcelDocument

Outputs

System.Management.Automation.PSObject

Source

Sources/PSWriteOffice/Cmdlets/Excel/GetOfficeExcelDataModelCommand.cs:18 Edit on GitHub

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

Remarks

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

Examples

Authored help example

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

PS>


$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.

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-OfficeExcelDataModel -InputPath <String> [<CommonParameters>]

Parameter set: Path

Parameters

InputPath String requiredposition: 0pipeline: Falsealiases: FilePath, Path: Workbook path.

Outputs

System.Management.Automation.PSObject

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

Parameter set: Document

Parameters

Document ExcelDocument requiredposition: namedpipeline: True (ByValue): Workbook document.

Outputs

System.Management.Automation.PSObject