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

Excel

configuration

Configures the Excel export settings of the PropertyGrid.

excel

Object

<div id="propertyGrid"></div>
<script>
$("#propertyGrid").kendoPropertyGrid({
    excel: {
        fileName: "PropertyGrid.xlsx",
        forceProxy: true
    },
    model: {
        foo: "bar",
        baz: 5
    }
});
</script>

excel.fileName

String

Specifies the file name of the exported Excel file.

Default: "Export.xslx"

<div id="propertyGrid"></div>
<script>
  $("#propertyGrid").kendoPropertyGrid({
    columns: {
        fieldColumn: { width: 200 },
        valueColumn: { width: 250 }
    },
    excel: {
      fileName: "Employees.xlsx"
    },
    model: {
        foo: "bar",
        baz: 5
    }
  });
</script>

excel.filterable

Boolean

Enables or disables column filtering in the Excel file.

Default: false

<div id="propertyGrid"></div>
<script>
  $("#propertyGrid").kendoPropertyGrid({
    columns: {
        fieldColumn: { width: 200 },
        valueColumn: { width: 250 }
    },
    excel: {
      filterable: true
    },
    model: {
        foo: "bar",
        baz: 5
    }
  });
</script>

excel.forceProxy

Boolean

If set to true, the content will be forwarded to proxyURL even if the browser supports local file saving.

Default: false

<div id="propertyGrid"></div>
<script>
$("#propertyGrid").kendoPropertyGrid({
    excel: {
        fileName: "PropertyGrid.xlsx",
        forceProxy: true,
        proxyURL: "/api/export"
    },
    model: {
        foo: "bar",
        baz: 5
    }
});
</script>

The URL of the server-side proxy which will stream the file to the end user. A proxy will be used when the browser is not capable of saving files locally. Such browsers are IE version 9 and earlier and Safari. The developer is responsible for implementing the server-side proxy. The proxy will return the decoded file with the Content-Disposition header set to attachment; filename="<fileName.xslx>".

The proxy will receive a POST request with the following parameters in the request body:

contentType—The MIME type of the file.
base64—The base-64 encoded file content.
fileName—The file name as requested by the caller.

Default: null

<div id="propertyGrid"></div>
<script>
  $("#propertyGrid").kendoPropertyGrid({
    columns: {
        fieldColumn: { width: 200 },
        valueColumn: { width: 250 }
    },
    model: {
        foo: "bar",
        baz: 5
    },
    excel: {
      proxyURL: "/save"
    }
  });
</script>

Excel

excel

excel.fileName

excel.filterable

excel.forceProxy

excel.proxyURL