Specifies the character used to separate the workbook name and worksheet name in the generated table name.

Syntax

Connect-ExcelOnline -SeparatorCharacter string

Data Type

cstr

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