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"
5. Get Table with Header Locations (Fast)
Retrieves a table using exact header cell locations - faster than name-based search.
get the worksheet's table where
the first header location is "A6"
the last header location is "DR6"
6. Get Table with Header Locations and Row Limit
Retrieves a table using header locations with a specific number of data rows.
get the worksheet's table where
the first header location is "A6"
the last header location is "DR6"
the row count is 40000
Last updated
Was this helpful?