public ActionResult GetExcel(CustomerContactsQueryViewModel cond = null)
{
using (var wb = GetExcelFile(cond))
{
// Add ClosedXML.Extensions in your using declarations
return(wb.Deliver($"ExportCustomerContacts_{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx"));
}
}
public ActionResult Index(CustomerContactsQueryViewModel data = null)
{
CustomerContactsQueryViewModel result = new CustomerContactsQueryViewModel();
result.Contacts = ContactsRepo.Search(data.Query, data.Paging, data.Sort);
result.Paging.Count = ContactsRepo.SearchCount(data.Query);
result.Paging.Take = data.Paging.Take;
result.Query = data.Query;
result.BatchEdit = data.BatchEdit;
return(View(result));
}
private XLWorkbook GetExcelFile(CustomerContactsQueryViewModel cond = null)
{
List <CustomerContactViewModel> list = ContactsRepo.SearchAll(cond.Query);;
return(ClosedXmlHelper.ToClosedXmlExcel(list));
}