Data export is not working in asp .net MVC

Ankit Kumar

9y4.3k.NET

Dear Friends

i am trying to export list data to excel but neither i am getting any error nor my my task is getting accomplished, no excel file is being downloaded.
someone please help.

code is given below

public ActionResult lnkExportData()

{

EmployeeHome EmpHome = new EmployeeHome();

List objEmployeeList = new List();

EmpHome.BindEmployee(1, "", "", "", "");

var list = EmpHome.ListLanguageEmployee;

var Records = list.Select(x => new { UserName = x.UserName, Name = x.ImageFilePath + ' ' + x.LastName + '-' + '(' + x.EmpCode + ')', Designation = x.Designation, CellularNumber = x.CellPhone, EmailID = x.EmailId, JoiningDate = String.Format("{0:dd-MMM-yyyy}", x.JoiningDate), Status = x.Status == 1 ? "Active" : "Inactive" }).ToList();

var gv = new GridView();

gv.DataSource = Records;

gv.DataBind();

Response.ClearContent();

Response.Buffer = true;

Response.AddHeader("content-disposition", "attachment; filename=DemoExcel.xls");

Response.ContentType = "application/ms-excel";

Response.Charset = "";

StringWriter objStringWriter = new StringWriter();

HtmlTextWriter objHtmlTextWriter = new HtmlTextWriter(objStringWriter);

gv.RenderControl(objHtmlTextWriter);

Response.Output.Write(objStringWriter.ToString());

Response.Flush();

Response.End();

return View();

}

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akshay Phadke9y ago
Try ur application in chrome it might work but IE it will not work
Also try this URL this is a perfect example what you are loking for
https://stackoverflow.com/questions/20371825/export-to-excel-not-working-in-asp-net-mvc-4
issacpal9y ago
Follow this:http://www.c-sharpcorner.com/UploadFile/83fe73/solutions-to-export-data-from-database-to-excel-in-C-Sharp/
Nilesh Shah9y ago
If you are debugging and the method lnkExportData() is not getting hit at debug break point, then see the code which calls this method.

may be the client side code in JS or jQuery which calls lnkExportData() is wrong, so its not being called at all.
Ankit Kumar9y ago
Hi Nileash,
i tried by debugging and method is getting hitten but still it's not downloading any excel file.
Nilesh Shah9y ago
@Ankit,

did you follow the simple debugging steps or not? Did you place the debug point on first line of this method "lnkExportData" and see if it gets hit.

what's being written to output in this line?
Response.Output.Write(objStringWriter.ToString());
Manas Mohapatra9y ago
Follow below link that may help you a lot:

https://stackoverflow.com/questions/16346227/export-data-to-excel-file-with-asp-net-mvc-4-c-sharp-is-rendering-into-view

https://www.codeproject.com/Articles/325103/MVC-Grid-to-Excel-file-download

http://techfunda.com/howto/308/export-data-into-ms-excel-from-mvc
Ankit Kumar9y ago
i am not getting any error and code executed in proper manner.but file is not getting created
Manas Mohapatra9y ago
Can you tell us what is not working. And what error you are getting when it executes.