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.

get the worksheet's item

What does it do?

Retrieves an item from the current worksheet.

Where does it go?

This phrase should be written on a new line.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — Replace item with table, tables, or a specific key name. A reference to the worksheet must be previously defined in the automation.

Example

get the worksheet's table
the location is "A1:D10"

What does it do?

Specifies the cell range to search within.

Where does it go?

Indented under get the worksheet's item where.

Is it required?

❌ No — This phrase is optional.

Does it require data?

✅ Yes — Replace A1:D10 with a cell range in Excel format.

Example

the location is "A1:D10"
the header is "header1"

What does it do?

Specifies a header to search for.

Where does it go?

Indented under get the worksheet's item where.

Is it required?

❌ No — This phrase is optional.

Does it require data?

✅ Yes — Replace header1 with the header name.

Example

the header is "Employee Name"
the headers are "header1", "header2", "header3"

What does it do?

Specifies multiple headers to search for.

Where does it go?

Indented under get the worksheet's item where.

Is it required?

❌ No — This phrase is optional.

Does it require data?

✅ Yes — Replace header1, header2, header3 with a list of header names.

Example

the headers are "Name", "Age", "Department"
the first header location is "A6"

What does it do?

Specifies the exact cell location of the first header (faster than name-based search).

Where does it go?

Indented under get the worksheet's item where.

Is it required?

❌ No — This phrase is optional.

Does it require data?

✅ Yes — Replace A6 with an Excel cell reference where the first header is located. Must be on the same row as the last header location.

Example

the first header location is "A6"
the last header location is "DR6"

What does it do?

Specifies the exact cell location of the last header (faster than name-based search).

Where does it go?

Indented under get the worksheet's item where.

Is it required?

❌ No — This phrase is optional.

Does it require data?

✅ Yes — Replace DR6 with an Excel cell reference where the last header is located. Must be on the same row as the first header location.

Example

the last header location is "DR6"
the row count is 40000

What does it do?

Limits the number of data rows to extract (excluding header).

Where does it go?

Indented under get the worksheet's item where.

Is it required?

❌ No — This phrase is optional.

Does it require data?

✅ Yes — Replace 40000 with the number of data rows to extract. If omitted, extracts to the end of the worksheet.

Example

the row count is 40000

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?