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

ConceptDescriptionTypeRequiredDefault Value
worksheet rangeThe reference to the Excel range.excel range referenceYesN/A
has headersA boolean value indicating whether the range has headers. Default is True.booleanNoTrue

Output Concepts

ConceptDescriptionType
tableThe 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