How to export hyperlinks to Excel?

Alex asked on July 22, 2019

Hello,
 
I have reports with hyperlinks which were implemented based on this example (https://jsfiddle.net/flexmonster/q1gtwj48/)
 
I have this lines in customizeCell event handler
cell.text = `<a href=”${data.escapedLabel}” target=”_blank” class=”link”>Link</a>`;
cell.style[‘z-index’] = 2;
 
After the data export to Excel the word ‘Link’ is displayed in the column with hyperlinks.
 
How to correctly export hyperlinks to Excel ?
 
Thanks for your help.

3 answers

Public
Vera Didenko Flexmonster July 23, 2019

Hello, Alex,
 
 
Thank you for writing to us.
 
 
At the moment Flexmonster doesn’t support preserving the hyperlinks when exporting to Excel.
 
 
Please let us know if this feature is critical for you.
 
 
Best Regards,
Vera

Public
Ilya July 23, 2019

Hello, Vera. 
This feature is critical for us, because of our biggest client, who wants to see links in Excel-files and asks us about that.

Public
Vera Didenko Flexmonster July 24, 2019

Hello, Ilya,
 
Thank you for your reply.
 
Our team has added your request for preserving hyperlinks during export to our clients’ wishlist.
However, we cannot provide an ETA since our roadmap is full at the moment.
We will notify you in case of any changes on the matter.
 
Meanwhile, our team kindly suggests the following workaround:
1) Generate a CSV file 
2) Generate Excel report on the server side with the necessary hyperlinks
 
Please let us know if you have any questions.
 
Best Regards,
Vera

Please login or Register to Submit Answer