Use the GetExcelSheetNames component
Get the names of the sheets in an Excel file as part of an automation Workflow by using the GetExcelSheetNames component in RPA Desktop Design Studio.
Before you begin
To use the ReadFromExcel component, install Microsoft Access Database Engine.
Role required: none
About this task
The GetExcelSheetNames component can work with other components or methods in an automation Workflow.
You can configure the properties for the GetExcelSheetNames component. For more information about these properties, see Properties of the Data Reader components.
Procedure
-
In the Toolbox pane, navigate to Utilities > Data Reader.
-
Drag the GetExcelSheetNames component to the Design surface.
-
To configure the input fields, see Configure port properties.
-
Connect the data and control ports of the GetExcelSheetNames component to the corresponding ports of the other components as described in the following table.
Parameter Description Data Port type Data type Filepath The path to the Excel file to get the sheet names. Data In String Return Returns sheet names as array of strings. Data Out String[] -
To preview the data, right-click the Return field and click Preview Data.
-
To test the component, under the DESIGN tab, click Run.
Parent Topic:Data Reader
---
title: Use the GetExcelSheetNames component
description: Get the names of the sheets in an Excel file as part of an automation Workflow by using the GetExcelSheetNames component in RPA Desktop Design Studio.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/australia/integrate-applications/use-datareader-getexcelsheetnames.html
release: australia
topic_type: task
last_updated: "2026-09-10"
reading_time_minutes: 1
breadcrumb: [Data Reader, Utilities, Automation components, RPA Desktop Design Studio, Robotic Process Automation \(RPA\) Hub, Workflow Data Fabric]
---
# Use the GetExcelSheetNames component
Get the names of the sheets in an Excel file as part of an automation Workflow by using the GetExcelSheetNames component in RPA Desktop Design Studio.
## Before you begin
To use the ReadFromExcel component, install [Microsoft Access Database Engine](https://www.microsoft.com/en-us/download/details.aspx?id=54920).
Role required: none
## About this task
The GetExcelSheetNames component can work with other components or methods in an automation Workflow.
You can configure the properties for the GetExcelSheetNames component. For more information about these properties, see [Properties of the Data Reader components](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/util-datareader-prop.md).
## Procedure
1. In the Toolbox pane, navigate to **Utilities** > **Data Reader**.
2. Drag the GetExcelSheetNames component to the Design surface.
3. To configure the input fields, see [Configure port properties](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/configure-input-port-properties.md).
4. Connect the data and control ports of the GetExcelSheetNames component to the corresponding ports of the other components as described in the following table.
|Parameter|Description|Data Port type|Data type|
|---------|-----------|--------------|---------|
|Filepath|The path to the Excel file to get the sheet names.|Data In|String|
|Return|Returns sheet names as array of strings.|Data Out|String\[\]|
5. To preview the data, right-click the **Return** field and click **Preview Data**.
6. To test the component, under the **DESIGN** tab, click **Run**.
**Parent Topic:**[Data Reader](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/datareader-utility.md)
| title | Use the GetExcelSheetNames component |
| description | Get the names of the sheets in an Excel file as part of an automation Workflow by using the GetExcelSheetNames component in RPA Desktop Design Studio. |
| locale | en-US |
| canonical_url | https://www.servicenow.com/docs/r/australia/integrate-applications/use-datareader-getexcelsheetnames.html |
| release | australia |
| topic_type | task |
| last_updated | 2026-09-10 |
| reading_time_minutes | 1 |
| breadcrumb | Data ReaderUtilitiesAutomation componentsRPA Desktop Design StudioRobotic Process Automation \(RPA\) HubWorkflow Data Fabric |