Separate (Column Rendered) Columns on Excel Export
Separate (Column Rendered) Columns on Excel Export
patrickny
Posts: 14Questions: 6Answers: 0
I am currently combining two columns using the Column Rendering Feature
{ "render": function ( data, type, row ) {
return data +'<br>'+ row[18];
},
"targets": 0
},
However, on the Excel Export, it is exporting the Rendered view. Is there a way on the Excel Export - to NOT display the Combined Rendered column?
buttons: [ {
extend: 'excel',
title:'',
exportOptions: {columns: [ 0, 1, 2, 5 ],}
}, 'print',]
This discussion has been closed.
Answers
Here's an example: http://live.datatables.net/guzasike/1/edit
Although, I can't get the Excel button to show up ..
Here, I combined the AGE and the NAME column, .. and I made the Age column hidden. However, how do I export the NAME column with Just the Name in it, and not the age?
Got it!
http://live.datatables.net/tolezupe/2/edit