Specifies whether to include the file path in table names. This property has no effect when the provider is using the Search API.

Data Type

bool

Default Value

false

Remarks

When set to true, the full file path from the root is added to the table name. The format becomes [Path]_[WorkbookName]_[WorksheetName] instead of the default [WorkbookName]_[WorksheetName]. The character used as a separator is set by SeparatorCharacter.

This property helps differentiate workbooks with the same name stored in different folders.