Allows URI to be set to a local directory instead of a single file. Aggregates the contents of all identically structured files in the directory to one table per sheet.

Syntax

Connect-Excel -AggregateFiles SwitchParameter

Data Type

bool

Default Value

false

Remarks

When AggregateFiles is set to true, BufferChanges must be set to false.

A single file is used as the metadata document, which defines the expected structure that other files in the aggregation must follow.

You can explicitly set a file to be the metadata document with MetadataDiscoveryURI. If the MetadataDiscoveryURI is not set, the first file in the directory is used as the metadata document.

The cmdlet assumes that all files in the directory have the same basic structure.

If the metadata document includes multiple sheets, the cmdlet will assume all files in the URI have sheets with the same names.

If some sheets are missing columns but otherwise match the metadata document, the missing columns will return null values.

Files that lack sheets present in the metadata document don't contribute to the aggregation in those sheets' tables.