The character used to represent path separators when calculating the names of tables based on spreadsheets in nested folders.

Data Type

string

Default Value

"_"

Remarks

The character used to separate path components in such scenarios is taken from the value of this connection property. By default, this separator character is "_".

When the URI connection property is set to a folder, and the IncludeSubdirectories connection property is set to True, workbooks in nested folders are included in the pool of workbooks whose spreadsheets the connector models as tables.

Tables based on spreadsheets in workbooks inside nested folders include the names of all path components relative to the folder specified in URI.

For example, suppose the following:

• The URI is set to C:/Workbooks, and
• IncludeSubdirectories is set to True, and
• There is a workbook file called "MyWorkbook.xlsx" with a sheet called "MySheet" in a folder called C:/Workbooks/NestedWorkbooks.

The connector, by default, calls the resulting table for the "MySheet" sheet: NestedWorkbooks_MyWorkbook.xlsx.MySheet

Note that this includes a character ("_") separating the nested folder ("NestedWorkbooks") and the workbook ("MyWorkbook.xlsx") therein.

This separator applies to an arbitrary number of nested folder levels (as far as the DirectoryRetrievalDepth connection property's value allows).