Use the ReadFromExcel component
Extract data from a Microsoft Excel file as a DataTable by using the ReadFromExcel 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
You can configure the properties for the ReadFromExcel component. For more information about these properties, see Properties of the Data Reader components.
Real-world scenario: Importing employee records
An HR department maintains employee details in an Excel file. The ReadFromExcel component extracts this data into a DataTable, which is then used to update an HR management system.
Procedure
In the Toolbox pane, navigate to Utilities > Data Reader.
Drag the ReadFromExcel component to the Design surface.
To configure the input fields, see Configure port properties.
Connect the data and control ports of the ReadFromExcel component to the corresponding ports of the other components as described in the following table.
Parameter Description Data Port type Data type Filepath Path to the Excel file that you can pass from the previously executed component. Data In String Sheetname Name of the sheet in the Excel file that you can pass from a previously executed component. Data In String IsFirstRowHeader Specifies true or false value that indicates the first row of the Excel sheet is a header or not. Data In Boolean Count Returns the total number of rows containing data. Data Out Integer Data Returns the extracted data from the Excel file in a DataTable. Data Out DataTable 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