Custom header while exporting to excel

karthiklal

I need to have a custom header for the export excel, how to do it ?

colin

See if this helps,

Colin

karthiklal

I have found the solution

buttons: [
            {extend: 'excelHtml5',
            title: 'Report',
            text:'<i class="fa fa-table fainfo" aria-hidden="true" ></i>',
            titleAttr: 'Export Excel',
            "oSelectorOpts": {filter: 'applied', order: 'current'},
            exportOptions: {
                    modifier: {
                    page: 'all'
                    },
                        format: {
                            header: function ( data, columnIdx ) {
                                if(columnIdx==1){
                                return 'column_1_header';
                                }
                                else{
                                return data;
                                }
                            }
                        }
                }
            ]