In this video, I demonstrate how to read and update a standard Excel file using only UiPath Database activities, without relying on Excel-specific activities like “Excel Application Scope” or “Write Range”.
This approach treats Excel as a database using an OleDb connection, allowing SQL operations such as SELECT, UPDATE, and INSERT directly on the spreadsheet.
Covered in the video:
How to connect to an excel file as a database using OleDb
Execute SQL queries on Excel sheets in uipath
Limitations of using Excel via Database activity (e.g., no schema inference, read/write challenges)
This technique is especially useful for headless automation scenarios where you want to read file with large number of records
Ideal for RPA developers looking to optimize workflows with structured, code-like control over Excel files.
