Use the QueryExcel component

Query data from a Microsoft Excel file with the QueryExcel component in RPA Desktop Design Studio.

시작하기 전에

To use the ReadFromExcel component, install Microsoft Access Database Engine.

Role required: none

이 태스크 정보

You can configure the properties for the QueryExcel component. For more information about these properties, see Properties of the Data Reader components.

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.

프로시저

1. In the Toolbox pane, navigate to Utilities > Data Reader.
2. Drag the QueryExcel component to the Design surface.
3. To configure the input fields, see Configure port properties.
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.

   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

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.