Identifies the workbook that is used as the source of metadata when aggregating sheets with the AggregateFiles connection property.

Syntax

Connect-Excel -MetadataDiscoveryURI string

Data Type

cstr

Default Value

""

Remarks

When the AggregateFiles connection property is enabled, the cmdlet aggregates the content of identically-named sheets from multiple workbook files into consolidated tables called aggregate sheet tables.

To facilitate aggregation of identically-named sheets, a metadata source workbook must be selected. The cmdlet models each sheet from this workbook as an aggregate sheet table named after that sheet.

You can use this connection property to explicitly designate a workbook file as the metadata source workbook. If this connection properly is not set, the first workbook file in the directory is used as the metadata source workbook.