How to replace my data with data-attribute.

nomad_ch · March 2023

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 · March 2023

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 · March 2023

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 · March 2023

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

Allan

How to replace my data with data-attribute.

How to replace my data with data-attribute.

Answers

Howdy, Stranger!

Categories

DataTables

How to replace my data with data-attribute.

How to replace my data with data-attribute.

Answers

Howdy, Stranger!

Quick Links

Categories

DataTables