Free Support Forum - aspose.com

Removing Multiple Hyperlinks with formatting

Nausherwan> Hello! My name is Nausherwan, how may I help you today?
seo> Im seo
seo> Yaa
seo> actually i want to know that
seo> How to remove multi hyperlink
seo> in excel
seo> U can help me?
seo> ??
Nausherwan> ok. please wait
seo> k
Nausherwan> you may try Worksheet.Hyperlinks.Clear()
Nausherwan> this will remove all the hyperlinks
Nausherwan> but you have to update the formatting of the text manually
seo> yes
seo> how
seo> I have no idea
seo> how can i done this
Nausherwan> well, the better way is to remove the hyperlinks one by one by using Worksheet.Hyperlinks.RemoveAt API in a loop
seo> yes
seo> i knw
seo> one by one
Nausherwan> this way the formatting will be removed automatically
seo> but i want multiple
seo> in my excel sheet
seo> 1000 url hyperlink
seo> and i want to remove all hyperlink
seo> at a time
seo> if I will use one by one
seo> so much time
seo> for one by one
seo> so i want to know multi ple
seo> I think ur dont know
seo> well thanks for ur time
Nausherwan> well, there is only one way
Nausherwan> to use Hyperlinks.Clear() method
Nausherwan> so you have to remove the formatting of the cells containing the hyperlinks one by one<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />


This message was posted using Email2Forum by nausherwan.aslam.

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

As per our live chat, we have added a feature enhancement to remove the formatting of the hyperlink text when we remove / clear multiple hyperlinks using Hyperlinks.Clear() method. This issue id for this enhancement in our issue tracking system is: CELLSNET-15015. We will further look into your requirement and get back to you soon.

Thank You & Best Regards,

Hi,

Please try the attached version, we have enhanced the api.

Thank you.

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan