A list of cell ranges within spreadsheets to model as tables.

Syntax

Connect-Excel -DefineTables string

Data Type

cstr

Default Value

""

Remarks

This connection property models cell ranges from an Excel workbook as tables. Specify the workbook from which you want to expose sheet ranges as tables with the URI connection property. You must set URI to a single workbook file's path, not a folder, for this connection property to function properly.

To specify which ranges from which sheets in the workbook are modeled as tables, set this connection property's value to a comma-separated list of name-value pairs in the form:

<User-Defined Table Name>=<Sheet Name>!<Starting Cell of Range>:<Ending Cell of Range>

For example, to create tables called "Table1" and "Table2" from the sheet "Sheet1" using ranges A1:N25 and C3:M53, supply the following value for this connection property:

Table1=Sheet1!A1:N25,Table2=Sheet2!C3:M53