Get a Worksheet Name

Intelligently retrieves a worksheet name from an Excel file.

Overview

This procedure intelligently handles worksheet selection from an Excel file. If the Excel file contains only one worksheet, it automatically selects that worksheet name. If the Excel file contains multiple worksheets, it presents a selection dropdown to the user for choosing the appropriate worksheet.

Syntax

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

get the excel's worksheet name

What does it do?

Retrieves a worksheet name from the Excel file.

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 defined in the automation.

Examples

1. Get Worksheet Name (Single Sheet)

Automatically selects the worksheet when there's only one.

get the excel's worksheet name

2. Get Worksheet Name (Multiple Sheets)

Prompts user to select from multiple worksheets.

get the excel's worksheet name