|
@Html.EJS().Grid("Grid").DataSource((IEnumerable<object>)ViewBag.DataSource).AllowExcelExport().Columns(col
=>
{
col.Field("OrderID").HeaderText("OrderID").IsPrimaryKey(true).Width("120").Add();
col.Field("CustomerID").HeaderText("CustomerID").Width("120").Add();
col.Field("Freight").HeaderText("Freight").Width("120").Format("C2").Add();
col.Field("ShipCity").HeaderText("ShipCity").Width("120").Add();
}).Created("created").ToolbarClick("toolbarClick").ExcelHeaderQueryCellInfo("excelHeaderQueryCellInfo").Toolbar(new List<string>() { "ExcelExport"
}).Render())
<script>
function
toolbarClick(args) {
var gridObj = document.getElementById("Grid").ej2_instances[0];
if (args.item.id === 'Grid_excelexport') {
gridObj.excelExport();
}
}
//
to customize the column header on excel exporting
function
excelHeaderQueryCellInfo(args)
{
args.cell.value = '';
}
// to remove the blank cell
function
created(args) {
var gridObj = document.getElementById("Grid").ej2_instances[0];
var processGridExportObject =
gridObj.excelExportModule.__proto__.processGridExport;
gridObj.excelExportModule.__proto__.processGridExport = function (
gobj,
props,
r
) {
var rows = processGridExportObject.call(this, gobj, props, r);
rows.shift();
rows.forEach((item, index) => {
item.index = index + 1;
});
return rows;
}
}
</script>
|
