We are trying to create Excel file from Html using Aspose.Cells in C#. We noticed Urls are not created in cells while other texts are also present in Html string.
We have Aspose.Total.2020 license and we are using version 20.3.0.0 of Aspose.Cells.
The following are my c# code :
string strPhrase = "<a href='https://search.doctorevidence.com/search?query=SU8i'><b>rheumatoid arthritis</b></a><br/><ol><li>In post-marketing experience from January 2003 to December 2010, predominantly in patients with <b>rheumatoid arthritis</b>, the reported rate of malignancies is approximately 2.7 per 1,000 patient treatment years.</li><li>Patients had serum samples tested for autoantibodies at multiple time points in <b>rheumatoid arthritis</b> studies I − V.</li><li>Two patients out of 3,441 treated with Humira in all <b>rheumatoid arthritis</b> and psoriatic arthritis studies developed clinical signs suggestive of new-onset lupus-like syndrome.</li><li>In controlled Phase 3 trials of Humira in patients with <b>rheumatoid arthritis</b> and psoriatic arthritis with a control period duration ranging from 4 to 104 weeks, ALT elevations ≥ 3 x ULN occurred in 3.7% of Humira-treated patients and 1.6% of control-treated patients.</li></ol>";
sheet.Cells[rowNo, colNo].HtmlString = strPhrase;
After conducting initial testing, we were able to reproduce the issue you mentioned by using your HTML string with the sample code provided. We found that the issue lies with hyperlinks not being created or added with other text using Cell.HtmlString.
We need to evaluate your issue in detail. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSNET-53859
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.
@jigsk
MS Excel only support a hyperlink applies to a whole cell, so the hyperlink can not be a part of cell’s value.
So we only can try to add the hyperlink to the whole cell, can you accept it ?
We cannot accept it, we require a hyperlink with the text.
I am sharing an html page image with you. The excel file should be the same as the HTML. Annotation_Hyperlink.png (40.2 KB)
@jigsk,
Sorry for any inconvenience caused. Thank you for your feedback and screenshots. Aspose.Cells follows the MS-Excel rules. MS-Excel does not support setting hyperlinks to partial text within cells. Please try it in MS-Excel and share your sample Excel file. We will check it soon.
We tried in the MS-Excel, it does not support hyperlinks with partial text within cells. So we cannot provide the sample excel file. You can close this ticket.
Alright, we will close the ticket. Please note that since MS Excel does not support setting hyperlinks for specific parts of text or content within a cell, Aspose.Cells cannot support it.
If you have any further queries or comments, please feel free to write back to us.