---
sourceDocument: Brazil Workflow Data Fabric
sourceDocumentLink: https://www.servicenow.com/docs/r/integrate-applications

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Workflow Data Fabric

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# Use the QueryExcel component

# Use the QueryExcel component {#ariaid-title1}

Release version: Brazil  
Updated September 10, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Query data from a Microsoft Excel
file with the QueryExcel 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

You can configure the properties for the QueryExcel component. For more information
about these properties, see [Properties of the Data Reader components](https://www.servicenow.com/docs/xKT50hwY1kgBv2jxdBq0Bw "Learn about the properties of the Data Reader components in RPA Desktop Design Studio.").  

Real-world scenario: Extracting specific sales data
:   A company stores monthly sales data in an Excel file. Using the QueryExcel component, an RPA bot filters sales records for a specific product category and extracts only the relevant data for analysis and
    reporting.

## Procedure

1. In the Toolbox pane, navigate to UtilitiesData Reader.
2. Drag the QueryExcel component to the Design surface.
3. To configure the input fields, see [Configure port properties](https://www.servicenow.com/docs/ED3jBpqtlHH8p~yFFmyRBQ "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 QueryExcel component to the corresponding ports of the other components as described in the following table.  
   {#use-datareader-queryexcel__table_jnw_jn1_krb__entry__4}

   | Parameter | Description | Data Port type | Data type |
   |-|-|-|-|
   | Filepath | The path to the Excel file from a previously executed component. | Data In | String |
   | CommandText | The query from a previously executed component. | Data In | String |
   | IsFirstRowHeader | True or false value that indicates whether the first row of the Excel sheet is a header from a previously executed component. | Data In | Boolean |
   | Count | Returns the total number of rows containing data. | Data Out | Integer |
   | DataTable | Returns the extracted data from the Excel file in a DataTable. | Data Out | DataTable |
   [ ]

   {#use-datareader-queryexcel__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