Read hyperlink from excel

[Naveen.Ch (NaWin)]

Hi Team,
@Lahiru.Fernando @loginerror @ovi
We have a requirement to read hyper links from excel, since read range & read cell activity giving output as visible text in excel unable to achieve expected outcome.

Kindly create the feature to read hyper link from excel in background

Best Regards,
Naveen Chaganti

[Darcy22 (Darcy Bennett)]

That would be great.

[Karun (Karun Kumar Nalam)]

Not only read, Need a feature to write hyperlinks into excel also.

[balupad14 (Balamurugan)]

Hi @Naveen.Ch

Check these …

Retrieve hyperlink from a value in a cell in Excel

Hi @Purnima_Sambasivan, Here is an activity called extract hyperlink from BalaReva.EasyExcel package . it extracts the hyperlink , display and colinfo. Input format : [image] Sample : [image] if you know the cell range , you can give like this “A2:A4” Output [image] ExtractHyperLink.zip (39.7 KB) Thank you Balamurugan.S

Retrieve hyperlink from a value in a cell in Excel

Hi @Purnima_Sambasivan, It may help you… There is an activity called “Add Hyperlink from Datatable” from BalaReve.Excel package. [image] Here I have attached the sample that it copies (Sheet1) the hyperlink data into a datatable. After It will transform the data table to a hyperlink source and write in the excel sheet2. Here is the sample : ExtractHyperLink.zip (41.0 KB) Final output from sheet2: [image] Thank you Balamurugan.S

/R
Balamurugan.S