In Export to Excel of datatables sTitle is not coming in excel.And it is working in export to pdf
In Export to Excel of datatables sTitle is not coming in excel.And it is working in export to pdf
i am using below code for adding title for excel and pdf.
"sDom": 'RT<"clear"><"clear"><"top-left"p><"margin-top20" lf><"clear">C<"#div-save-order">rti',
"oTableTools": {
"sSwfPath": "/portal/jsp/tiles/csv_xls_pdf.swf",
"aButtons": [
{'sExtends':'csv',
"sFileName":"IRCS_Task_Details.csv",
"sTitle":"All the content is Boeing Proprietary",
'mColumns':'visible', //set which columns here
"sButtonText": "Export to CSV"
},
{
"sExtends": "pdf",
"sFileName":"IRCS_Task_Details.pdf",
"sPdfOrientation": "landscape",
"sTitle":"All the content is Boeing Proprietary",
"sPdfMessage": "",
'mColumns':'visible', //set which columns here
"sButtonText": "Export to PDF"
}
]
},
in pdf tilte for table is coming properly but in EXCEL nothing is coming.Could you suggest please.