I did not have those files included.  I also do not see them in the IgniteUI installation folder.

Where are those files located?

thanks,

wvusaf

so, i got the export working.  but now another issue.

i have paging set up and i am binding to a remote datatable by setting the datasourceUrl property to an Action in my controller.

that all works perfectly, i can sort, page, and move columns with the remote datatable by using the <GridDataSourceAction> attribute of my controller action.

the problem now is that when using the GridExcelExporter, i can only export rows from the current grid page.

i have set up the export  like this, but only the rows from the current page are exported:

$.ig.GridExcelExporter.exportGrid($("#report-grid"), {
fileName: "igGrid",
dataExportMode: "allRows",
gridFeatureOptions: {
paging: "allRows",
sorting: "applied"
}
});

The Header and Footer technically belong to PageSetup under WorksheetOptions, if you were to look at an Excel document saved as .xml.

What we used to do is generate xml in the format of an Excel document but i would like to use the GridExcelExporter, if possible.

I do see in the ig.excel.PrintOptions, that there is a header and footer there.  this is probably what i need, but when using ig.excel, i am disconnected from using GridExcelExporter, aren't I?

If i can somehow modify ig.excel.PrintOptions for use with the GridExcelExporter, then i think it would work.  Can this be done?

Technically, when GridExcelExporter exports a document, it does freeze the top row, which must control the FreezePanes section that is also located under WorksheetOptions in the actual document, so it must have access to that same area that contains the Header and Footer.

thanks,

wvusaf

Yes, i figured that using the remote datasource was causing the issue.

thank you for the solution.  however, i have another issue.

is it possible to set document properties using the GridExcelExporter?

specifically, i need to set the Header and Footer properties of the document itself, for times that we might print the document that we've downloaded.

i do see in the Excel object model that you can set the properties, but i hoped i could set them using the GridExcelExporter in some way.

thanks,

wvusaf

Hi,

This is the expected, since when using remote dataSource scenario the controllers sends to the client only the data for the current page. In order to export all pages in this situation you will need to workaround the situation by

1) fetching the entire data using an ajax call

2) pass this data to the exorter in the exportStarting event. Here is the code snippet:

*************

        function ExportGrid() {
            var url = '@Url.Action(actionName: "GetItems")'; // this is your data source controller action
            var gridAllData = [];
    
            // 1) start the ajax call
            $.ajax({
                url: url,

                method: "GET",

                dataType: "json",
                success: function (data) {
                   
                    $.ig.GridExcelExporter.exportGrid($("#report-grid"), {
                        fileName: "igGrid",
                        gridFeatureOptions: { "sorting": "applied" },
                    },
                    {
                        exportStarting: function (args) {
                             // 2) pass the fetched data
                             args._gridData = data.Records;
                        }
                    });

                },
                error: function (jqXhr, textStatus, errorThrown) {
                    console.log(errorThrown);
                }
            });
        }

************

Please let me know if you have further questions on the matter.