Hi,
In order to connect dynamically to Excel from UiPath I suggest you use OLEDB. Then you will be able to use mysql to retrieve data from the Excel into a data table.
Here is a YouTube video how you can do it:
Hi,
In order to connect dynamically to Excel from UiPath I suggest you use OLEDB. Then you will be able to use mysql to retrieve data from the Excel into a data table.
Here is a YouTube video how you can do it: