The exportGrid method offers four parameters, but the only one you must provide a value for is the fileName.

If you want to customize your export more than these four parameters allow, you can use the wijmo.exporter.exportGrid method.

fileName

Provide a string value to use for the name of the exported file. By default, the file is saved to the Downloads folder with the name of the file, and the file extension comes from the type parameter.

type

By default, exportGrid creates an XLS file, but you can specify any of the following three Excel types or one document type.

• xls (default) This creates a spreadsheet that can be opened by any version of Excel.
• xlsx This creates a spreadsheet that can be opened by Excel 2007 or later.
• csv This creates a file with comma separated values, which allows the user to open it in Excel or any text editor.
• pdf This creates a portable document that opens with the Adobe Reader, which is good for printing, but does not allow the user to manipulate the data.

serviceUrl

In the interest of getting you up and running quickly, we set this parameter by default to point to the demo export service we have set up here:

http://demos.componentone.com/ASPNET/ExportService/exportapi/grid

You can install your own export service in IIS v7.0 or higher. For more information, see Export Service Setup.

pdfSettings

This parameter only applies if you set the type parameter to pdf. See Grid PDF Exports for more information.

Example Code

In this example, we create a button click function for an <input> button element that calls our grid, and exports it to an XLS file named "MyGridExport."

<script id="scriptInit" type="text/javascript">
require(["wijmo.wijgrid", "gridexport"], function () {
    $(document).ready(function () {
        $("#wijgrid").wijgrid({
            cellClicked: function (e, args) {
                alert(args.cell.value());
            },
            allowSorting: true,
            data: [
                [27, 'Canada', 'Adams, Craig', 'RW'],
                [43, 'Canada', 'Boucher, Philippe', 'D', 'R'],
                [24, 'Canada', 'Cooke, Matt', 'LW', 'L'],
                [87, 'Canada', 'Crosby, Sidney (C)', 'C', 'L'],
                [1, 'United States', 'Curry, John', 'G', 'L'],
            ],
            columns: [
                {headerText: "Number"},
                {headerText: "Country"},
                {headerText: "Player"},
                {headerText: "Position"}
            ]
        });
    });
    $("#exportXLS").button().click(function () {
        wijmo.exporter.exportGrid({
            serviceUrl: "http://demos.componentone.com/ASPNET/ExportService/exportapi/grid",
            grid: $("#wijgrid").data("wijmo-wijgrid"),
            fileName: "MyGridExport"
        });
    });
});
</script>

Live Widget

Here is the example code above in action. Click the Export to Excel button to create a "MyGridExport.xls" file in your Downloads directory.