Datatables.Buttons hide columns in printing and exporting to excel

Question

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/

$(document).ready(function () {

            $('#example').DataTable({
                dom: 'Brtip',
                buttons: [
                    {
                        extend: 'print'
                    },
                    {
                        extend: 'excel'
                    }
                ]
            });
        });

Answer 1

Use exportOptions Here's how you do it

$(document).ready(function() {
    $('#example').DataTable( {
        dom: 'Bfrtip',
        buttons: [
            {
                extend: 'copyHtml5',
                exportOptions: {
                    columns: [ 0, ':visible' ]
                }
            },
            {
                extend: 'excelHtml5',
                exportOptions: {
                    columns: ':visible'
                }
            },
            {
                extend: 'pdfHtml5',
                exportOptions: {
                    columns: [ 0, 1, 2, 5 ]
                }
            },
            'colvis'
        ]
    } );
} );

https://datatables.net/extensions/buttons/examples/html5/columns.html

Answer 2

$(document).ready(function () {
    $('#example').DataTable({
        dom: 'Brtip',
         buttons: [
            {
           extend: 'print',
           exportOptions: {
           columns: [ 0, 1, 2, 3, 4, 5, 6 ] //Your Column value those you want
               }
             },
             {
              extend: 'excel',
              exportOptions: {
              columns: [ 0, 1, 2, 3, 4 5, 6 ] //Your Column value those you want
             }
           },
         ],
    });
});

Answer 3

Here is the answer

buttons.exportData(), you can specify which columns to export with a column-selector, which takes an array of IDs or Indexes

http://datatables.net/forums/discussion/comment/85649#Comment_85649