Hyperlink wanted to be remove from excel

[prajakta_baing (Miss.Prajakta)]

Hello Everyone,

Hope all are doing good.

I have one concern regarding attached excel.I am working on one BOT where all the information copied from one tool and paste it on the excel which is downloaded from some another tool.The values pasted in excel are in hyperlink.I want to remove this hyperlink.could you please suggest how i can remove this hyperlink?

BR,
Prajakta

[Praveen_Mudhiraj]

1. Read the excel with Read Range workbook

   • Read the data from the Excel sheet into a DataTable.

2. For Each Row

   • Iterate through each row in the DataTable.

3. If (Condition to check if hyperlink needs to be removed)

   • Use an “If” activity to check a condition (e.g., if the cell in column “A” contains a hyperlink).

4. Remove Hyperlinks

   • Use the “Remove Hyperlinks” activity to remove hyperlinks from the cell.

5.again write to same excel

@prajakta_baing

[prajakta_baing (Miss.Prajakta)]

Hello @Praveen_Mudhiraj Thank you for prompt response !

I am using studio 2020:10:12 version so there no such remove hyperlink activity.

when i use write cell activity then the hyperlink issue raise.

BR,
Prajakta

[lrtetala (Lakshman Reddy)]

Hi @prajakta_baing

Please check on this thread

How to remove hyperlinks in Excel

@Ishan_Shelke1 Check this below attached workflow, RemoveHyperlinks.zip (9.8 KB) Hope this may help you

Hope this helps!!

[Palaniyappan (Palaniyappan P)]

Try to use this UiPath marketplace component
Where it has an activity to remove hyperlink

BalaReva.Excel.Activities

Hi Friends, I have included a new activity in this package is called “Remove HyperLink”. Namespace. [image] Properties [image] Let me if you have any error. I would be happy to get more suggestions. Regards Balamurugan.S

BalaReva Excel Activities - RPA Component | UiPath Marketplace | Overview

Hope this helps
Cheers @prajakta_baing

[Praveen_Mudhiraj]

HI @prajakta_baing

you can try this way also if have hyper link in excel

you can re write to excel it will remove the HyperLinks

you can check this xaml

Xaml : - Remove_HyperLink.zip (1.8 KB)

for reference you can see the output : -

or you can try this also

How to remove hyperlinks in Excel

@Ishan_Shelke1 Check this below attached workflow, RemoveHyperlinks.zip (9.8 KB) Hope this may help you

[Palaniyappan (Palaniyappan P)]

Check this video on how to use this marketplace activity

BalaReva Excel Activities Remove Hyperlink

Hope this helps

Cheers @prajakta_baing

[prajakta_baing (Miss.Prajakta)]

Thank you @lrtetala @Palaniyappan @Praveen_Mudhiraj for your response However need to use only UiPath packages as per my company polices.
Note : I am using studio 2020:10:12 version.

Any alternative solution please.

[Praveen_Mudhiraj]

Yeah i have not used any other package’s only used UiPath

Just i have return back to excel so it will remove the hyperlink

you can go through this xaml

Xaml : - Remove_HyperLink.zip (1.8 KB)

input : -

output: -

@prajakta_baing