Hi Team,
I am extracting a table from a html file and pasting it in a excel. The original data in the html file (table) are in hyperlink, while pasting in excel i am not getting in the form of hyperlink. Datas are placed in normal text, help needed.
Hi Team,
I am extracting a table from a html file and pasting it in a excel. The original data in the html file (table) are in hyperlink, while pasting in excel i am not getting in the form of hyperlink. Datas are placed in normal text, help needed.
any inputs?
I am using Data Scrapping here.
Have a Look on balarevas Excel component
There IS an add Hyperlink Activity that will do it
I’m looking for the same. Excel ‘Read Range’ activity cannot read the hyperlinks and in my company, I cannot use external libraries like the one created by @balupad14.
Is there an alternative way of reading the hyperlinks?
give a try on placing the hyperlink by using the EXCEl hyperlink formula
thanks, if you meant ‘Read Cell Formula’, that doesn’t work either