DataTables > Buttons > Excel > Exclude HTML tags on export

gk-dt-buttons-excel-html.js

document.addEventListener('DOMContentLoaded', () => {

  wp.hooks.addFilter('gk.datatables.options', 'gv-strip-html-excel', (opts) => {

    opts.buttons = opts.buttons.map((btn) => {

      if (btn.extend === 'excel') {

        // Ensure the sub-objects exist
        btn.exportOptions = btn.exportOptions || {};
        btn.exportOptions.stripHtml = true;          // works on modern Buttons builds

        // Fallback: manual stripping for older builds
        btn.exportOptions.format = btn.exportOptions.format || {};
        btn.exportOptions.format.body = (data, row, col, node) =>
          node ? node.innerText                 // node.innerText is already tag-free
               : data.replace(/<[^>]*?>/g, ''); // just in case

      }
      return btn;
    });

    return opts;
  });

});