Solution

A speedier and simpler solution is to make use of the database actions instead.

First, we will use the Set variable action to define the full file path of the Excel file to be read.

Next, the action Open SQL connection will be used to open a new connection to a database, in this case, our Excel file.

Note that you will need to input the following as the connection string:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%ExcelFile%;Extended Properties="Excel 12.0 Xml;HDR=YES";

💡Pro tip: If you encounter the error message “Can't connect to data source The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.”, it means you may need to install Microsoft Access Database Engine 2010 Redistributable first.

Then, use the action Execute SQL statement.

To read all the data from the Excel file, copy and paste the following SQL query to the SQL statement field:

Select * from [Sheet1$];

Finally, it it highly recommended to close the database connection using the Close SQL connection action.