Get an Item from an Excel Worksheet
Retrieves a specific item from a sheet.
Overview
This procedure retrieves a specific item from a worksheet, such as a table, multiple tables, or a key-value pair based on the specified key.
Syntax
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
Examples
1. Get the Worksheet's Table
open the worksheet at "s3://bucket/key"
get the worksheet's table
2. Get the Worksheet's Item by Key
open the worksheet at "s3://bucket/key"
get the worksheet's "Deal ID"
3. Get Table with Location Filter
Retrieves a table from a specific cell range.
get the worksheet's table where
the location is "A1:E10"
4. Get Table with Header Filter
Retrieves a table that contains specific headers.
get the worksheet's table where
the headers are "Pokemon", "Type", "Size", "Finishing Move"
Last updated
Was this helpful?