excelObject
Configures the Excel export settings of the Spreadsheet.
excel.fileNameString(default: "Spreadsheet.xlsx")
Specifies the file name of the exported Excel file.
Example - setting the default Excel file name
<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.forceProxyBoolean(default: false)
If set to true, the content will be forwarded to proxyURL even if the browser supports the saving of files locally.
excel.proxyURLString(default: null)
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.
Example - setting the server proxy URL
<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>In this article