to all -
pretty new to the webdatagrid. i have a export to excel option on one of my aspx pages which works well, but when the spreadsheet opens, the order number (which is a hyperlink template in the webgrid) looks like this in the excel column:
<a id="WebDataGrid1_it0_0_HyperLink1" href="/Orders/edit/editOrder.asp?id=127277" target="_parent">127277</a> instead of just being the order number: 127277
how can i tell the webdatagrid to format column zero of the excel spreadsheet to just be the order number without the html markup? any help would be appreciated.
Thank you for posting in the community.
In order to export only the desired information from a tepmlated column in WebDataGrid (or a column with injected html), a hidden column which holds the desired data for exporting may be used. Prior to exporting the link column is set to hidden and the hidden column containing the exporting data is made visible. Attached is a small sample illustrating this scenario in practice.
Please let me know if this helps.
wow - that was easy! thanks!