The grid ignore case sensitive by default. But when i try to export excel by server side, the datas are filtered but without ignoring the case.
Any thing to do ?
@(Html.Kendo().Grid(Model)
.Name("grid")
.ToolBar(toolbar =>
{
toolbar.Template(@<text>
<a class='k-button k-grid-export' title='Export to XLS'>Export vers Excel</a>
</text>);
})
.Columns(columns =>
{
columns.Bound(prat => prat.FirstName);
columns.Bound(prat => prat.LastName);
}
.ColumnMenu()
.Groupable()
.Excel(excel => excel.FileName("Stat.xlsx").Filterable(true).AllPages(true))
.DataSource(dataSource => dataSource
.Ajax()
.Model(model => model.Id(p => p.GUIDReference))
.Read(read => read.Action("DataRead", "BackOffice"))
.ServerOperation(false)
)
$(".k-grid-export").on("click", function (e) {
exportToExcel('XLSX');
});
function exportToExcel(format) {
var grid = $("#grid").data("kendoGrid");
var filteredDataSource = new kendo.data.DataSource({
data: grid.dataSource.data(),
filter: grid.dataSource.filter(),
});
filteredDataSource.read();
var filteredData = filteredDataSource.view();
var exportOption = {
format: format,
title: "Export",
createUrl: "/BackOffice/Export",
downloadUrl: "/BackOffice/Download"
}
data = {
model: JSON.stringify(grid.columns),
data: JSON.stringify(filteredData.toJSON()),
format: exportOption.format,
title: exportOption.title
};
$.post(exportOption.createUrl, data, function () {
window.location.replace(kendo.format("{0}?format={1}&title={2}",
exportOption.downloadUrl,
exportOption.format,
exportOption.title));
});
}