Specifies custom table definitions by mapping table names to sheet ranges in the spreadsheet. Use name-value pairs in the form TableName=SheetName!Range.

Data Type

string

Default Value

""

Remarks

This property allows you to define custom tables in your spreadsheet by mapping each table name to a specific sheet and cell range. These tables are used when querying the data.

Use a comma-separated list of name-value pairs in the format TableName=SheetName!Range. TableName is the name that appears in queries. SheetName is the name of the worksheet, and Range is the cell range containing the data.

For example:

DefineTables="DefinedTable1=Sheet1!A1:N25,DefinedTable2=Sheet2!C3:M53"

In this example, the server defines two tables. The first table is called "DefinedTable1" and points to the range A1 through N25 on the worksheet named "Sheet1". The second table, "DefinedTable2", points to cells C3 through M53 on "Sheet2". These tables appear in the list of available tables when querying the spreadsheet.

If a custom-defined table shares a name with a default-discovered table (such as one based on a worksheet), the custom table overrides the default.