|
<input id="Export" value="Excel" class="e-exportbutton" />
<div class="content-container-fluid">
<div class="row">
<div class="cols-sample-area">
<br />
<div id="Grid"></div>
</div>
</div>
</div>
$(function () {
var gridData = @Html.Raw(Json.Encode(ViewBag.dataSource))
$(".e-exportbutton").ejButton({
click: "exportGrid"
});
$("#Grid").ejGrid({
dataSource: gridData,
allowPaging: true,
allowFiltering : true,
toolbarSettings: { showToolbar: true, toolbarItems: [ej.Grid.ToolBarItems.Add] },
columns: [
----------------
]
});
});
function exportGrid(args) {
var gridObj = $("#Grid").ejGrid("instance")
gridObj.model["currentData"] = JSON.stringify(gridObj.getFilteredRecords());
gridObj.export("/api/Orders/ExcelExport");
}
</script>
----------------------------------------------------
public IEnumerable currentData;
public void ExcelExport()
{
IEnumerable DataSource;
ExcelExport exp = new ExcelExport();
string gridModel = System.Web.HttpContext.Current.Request.Params["GridModel"];
GridProperties obj = ConvertGridObject(gridModel);
if (currentData.AsQueryable().Count() > 0)
DataSource = currentData;
else
DataSource = db.EmployeePhotoes.ToList();
exp.Export(obj, DataSource, "Export.xlsx", ExcelVersion.Excel2010, false, false, "flat-saffron");
}
private GridProperties ConvertGridObject(string gridProperty)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
IEnumerable div = (IEnumerable)serializer.Deserialize(gridProperty, typeof(IEnumerable));
GridProperties gridProp = new GridProperties();
foreach (KeyValuePair<string, object> ds in div)
{
if (ds.Key == "currentData")
{
----------------
currentData = JsonConvert.DeserializeObject<IEnumerable<EmployeePhoto>>(str);
continue;
}
var property = gridProp.GetType().GetProperty(ds.Key, BindingFlags.Instance | BindingFlags.Public | BindingFlags.IgnoreCase);
if (property != null)
{
Type type = property.PropertyType;
string serialize = serializer.Serialize(ds.Value);
object value = serializer.Deserialize(serialize, type);
property.SetValue(gridProp, value, null);
}
}
return gridProp;
} | 
