Get Worksheet Names

Retrieves the names of the worksheets in an Excel file.

Overview

This procedure retrieves the names of all the 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.

Prerequisite Data

These required data elements must be present in the automation before using the procedure.

Data Name	Data Type
the excel	Excel file

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?

Instructs the system to get the names of the worksheets in the Excel file.

Where does it go?

This phrase should be written on a new line.

Is it required?

✅ Yes — This phrase is required in the syntax.

Does it require input data?

⛔ No — This phrase does not require input data.

Examples

1. Get the Names of the Worksheets

get the excel's worksheet names

2. Get the First Worksheet Name

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

3. Get the Second Worksheet Name

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