SeparatorCharacter
Specifies the character used to separate the workbook name and worksheet name in the generated table name.
Data Type
string
Default Value
"_"
Remarks
The separator character is inserted between the workbook and worksheet names when forming the table name.
For example:
- If set to "_": MyWorkbook_Sheet1
- If set to "-": MyWorkbook-Sheet1
- If set to "#": MyWorkbook#Sheet1