How to give title as bold in excel export, Need to give border for entire data exported in excel

sravanitedla

Hi Team,

I'm new to datatables, It has various features. I have few questions how to achieve the below scenarios, could you guys guide me on this.

1. Firstly i want to give the title as bold in the Excel export.

title: '<b>Enquiry Breakup</b>'

if i give as above it is priting with html tags in the excel export

1. Need to give border for entire table exported as excel.

I have gone through below post
https://datatables.net/extensions/buttons/examples/html5/excelBorder.html
But it gives border to only one particular row . But i want the border for the entire data exported to excel.

3.The $ symbol for is displaying after the amount. I need the $ symbol to be exported as prefix of the amount.

1. I need all the columns data to be align left.

Can anyone of you guide me on above items.

Waiting for the response

Thanks,
Sravani.