Export to Excel with row group

MarianoDonato

Hello everyone!!
My name is Mariano and it is a pleasure to be among you. This is my first time on the forum to see if I can get help. What I want to ask is how I can export the following datatabel table to Excel where there are groupings of rows. That is, I want to export to Excel exactly the same as I see in the table:

For grouping I am using the following code:
// grouping columns
rowGroup: {
dataSrc: [5, 8, 11],
// count the number of rows in each group
startRender: function(rows, group) {
return group + "(" + rows.count() + ")";
},
},
If someone can help me export in Excel as seen in the table, I would appreciate it forever!!!

kthorngren

Exporting the RowGroup is not built into Datatables at this time. It will take a custom solution. I created an example of one way to do this in this thread.

Kevin

MarianoDonato

Thanks!