---
sourceDocument: Yokohama Data and Automation
sourceDocumentLink: https://www.servicenow.com/docs/r/yokohama/integrate-applications

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Data and Automation

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# Use the GetExcelSheetNames component

# Use the GetExcelSheetNames component {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

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://www.servicenow.com/docs/K2IBj6JKSwyqBNqgrPlxeA "Learn about the properties of the Data Reader components in RPA Desktop Design Studio.").

## Procedure

1. In the Toolbox pane, navigate to UtilitiesData Reader.
2. Drag the GetExcelSheetNames component to the Design surface.
3. To configure the input fields, see [Configure port properties](https://www.servicenow.com/docs/d92L75lHSFmmidzeOPPgTw "Configure how data is passed to the input fields of a component or method in RPA Desktop Design Studio.").
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.  
   {#use-datareader-getexcelsheetnames__table_jnw_jn1_krb__entry__4}

   | 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\[\] |
   [ ]

   {#use-datareader-getexcelsheetnames__table_jnw_jn1_krb}
5. To preview the data, right-click the Return field and click Preview Data.
6. **Optional:** To test the component, under the DESIGN tab, click Run.

*[\>]: and then