Indicates whether to include workbook files in subdirectories when list.

Data Type

bool

Default Value

false

Remarks

This connection property only takes effect if the URI connection property is set to a folder, rather than a workbook file.

When this connection property is set to True, workbook files in subfolders of the folder specified in the URI property (alongside the workbook files in that folder itself) are used to source sheets, which are exposed as tables. If the AggregateFiles connection property is set to True, sheets from workbook files in subdirectories are candidates for inclusion in aggregate tables.

When this connection property is set to False, the contents of subfolders are ignored.