Guriddo » Topic: jqgrid 5..8.10 not obeying includeFoorter: false directive when exporting excel

jqgrid 5..8.10 not obeying includeFoorter: false directive when exporting excel

Guriddo
excel export
jqgrid 5..8.10 not obeying includeFoorter: false directive when exporting excel

Tagged: excel export

This topic has 3 replies, 2 voices, and was last updated 6 days, 11 hours ago by guriddo.support.

Creator

Topic

October 14, 2025 at 11:30 pm #128354

mbetel

Participant

when exporting my grid which has a footer with the following , the footer is exported in excel…

onClickButton: function (e) {
    $("#:gridname").jqGrid('exportToExcel',{
       includeLabels: true,
       includeGroupHeader: false,
       includeFooter: false,
       loadIndicator: false,
       fileName: "muname.xlsx",
    });
},

onClickButton: function (e) {

$("#:gridname").jqGrid('exportToExcel',{

includeLabels: true,

includeGroupHeader: false,

includeFooter: false,

loadIndicator: false,

fileName: "muname.xlsx",

});

Creator

Topic

Viewing 3 replies - 1 through 3 (of 3 total)

Author

Replies

October 15, 2025 at 10:21 am #128356

guriddo.support

Participant

Hello,

I suppose you have enabled the footerrow to true in grid options.

The footer is exported in excel of one of the two is true – includeFooter in excel options or footerrow in grid options.

to disable footer in excel permanently disable the footerrow before export and enable it after that

onClickButton: function (e) {
    var grid = $("#gridname")[0];
    grid.p.footerrow = false;
    $("#:gridname").jqGrid('exportToExcel',{
        includeLabels: true,
        includeGroupHeader: false,
        includeFooter: false,
        loadIndicator: false,
        fileName: "muname.xlsx",
    });
    grid.p.footerrow = true;
},

onClickButton: function (e) {

var grid = $("#gridname")[0];

grid.p.footerrow = false;

$("#:gridname").jqGrid('exportToExcel',{

includeLabels: true,

includeGroupHeader: false,

includeFooter: false,

loadIndicator: false,

fileName: "muname.xlsx",

});

grid.p.footerrow = true;

Hope this helps

Kind Regards

Wiil

Guriddo Support Team

October 16, 2025 at 3:06 pm #128357

mbetel

Participant

Thank you,

That helps, but could it in future be included in the code that happens when exporting and includeFooter=false? That seems more logical to me.

Michiel

October 22, 2025 at 10:24 am #128358

guriddo.support

Participant

Hello,

We have fixed this discrepancy in GitHub. Actually all other exports (csv, pdf…) work as per your requirement.

jqgrid 5..8.10 not obeying includeFoorter: false directive when exporting excel

Search Forum

Recent Replies

Forum Statistics

UserOnline