Edit this page


Initiates the Excel export. Also fires the excelExport event.

Calling this method could trigger the browser built-in popup blocker in some cases. To avoid that, always call it as a response to an end-user action e.g. button click.

Example - manually initiate Excel export

<button id="export">Export to Excel</button>
<div id="pivotgrid"></div>
    height: 550,
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
        rows: [{ name: "[Product].[Product]" }],
        measures: ["[Measures].[Internet Sales Amount]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            read: {
                url: "https://demos.telerik.com/olap/msmdpump.dll",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
        schema: {
            type: "xmla"

$("#export").click(function(e) {
    var pivotgrid = $("#pivotgrid").data("kendoPivotGrid");
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article