Search

Thank you !! <3 :D

Use the page option of the selector-modifier object. For example: let rows = table.rows( { page: 'current' } ); Allan

after a lot of trial and error I figured it out. This message can be closed.

Maybe you can do something with an pdf export example I made a while back. You can view it on codepen. Good luck.

Please see the Q. DataTables is running slow. How can I speed it up? FAQ. Allan

That would do it if the connection isn't set to be UTF8 by default. Thanks for posting back with your answer! Allan

may be helpful https://datatables.net/examples/advanced_init/footer_callback.html

Duplicate of this thread. Allan

Its impossible to say for sure without a test case, but my guess is that you haven't loaded the DataTables stylesheet. Use the download builder to create a stylesheet for you. Allan

Hi Kevin, Thanks for that link! I reviewed it and changing the code to: "render": function (data, type, row) { if (type === 'export') return '=3+' + 4; return "whatever"; } And the buttons options to: buttons: [ { extend: 'excel', exportOptions: { orthogonal: 'export', }, customize: function (xlsx) { var sheet = xlsx.xl.worksheets['sheet1.xml']; var col = $('col', sheet); $('row c[r^="H"]', sheet).each(function ( index, element) { if (index !== 0) { //change the type to `str` which is a formula $(this).attr('t', 'str'); //append the concat formula $(this).append('<f>' + $('is t', this).text() + '</f>'); //remove the inlineStr $('is', this).remove(); } }); } } ] You were right I needed to understand better the xml structure. Thanks!