This works, but when we download the excel file it won't show the text with hyperlinks, because of the hyperlinks by default it is getting opened with protected view. once you open it in edit mode then only you can see the hyperlink
Code:
<table>
<tr>
<th > Test</th>
</tr>
<tr>
<td data-cell-type="formula">=HYPERLINK("https://forum.jsreport.net/topic/1698/how-to-add-hyperlink-in-html-to-xlsx-recipe/3","Test Hyperlink")</td>
</tr>
</table>
Playground output:
Downloaded file :