Get Worksheet Names

Retrieves the names of all worksheets in an Excel file.

Overview

This procedure retrieves the names of all worksheets in an Excel file. It's useful when you need to see what sheets are available or to validate a worksheet name before accessing data.

Syntax

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

get the excel's worksheet names

What does it do?

Retrieves all worksheet names 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 All Worksheet Names

Retrieves all worksheet names from the current Excel file.

get the excel's worksheet names

2. Get First Worksheet Name

Gets all worksheet names and selects the first one.

get the excel's worksheet names
get the first worksheet name

3. Get Second Worksheet Name

Gets all worksheet names and selects the second one.

get the excel's worksheet names
get the second worksheet name