DataTables > Buttons > Excel > Include URLs on export

gk-dt-buttons-excel-urls.js

document.addEventListener('DOMContentLoaded', function () {
	wp.hooks.addFilter('gk.datatables.options', 'dt-custom-code', function (options) {
		options.buttons = options.buttons.map(button => {
			if ('excel' === button.extend) {
				button.exportOptions = {
					// stripHtml: false,
					format: {
						body: function (data, row, column, node) {
							// Check if the cell data contains an anchor tag
							if (data.indexOf('<a') !== -1) {
								// Create a temporary element to parse the HTML
								var el = document.createElement('div');
								el.innerHTML = data;
								var anchor = el.querySelector('a');
								if (anchor) {
									return anchor.href;
								}
							}
							// Otherwise, return the data as is.
							return data;
						}
					}
				};
			}
			return button;
		});
		return options;
	});
});