|
@Html.EJS().Grid("FirstGrid").DataSource((IEnumerable<object>)ViewBag.DataSource).AllowFiltering().AllowResizing(true).AllowExcelExport().ToolbarClick("toolbarClick").Toolbar(new List<string>() { "ExcelExport" }).Columns(col =>
{
...
}).AllowPaging().ExcelExportComplete("complete").Render()
@Html.EJS().Grid("SecondGrid").DataSource((IEnumerable<object>)ViewBag.DataSource1).AllowExcelExport().Columns(col =>
{
...
}).AllowPaging().Render()
<script>
function toolbarClick(args) {
var cols = [];
var firstGrid = document.getElementById("FirstGrid").ej2_instances[0];
var initCols = firstGrid.columns;
var initDataSource = firstGrid.dataSource;
var exportData = [];
var secondGrid = document.getElementById("SecondGrid").ej2_instances[0];
for (var i = 0; i < firstGrid.columns.length; i++) {
cols.push(firstGrid.columns[i]) //adding first grid columns
}
for (var i = 0; i < secondGrid.columns.length; i++) {
cols.push(secondGrid.columns[i]) //adding second grid columns
}
firstGrid.columns = [];
firstGrid.columns = cols; //assign new columns to first grid
if (args.item.id === 'FirstGrid_excelexport') {
var excelExportProperties = {
dataSource: ej.base.extend(exportData, firstGrid.dataSource, secondGrid.dataSource, true) //extending grid dataSource
};
firstGrid.excelExport(excelExportProperties);
}
}
function complete(args) {
var firstGrid = document.getElementById("FirstGrid").ej2_instances[0];
var secondGrid = document.getElementById("SecondGrid").ej2_instances[0];
for (var i = 0; i < firstGrid.columns.length; i++)
{
for (var j = 0; j < secondGrid.columns.length; j++)
{
if (firstGrid.columns[i] == secondGrid.columns[j])
{
firstGrid.columns.splice(i, 1); //removing added columns from first grid
}
}
}
firstGrid.refreshColumns();
}
</script> | 
