On an Excel Export of a dynamically generated grid when the column type is url (hyperlink) the excel export returns a blank column. How do I convert this URL to string or pass an alternate value for that column.
<ExcelExport
data={exportData}
ref={exporter => {this._export = exporter; }}
fileName={`${exportFileName}.xlsx`}>
{this._renderKendoGrid(tableData)}
</ExcelExport>
Hi, Jeremy,
I tried to replicate the reported behavior but the urls were exported properly at my end. Can you compare my sample below with your actual setup and see how they differ?
https://stackblitz.com/edit/react-ympqw5?file=app%2Fmain.jsx
Hi Vessy,
I think it's due to the fact we change the <gridcolumn> to a different field because we don't want to show the URL.
Do you have an example where you show a different value to the URL but all filtering and exporting is done on the display value rather then the hyperlink itself?
Thanks
Sure, Jeremy, below you will find detailed information on how to display different data in the columns viewed in the browser, and the exported ones:
For example:
https://stackblitz.com/edit/react-ctzxdx?file=app%2Fmain.jsx%3AL57