Search

Same here. I am using Table Tools along with DataTables, it a wonderful script and there is no competition for it. Definitely. I have been struggling to get the export to work with Complex Headers, i.e. having 2 headers rows, first one with ColSpan and the second one without it. In the export and Copy to clipboard, it only shows the second header row i.e. one without the ColSpans. Has anyone found a way to get around this? I have been banging my head on this for 2 days now without any leads. Another problem that I had been facing was to get the Table Formatting also copied to clipboard thus retaining it when pasting the table in excel. This used to work in ZeroClipboard script that I had used earlier for copying tables.I thought TableTools copy feature was based on ZeroClipboard and this should have worked. Not sure if its my Configuration which is at fault here. Anyone aware of a way through this?

Thanks allan. It works for me. div.DTTT_container { /float: right;/ margin-bottom: 1em; }

exportOptions: { columns: [ 0, 1, 2, 3 ] },

http://live.datatables.net/wiporaga/1/edit

Hello, I'm experiencing difficulties while trying to export tables to pdf/excel/pdf on Android platform. I've tried both Chrome and stock browser (Android 7 on Samsung S7 here) but it fails stating an unknown error occurred. It looks like this official example isn't working either: https://datatables.net/extensions/buttons/examples/initialisation/export.html Can anyone please point me to any solution? Thank you.

I need to display variable number of rows on each page when using pagination. Ex. I have customer id on table, with each customer id there are variable number of rows. I want to display all the data rows of each customer based on customer id on separate pages irrespective of page size.

excelHtml5', title: RPRMM, }, { extend: 'pdfHtml5', title: RPRMM, exportOptions: { columns:

how set orientation landscape when using extend collection i am write with extend PDFhtm5 its working fine but in collection is not working

I need to update export file name and message from an input text field, if i try that in button action then download does not works, if i update that inside button extend options then it only gets the title when it was first loaded no dynamic title. please suggest. example title: $("#export_heading").val() also if i try that in action then download does not work action: function ( e, dt, node, config ) { this.title = $("#export_heading").val() }

Hi all, I saw some questions and no answer about sticky footer, so I am pasting the code I came up with. Somebody may need to use it. customize: function(doc) { var today = new Date(); var dd = today.getDate(); var mm = today.getMonth()+1; //January is 0! var yyyy = today.getFullYear(); if(dd<10){ dd='0'+dd } if(mm<10){ mm='0'+mm } var today = mm+'/'+dd+'/'+yyyy; var cols = []; cols[0] = {text: 'PRINT NAME AND TITLE', alignment: 'left', margin:[10] }; cols[1] = {text: 'DATE:', alignment: 'right', margin:[0,0,20] }; var objFooter = {}; objFooter['alignment'] = 'center'; doc["footer"] = function(currentPage, pageCount) { var footer = [ { alignment: 'left', stack: [ { canvas: [ { type: 'line', x1: 20, y1: 5, x2: 133, y2: 5, lineWidth: 0.5 } ] }, { text: 'PRINT NAME AND TITLE', alignment: 'left', margin:[20, 5, 0, 0] }, { text: today, color: 'grey', fontSize: 8, alignment: 'left', margin:[20, 2, 0, 0] } ] }, { stack: [ { canvas: [ { type: 'line', x1: 240, y1: 5, x2: 286, y2: 5, lineWidth: 0.5 } ] }, { text: 'DATE', alignment: 'right', margin:[0, 5, 20, 0] }, { text: 'Page '+currentPage+" of "+pageCount, alignment: 'right', color: 'grey', fontSize: 8, margin:[0, 2, 20, 0] } ] } ]; objFooter['columns'] = footer; return objFooter; }; } This is returning some text and a line (on top) on the right side, below it the current date. More text and a line (on top) on the left side and then below - the current page of the report. Cheers