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

Excel

configuration

Configures the Excel export settings of the Spreadsheet.

excel

Object

<div id="spreadsheet"></div>
<script>
  $("#spreadsheet").kendoSpreadsheet({
    excel: {
      fileName: "MySpreadsheet.xlsx",
      forceProxy: true
    }
  });
</script>

excel.fileName

String

Specifies the file name of the exported Excel file.

Default: "Spreadsheet.xlsx"

<div id="spreadsheet"></div>
<script>
    $("#spreadsheet").kendoSpreadsheet({
        sheets: [{
            name: "Food Order",
            mergedCells: [
                "A1:G1"
            ],
            rows: [{
                height: 70,
                cells: [{
                    value: "My Company", fontSize: 32, textAlign: "center"
                }]
            }],
        }],
        excel: {
            fileName: "Order.xlsx"
        }
    });

    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
    spreadsheet.saveAsExcel();
</script>

excel.forceProxy

Boolean

If set to true, the content will be forwarded to proxyURL even if the browser supports the saving of files locally.

Default: false

<div id="spreadsheet"></div>
<script>
  $("#spreadsheet").kendoSpreadsheet({
    excel: {
      forceProxy: true,
      proxyURL: "/save"
    }
  });
</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 lower 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.xlsx>".

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="spreadsheet"></div>
<script>
    $("#spreadsheet").kendoSpreadsheet({
        sheets: [{
            name: "Food Order",
            mergedCells: [
                "A1:G1"
            ],
            rows: [{
                height: 70,
                cells: [{
                    value: "My Company", fontSize: 32, textAlign: "center"
                }]
            }],
        }],
        excel: {
            proxyURL: "/save"
        }
    });

    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
    spreadsheet.saveAsExcel();
</script>

Excel

excel

excel.fileName

excel.forceProxy

excel.proxyURL