How to remove hyperlinks in Excel

Help Robot
,
1

Currently I have some hyperlinks in my excel

I want to remove them with the help of UiPath

(ctr+a → right click → Remove Hyperlinks.) → Currently this I am doing manually to remove hyperlinks

How can I do this with the help of Uipath ?

2

HI @Ishan_Shelke1

You can try with the below depencies , checkout this thread

Regards
Sudharsan

1 Like
3

Hi @Ishan_Shelke1 ,

Could you try reading the Excel Sheet as a Datatable and simply writing the Datatable back to Excel and check?

4

Or simply automate this step itself @Ishan_Shelke1

Regards
Sudharsan

5

How do I do this inside Excel ?

6

Using Typeinto or send hotkey and Click Activities @Ishan_Shelke1

7

alternative using VBA

  1. paste this code in text file e.g. vba.txt 
Function RemoveAllHyperlinks(sheetName As String)
ActiveWorkbook.Sheets(sheetName).Activate
ActiveSheet.Hyperlinks.Delete
ActiveWorkbook.Save
End Function
  1. in excel application scope using invoke VBA activity
    under EntryMethodParameters enter {"SheetName"}
    image
    image1220×346 15.4 KB
1 Like
8

Try this steps

Enable Show modern in the filters

  • Excel Process Scope Activity(Property: Show Excel as True)
    • Use Excel File activity (Resize as Maximize)
      • Type into orSend Hotkey Ctrl +a
      • Right click
      • Click on Remove HyperLink

Note : You need to give the necessary conditions to check the menu item panel displayed(Element Exists) and the condition to check whether the Remove Hyperlink is exists or not(Text Exists)

Regards
Sudharsan

9

@Ishan_Shelke1 Check this below attached workflow,
RemoveHyperlinks.zip (9.8 KB)

Hope this may help you :slight_smile:

10

image

Getting this error

11

Take any Excel @Ishan_Shelke1

Goto File-> Option-> Trust Center-> Macro…->Enable all

image
image1919×1051 123 KB

Regards
Sudharsan

1 Like
12

@Ishan_Shelke1 , Please do below changes in excel settings,

image
image829×679 15.8 KB

For more information check this below link,

Hope this may help you :slight_smile:

1 Like
13

replace Main with RemoveAllHyperlinks @Ishan_Shelke1

1 Like
14

@Ishan_Shelke1

image
image1220×360 16.6 KB

1 Like
15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.