Create a Table on a Worksheet Range
Create a table on a specified range in an Excel sheet.
Note: This operation is part of the Excel Book (BDK). To use this book, you need to 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
Updated 25 days ago