Extracting hyperlinks from Excel


#1

Hey all, I need to read an Excel workbook that contains cells with hyperlinks and then write those hyperlinks elsewhere (another workbook, actually). All I seem to be getting, with either the Workbook or Excel activities is the text value that appears in the cell.

Thinking that perhaps I need to go to the Interop for this, though I don’t seem to be able find those namespaces anywhere in UiPath.

Any suggestions?

ddk


#2

hi @rabbit_rebozo

Check the below post

2.after importing the namespace
Steps
1.use read range for the excel file
2.use for each row and call datatable
3.Use Open Browser Activity and saw row(“Column Name”).ToString

Thanks
Ashwin S