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

Last updated

Was this helpful?