Read hyperlink from excel

[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