dataItem.PropertyURL = =HYPERLINK("${dataItem.PropertyURL}");
i used hyperlink function in our js page but when i export the excel, hyperlink function is showing as text, after editing of cell and press enter then it is creating link otherwise it is showing as text
Output : After export excel excel sheet column showing this
=HYPERLINK("https://google.com")
Required as link :
https://google.com
dataItem.PropertyURL = `=HYPERLINK("${dataItem.PropertyURL}")`;
rows.push({
cells: [
]
})
$.each(exportProps, function (index, val) {
rows[i + 1].cells.push({ value: dataItem[val] })
});