DataTables Excel Export - How to display URLs

By default, DataTables does not include links on an Excel export. With the help of the code snippet below, you'll be able to display URLs on your Excel export files.

document.addEventListener("DOMContentLoaded",function(){wp.hooks.addFilter("gk.datatables.options","dt-custom-code",function(o){return o.buttons=o.buttons.map(t=>("excel"===t.extend&&(t.exportOptions={format:{body:function(t){if(t.indexOf("<a")!==-1){var o=document.createElement("div");return o.innerHTML=t,o.querySelector("a")?o.querySelector("a").href:t}return t}}}),t)),o})});

This code has been minified to make it easy to be copied. Here's a link to the full code.

This JavaScript code should be copied and pasted, as it is, on the Custom JavaScript editor that sits inside View Editor > View Settings metabox > Custom Code tab.


Custom JavaScript added in settings to modify DataTables export, ensuring URLs display in Excel export

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us