How to replace my data with data-attribute.

nomad_ch

Hi!
I need to replace all data from B row.
Data is taken from <td data-value="wanted string">string</td>
How to replace "string" to "wanted string" (from data-value) ?

 extend: 'excelHtml5',
                    text: 'Excel',
                    customize: function ( xlsx ) {
                        var sheet = xlsx.xl.worksheets['sheet1.xml'];
                        $('row c[r^="B"]', sheet).each( function () {
                              what need to write here?
                         });
                    }

thanks.

colin

This thread may help, it's showing how to change values in the XLS file : https://datatables.net/forums/discussion/75877/how-to-replace-my-data-with-data-attribute#latest

Colin

nomad_ch

Hi, thanks, but you give wrong link (to my thread).
Now i make like this (but its bad, because i dont have current td (like $(this)).

                        var count = 2;
                        $('row c[r^="B"]', sheet).each( function () {
                            var colour = $('#stats_table tr:eq('+parseInt(count)+') td:eq(1)').attr('data-order');
                            count++;

allan

Probably better to use the data formatting function to get the data to export. The customize function is for modifying the Excel file.

Allan