Printer file Excel from datatable without

Francesco_25

Hi, how can I delete from Excel the following code present in HTML:
<td class="text-lef"><span class="badge"><?=$array_01[$i]['CDTEST'] ?></span></td> that is, all the code with the <span></span> tags. Thanks

rf1234

What is "Printer file Excel"?

You could use exportOptions and manipulate the data exported to Excel like this:

buttons: [
    {   extend: "excel",
            exportOptions: {
                format: {
                    body: function ( data, row, column, node ) {
                        //replace ampersands and other special chars
                        data = data.replace(/>/g, '>')
                                   .replace(/&lt;/g, '<')
                                   .replace(/&amp;/g, '&')
                                   .replace(/&quot;/g, '"')
                                   .replace(/&#163;/g, '£')
                                   .replace(/&#39;/g, '\'')
                                   .replace(/&#10;/g, '\n');
                        //replace html tags with one space
                        data = data.replace(/<[^>]*>/g, ' ');
                        //replace multiple spaces and tabs etc with one space
                        return data.replace(/\s\s+/g, ' ');
                    },
                    header: function ( data, column ) {
                        //replace html tags with one space
                        return data.replace(/<[^>]*>/g, ' ');
                    }
                }
            }
        },

Just replace this code with what you need to get rid of your span.

franco1968

Ok thank you