​

$(document).ready(function() {

    var buttonCommon = {

        exportOptions: {

            format: {

                body: function ( data, row, column, node ) {

                  console.log(table.row(node).data().name);

                    // Strip $ from salary column to make it numeric

                    return column === 5 ?

                        '-' :

                        data;

                }

            }

        }

    };

    var table = $('#example').DataTable( {

        ajax: '/ajax/objects.txt',

        fixedHeader: true,

        columns: [

          { data: 'name', title: 'Name', name: 'Name', visible: true },

          { data: 'position', title: 'Pos', name: 'Pos', visible: false },

          { data: 'office', title: 'Off', name: 'Off', visible: true },

          { data: 'extn', title: 'Extn', name: 'Extn', visible: true },

          { data: 'start_date', title: 'Start Date', name: 'Started' },

          { data: 'salary', title: 'Salary', name: 'Sal' }

        ],

        dom: 'Bfrtip',

        buttons: [

            $.extend( true, {}, buttonCommon, {

                extend: 'copyHtml5'

            } ),

            $.extend( true, {}, buttonCommon, {

                extend: 'excelHtml5'

            } ),

            $.extend( true, {}, buttonCommon, {

                extend: 'pdfHtml5'

            } )

        ]

    } );

} );