HTML Hyperlink not render as link with 'HtmlString'

Aspose.Cells Product Family
1

Dear Team,
We have html text in Database, to show this text in excel we are using aspose HtmlString property, but hyperlinks converting as normal text. Can you please provide solution for this problem.

Regards
Sreekanth

2

@sreelink,

Thanks for providing us details.

Please provide a sample console application (runnable) with latest version/fix, zip the project and post us here to show the issue, we will check it soon. Also attach your template files (input file(if any) and output file). Moreover, please remove any inter-dependencies for database or data source in your code and use dynamic dataset or data in code, so we could execute your code seamlessly to evaluate your issue precisely and to consequently figure it out soon.

3

Hi Amjad,
I have attached the sample console appliation, where hyperlink <a> is not rendering as link.

Regards
Sreekanth

4

@sreelink,
You may please give a try to the following sample code and share the feedback.

Workbook workbook = new Workbook();
//Get the First sheet.
Worksheet worksheet = workbook.Worksheets[0];

//Add a hyperlink to it.
int index = worksheet.Hyperlinks.Add("A4", 1, 1, "https://www.google.com/");
worksheet.Hyperlinks[index].TextToDisplay = "Go to Google";
worksheet.Hyperlinks[index].ScreenTip = "Click to go to Aspose site";

//Save the excel file.
workbook.Save("Hyperlink_test.xls");