Export Excel from Database in Asp.Net MVC using partial view

hi,

i want to export(Create) and Downlod excel file from database in ASP.NET MVC ,anddownlod button is in partial view(is in popup) but it is not working and not show any error,,iam use ExcelPackage and create two datatable and combine customize cell ,, in worksheet

HttpContext.Response.Clear();

HttpContext.Response.AddHeader("", "");

HttpContext.Response.Charset = System.Text.UTF8Encoding.UTF8.WebName;

HttpContext.Response.ContentEncoding = System.Text.UTF8Encoding.UTF8;

HttpContext.Response.AddHeader("content-disposition", "attachment;

filename=filename.xlsx);

HttpContext.Response.ContentType = "application/excel";

HttpContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");

HttpContext.Response.BinaryWrite(excel.GetAsByteArray());

HttpContext.Response.End();

is not working

4 Replies

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

Nilesh Makwana8y ago
give me mail id i send you code ...
Jenith Thakkar8y ago
Okay Please provide full code so i can understand the issue
Nilesh Makwana8y ago
i dont want to open file, simple just fetch the data from database ,and data downlod that data in excel file format, and downlod button is in partial view(popup window)
Jenith Thakkar8y ago
You have to add that file in physical path then using jquery you can open that file