Data Reader
The Data Reader components in the RPA Desktop Design Studio enable reading of data from different programs such as MS Excel and CSV.
Note: OLEDB 32 bit is not supported for the Data Reader components.
For details on the issues related to the Data Reader component, see KB article KB1123553 and KB article KB1123554.
- 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. - Use the QueryExcel component
Query data from a Microsoft Excel file with the QueryExcel component in RPA Desktop Design Studio. - Use the ReadFromCSV component
Read data from a CSV file by using the ReadFromCSV component in RPA Desktop Design Studio. - Use the ReadFromExcel component
Extract data from a Microsoft Excel file as a DataTable by using the ReadFromExcel component in RPA Desktop Design Studio. - Use the ReadFromXPS component
Read the data from an XPS file by using the ReadFromXPS component in RPA Desktop Design Studio. - Properties of the Data Reader components
Learn about the properties of the Data Reader components in RPA Desktop Design Studio.
Parent Topic:Utilities