Get a Worksheet

Gets a specific worksheet from an Excel file.

Overview

This procedure gets a worksheet from an Excel file, provided the worksheet's name.

Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

get the excel's worksheet where

What does it do?

References an Excel file for the system to retrieve a worksheet from.

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 — A reference to the excel must be previously defined in the automation.

the worksheet name is "worksheet-name"

What does it do?

Specifies the name of the worksheet to retrieve.

Where does it go?

Indented under get the excel's worksheet where.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — Replace worksheet-name with the name of the worksheet to retrieve. If not specified, a question will be raised prompting to provide the worksheet name.

Example

the worksheet name is "Sheet1"

Examples

1. Get the Worksheet

get the excel's worksheet

2. Get the Worksheet with a Specific Sheet Name

get the excel's worksheet where
    the worksheet name is "Summary"