Customize the Excel Export Filename of the Grid by Adding Current Date and Time
Environment
Product | Grid for Progress® Telerik® UI for ASP.NET Core |
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.
@(Html.Kendo().Grid<GridExportCustomName.Models.OrderViewModel>()
.Name("grid")
.Columns(columns =>
{
columns.Bound(e => e.OrderID);
columns.Bound(e => e.Freight);
})
.ToolBar(t =>
{
t.Excel();
})
.Events(ev=>ev.ExcelExport("onExcelExport"))
.DataSource(dataSource => dataSource
.Custom()
.Type("odata")
.Transport(transport =>
transport.Read(read => read.Url("https://demos.telerik.com/kendo-ui/service/Northwind.svc/Orders"))
)
.PageSize(10)
)
)
function onExcelExport(e) {
e.workbook.fileName = kendo.toString(new Date, "dd/MM/yyyy HH:mm") + " Grid.xlsx";
}