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

Columns.exportable

configuration

If the column isn't visible, the exportable property must be set to true explicitly.

If set to false the column will be excluded from the exported Excel/PDF files.

Can be set to a JavaScript object which specifies whether the column should be exported per format.

columns.exportable

Boolean|Object

Default: true

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  toolbar: ["excel", "pdf"],
  columns: [
    { field: "productName", title: "Product" },
    { field: "unitPrice", title: "Price" },
    { field: "internalCode", title: "Code", exportable: false }
  ],
  dataSource: [
    { productName: "Tea", unitPrice: 2.5, internalCode: "TEA001" },
    { productName: "Coffee", unitPrice: 3.0, internalCode: "COF001" }
  ]
});
</script>

columns.exportable.excel

Boolean

If set to false the column will be excluded from the exported Excel file.

Default: true

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  toolbar: ["excel"],
  dataSource: {
    type: "odata-v4",
    transport: {
      read: "https://demos.telerik.com/service/v2/odata/Products"
    },
    schema:{
      model: {
        fields: {
          UnitsInStock: { type: "number" },
          ProductName: { type: "string" },
          UnitPrice: { type: "number" },
          UnitsOnOrder: { type: "number" },
          UnitsInStock: { type: "number" }
        }
      }
    },
    pageSize: 20,
  },
  pageable: true,
  height: 550,
  columns: [
    { field: "ProductName", title: "Product Name" },
    { field: "UnitPrice", title: "Unit Price" },
    { field: "UnitsOnOrder", title: "Units On Order" },
    { field: "UnitsInStock", title: "Units In Stock", exportable: { excel: false} } //excluded from the export
  ]
});
</script>

columns.exportable.pdf

Boolean

If set to false the column will be excluded from the exported PDF file.

Default: true

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  toolbar: ["pdf"],
  columns: [
    { field: "productName", title: "Product" },
    { field: "unitPrice", title: "Price" },
    { field: "description", title: "Description", exportable: { pdf: false } }
  ],
  dataSource: [
    { productName: "Tea", unitPrice: 2.5, description: "Premium green tea" },
    { productName: "Coffee", unitPrice: 3.0, description: "Organic coffee beans" }
  ]
});
</script>