Search

How can i hide the last column in printing and exporting to excel only but appear in the normal viewing http://jsfiddle.net/andrew_safwat/qokbv1sj/

When printing a page with DataTable,

example (http://datatables.net/examples/advanced_init/row_grouping.html) with PDF printing using table tools? I

to show up when printing as well. I thought

web server config ) for printing utf8 in datatables, but

tabletools gets it for printing. How does one do

but I have not yet found a solution to export input values ​​with commas to Excel. Just use my "toFloat" helper function above. The "de" logic is the one relevant for you. exportableNumber = inputNum.toString().replace( /[\.]/g, "" ).replace( /[\,]/g, "." ); This converts e.g. 1.000.000,00 to 1000000.00 - and that is what Excel and your DBMS will understand. If you don't use thousand separators you can skip the first "replace" statement. I have this logic in the "exportOptions" of my Excel export. I want to convert amounts and percentages so that Excel understands them. I don't want zeroes if empty but spaces. This uses the helper function above. exportOptions: { format: { body: function ( data, row, column, node ) { if ( exportColumnsTwoDecPlaces[column] || exportColumnsFourDecPlaces[column] ) { data = toFloat(data, true); //percent must be adjusted to fraction to work ok if ( exportColumnsFourDecPlaces[column] ) { if (data !== '') { data = data / 100; } } } return data; },

You need to return the data you want displayed, for example: render: function(data, row){ var output=''; $.each(data, function(index, item){ output+='<a href="'+data[index].methodDocUrl+'" target="_blank">'+data[index].methodName+'</a>' }); return output; } The same as your previous column. Kevin

Use the message option of each. message can be given as a function which would return the string to show - in this case the date. PDF example of a message (as a string, not a function). Allan

This is how Buttons strips the tags so anything which is inside <> no matter what the tag is should be removed. If that isn't happening, I would indeed need a test case. Regards, Allan