export to xls with grouped header

[sunnykimParticipant]

hi.
i’m trying to grid to xls.
i have a grouped header, but grouped header excepted when export to xls.
how to export with grouped header in export to xls?

var dataAdapter = new $.jqx.dataAdapter(source);
$(“#jqxgrid”).jqxGrid(
{
theme: “arctic”,
columnsresize: true,
columnsautoresize: true,
width: (screen.width*0.85),
source: dataAdapter,
altrows: true,
pageable: true,
sortable: true,
selectionmode: ‘multiplecellsextended’,
columns: [
{ text: ‘Date’, align: ‘center’, cellsalign: ‘center’, datafield: ‘created’, width: 130 },
{ text: ‘Type’, name: ‘Data’, align: ‘center’, cellsalign: ‘center’, datafield: ‘type’},
{ text: ‘1’, name: ‘1’, align: ‘center’, cellsalign: ‘center’, columngroup: ‘b25’, datafield: ‘b25_1’},
{ text: ‘2’, name: ‘2’, align: ‘center’, cellsalign: ‘center’, columngroup: ‘b25’, datafield: ‘b25_2’},
{ text: ‘3’, name: ‘3’, align: ‘center’, cellsalign: ‘center’, columngroup: ‘b25’, datafield: ‘b25_3’},
{ text: ‘4’, name: ‘4’, align: ‘center’, cellsalign: ‘center’, columngroup: ‘b25’, datafield: ‘b25_4’},
{ text: ‘6’, name: ‘6’, align: ‘center’, cellsalign: ‘center’, columngroup: ‘b25’, datafield: ‘b25_6’},
{ text: ‘1’, name: ‘1’, align: ‘center’, cellsalign: ‘center’, columngroup: ‘b17’, datafield: ‘b17_1’},
{ text: ‘2’, name: ‘2’, align: ‘center’, cellsalign: ‘center’, columngroup: ‘b17’, datafield: ‘b17_2’},
{ text: ‘3’, name: ‘3’, align: ‘center’, cellsalign: ‘center’, columngroup: ‘b17’, datafield: ‘b17_3’},
{ text: ‘4’, name: ‘4’, align: ‘center’, cellsalign: ‘center’, columngroup: ‘b17’, datafield: ‘b17_4’},
{ text: ‘6’, name: ‘6’, align: ‘center’, cellsalign: ‘center’, columngroup: ‘b17’, datafield: ‘b17_6’},
{ text: ‘1’, name: ‘1’, align: ‘center’, cellsalign: ‘center’, columngroup: ‘b13’, datafield: ‘b13_1’},
{ text: ‘2’, name: ‘2’, align: ‘center’, cellsalign: ‘center’, columngroup: ‘b13’, datafield: ‘b13_2’},
{ text: ‘3’, name: ‘3’, align: ‘center’, cellsalign: ‘center’, columngroup: ‘b13’, datafield: ‘b13_3’},
{ text: ‘4’, name: ‘4’, align: ‘center’, cellsalign: ‘center’, columngroup: ‘b13’, datafield: ‘b13_4’},
{ text: ‘6’, name: ‘6’, align: ‘center’, cellsalign: ‘center’, columngroup: ‘b13’, datafield: ‘b13_6’}
],
columngroups: [
{ text: ‘karma_1’, align: ‘center’, name: ‘b25’ },
{ text: ‘primium_1’, align: ‘center’, name: ‘b17’ },
{ text: ‘tutorial_1’, align: ‘center’, name: ‘b13’ }
],
groupable: true
}
);

$(“#jqxgrid”).jqxGrid(‘exportdata’, ‘xls’, ‘dailyreport’);

[Peter StoevKeymaster]

Hi sunnykim,

The Grid’s Excel Export, exports always a Flat table.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts