New to Kendo UI for jQuery? Download free 30-day trial

Export Multiple Grids


Product Progress Kendo UI Grid
Operating System All
Browser All
Browser Version All


How can I export two Kendo UI Grids for jQuery in the same Excel document?


The following example demonstrates how to export two Grids in the same Excel document.

Each Grid is exported in a separate Excel sheet. For additional information about how Excel documents work, refer to the introductory help topic on Excel.

<button id="export" class="k-button"><span class="k-icon k-i-excel"></span>Export to Excel</button>
<div id="products"></div>
<div id="orders"></div>
  // used to sync the exports
  var promises = [

    // trigger export of the products grid
    // trigger export of the orders grid
    // wait for both exports to finish
    $.when.apply(null, promises)
     .then(function(productsWorkbook, ordersWorkbook) {

      // create a new workbook using the sheets of the products and orders workbooks
      var sheets = [

      sheets[0].title = "Products";
      sheets[1].title = "Orders";

      var workbook = new kendo.ooxml.Workbook({
        sheets: sheets

      // save the new workbook,b
        dataURI: workbook.toDataURL(),
        fileName: "ProductsAndOrders.xlsx"

    dataSource: {
      transport: {
        read: {
          url: "",
          dataType: "jsonp"
      pageSize: 20
    height: 550,
    pageable: true,
    excelExport: function(e) {


    dataSource: {
      type: "odata",
      transport: {
        read: ""
      pageSize: 20,
      serverPaging: true
    height: 550,
    pageable: true,
    columns: [
      { field:"OrderID" },
      { field: "ShipName", title: "Ship Name" },
      { field: "ShipCity", title: "Ship City" }
    excelExport: function(e) {


See Also

In this article
Not finding the help you need? Improve this article