Custom Excel and table formatting

tabish

I am beginner in using datatables API, I am using datatables extensively. I want to pre-add some content (headings) in exported excel file and format the columns (center align) in exported excel file. Is there any way of doing this (customizing excel file before generating) or I will have to modify the code.

Also serial number in table is not being rendered as number in exported excel rather it shows objects.

Can you please point me in the direction of the place where to begin for custom excel generation.

Thanks

allan

customizing excel file before generating

Yes - use the customize method of the excelHtml5 button type. You need to modify the XML that makes up the Excel file.

There are a few examples on this topic showing simple manipulations (the "Excel - %" examples in that list).

Allan