Uipath work book activity read cell value containing email ID

[hansen_Lobo]

Hello I am trying to read a cell from xlsx file using workbook activity, But that cell contains email ID, which i have to send email to. But the cell in excel contians the data in hyper link format.

Is there i can do anything in UiPath code that will convert this hyperlink to normal string.

[Gokul001 (Gokul Balaji)]

Hi @hansen_Lobo

Have you check out this thread?

https://forum.uipath.com/t/how-to-remove-hyperlinks-in-excel/447728/15

Excel Removing external links

I disconnected Excel external links using VBScript. To help many people 1. Souce Set objExcel = Createobject(“Excel.Application”) set objWorkbook = objExcel.Workbooks.Open(Wscript.Arguments.Item(0)) aLinks = objWorkbook.LinkSources if not IsEmpty(aLinks) then For Each LinkSource In aLinks objWorkbook.BreakLink LinkSource,1 Next end if objWorkbook.Save objWorkbook.Close objExcel.Quit Set objWorkbook = Nothing Set objExcel = Nothing 2. Using input : Wscript.Argument…

Regards
Gokul

[rajneesh94 (Rajneesh Khare)]

Hi @hansen_Lobo,

If you’re using Read Cell Workbook activity to read a specific cell value, the result output of this activity is by default of String type. To be sure you can use .ToString method on the result output. If you are using some other activity or dealing with a specific scenario, please explain more.

Cheers