We are creating a bot to automate pdf downloading and printing from an excel sheet.
In an excel sheet, there will be 2 columns. Column A is hyperlink and Column B is Name. We have to click on the hyperlink and from browser we have to download. While saving the download we should name it like Column B.
For this we tried,
Datatable - but that gave only normal text, hyperlink is lost
Read cell - Looping becomes trouble
Here we need your guidance (Reading hyperlink from a column and opening ). Any suggestions/ideas could be more helpful.