preserving the format

ppanta

Hi Allan,

I have done row grouping with the following snippet:


"fnDrawCallback": function ( oSettings ) {
if ( oSettings.aiDisplay.length == 0 )
{
return;
}

var nTrs = $('#my_summary_data_table tbody tr');
var iColspan = nTrs[0].getElementsByTagName('td').length;
var sLastGroup = "";
for ( var i=0 ; i

allan

There are no formatting options available when using TableTools export to XLS option - sorry. You would need to use a script on your server to create a full XLSX document if you want to do that.

Allan

ppanta

Thank you Allan for your quick response, and thanks a lot for caring the users by providing supporting answers.

ya I have been using TableTools export.
I am learning DataTables (A wonderful tool). So not much familiar with xlsx script.
Can you please provide an arbitrary example of script for the sever side "xlsx".

I would appreciate.

allan

Sorry - I don't have such a script to hand. But if you google for xlsx creation scripts I'm sure you'll find something.

Allan