Customize the Excel Export Filename of the Grid by Adding Current Date and Time
Environment
Product | Progress® Kendo UI® Grid for jQuery |
Description
How can I add the current date and time to the Excel export filename of the Grid?
Solution
Use the
excelExport
event which has the workbook in its event data to rename it.-
With the help of the
kendo.toString()
method or another way to format the date, concatenate the date to the filename:excelExport: function(e) { e.workbook.fileName = kendo.toString(new Date, "d") + " Grid.xlsx"; }
<div id="grid"></div>
<script>
$("#grid").kendoGrid({
toolbar: ["excel"],
columns: [
{ field: "name" }
],
dataSource: [
{ name: "Jane Doe"},
{ name: "John Doe"}
],
excelExport: function(e) {
e.workbook.fileName = kendo.toString(new Date, "dd/MM/yyyy HH:mm") + " Grid.xlsx";
}
});
var grid = $("#grid").data("kendoGrid");
grid.saveAsExcel();
</script>