Hyperlink broken and removed in downloaded excel

[fangyi_1987]

Hello support,

Could you please help to check is this known issue?

1. I use .NET framework 4.8.0.
2. Spire.XLS version: 12.7.0.0
3. My function: export data from db to excel, and for one column, add hyperlink.
Issues: When export data rows larger than 60000 rows, after open excel, it show hyperlink removed because of broken. But when there are 20000 rows, hyperlink works well.

I use this code to add hyperlink:
HyperLink UrlLink = "sheet.HyperLinks.Add(sheet.Range["I" + (i + 2)])";
UrlLink.TextToDisplay = "xxx";
UrlLink.Type = HyperLinkType.Url;
UrlLink.Address = "xxx";

[Triste.Dai]

Hi,

We appreciate your feedback and would like to resolve this matter promptly.

we recommend upgrading to the latest version of our Spire.XLS 13.10.1 hotfix. It appears that you are currently using a version that is released more than 1 year ago.

Once you have upgraded to the latest version, please proceed with testing the code again. If the problem persists, we kindly request you to provide us with screenshots of the issue and any additional information that can help us reproduce the problem will be appreciated. You can share them with us via email ([email protected]) or attach them here.

Thank you for your understanding and support.

Best regards,
Triste
E-iceblue support team