XlsIO component and removing hyperlinks slowness issue

[Siva]

Hi,

I have large data (more than 25000 rows with 34 columns) being exported to excel using ImportDataTable and it has 5 columns(email id) shown as hyperlinks when it is exported. When excel file is opened, it shows error "We found a problem with some content, do you want to recover", on click on ok ,it repairs and removes hyperlinks. 

To avoid this error, we are trying to remove hyperlinks while export to excel using  range.Hyperlinks.RemoveAt but it is slow and takes more than 1 hour. Do you have better solution for this?

Thanks!

[Ramya Sivakumar]

Hi Siva,

Greetings from Syncfusion.

We are unable to reproduce the issue at our end. The sample which we have tried at our end can be downloaded from the below link.

Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Winforms_Sample1021149073

If your scenario differs from above one, kindly share the issue reproducing sample and confirm the Syncfusion XlsIO version you are using at your end, which will be helpful for us in investigating the query further.

Regards,

Ramya.

[Barry Gibson]

We are getting the same issue did you find a solution?

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Barry,

Kindly help us by sharing the issue reproducing sample, to investigate the query and provide a prompt solution at the earliest.

Regards,

Keerthi.