Create a Table on a Worksheet Range

Create a table on a specified range in an Excel sheet.

This procedure is part of the Excel Book (BDK). To use this book, you must first learn it in your agent.

Input Concepts

Concept	Description	Type	Required	Default Value
worksheet range	The reference to the Excel range.	excel range reference	Yes	N/A
has headers	A boolean value indicating whether the range has headers. Default is True.	boolean	No	True

Output Concepts

Concept	Description	Type
table	The reference to the created Excel table.	excel table reference

Examples

Create a table on a specified range in an Excel sheet.

get the first sheet
use the above as the sheet
get the sheet's used range
use the above as the range
create a table on the range