Search

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!

The JSON is not in a format that Datatables expects. Info regarding data format is here: https://datatables.net/manual/data/ Looks like you have only one column defined but returning more data. You can do that. Your data is in an object rows. I believe you will need to use ajax.dataSrc to change from the default of data to rows. The first example shows this. Kevin

depends. Basically you add a second header row with the appropriated control (text boxes or select boxes or whatever) in the th so it looks something like         <thead>             <tr>                 <th>Name</th>                 <th>Position</th>                 <th>Office</th>                 <th>Age</th>                 <th>Start date</th>                 <th>Salary</th>             </tr>             <tr>                 <th> <input type='text'> </th>                 <th><input type='text'></th>                 <th><select><option value='Tokyo'>Tokyo</option></select></th>                 <th> <select><option value=20>20</option></select> </th>                 <th><input type='text'></th>                 <th><input type='text'></th>             </tr>         </thead> Then you add the appropriate event handlers to trigger the search. It becomes more complicated depending on such things as scroller turned on, or serverSide set to true. I have not seen anything to make me think these feature are already built into DataTables. I can build you a working example if you like but it will be a while before I can get to it.