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.