CODEWITHSUNDEEP
asp.net-mvcexceldownload
Jeremy
Jeremy

Reputation: 752

ASP.NET MVC download prompt not appearing

I'm trying to generate a Excel .xlsx file in a controller action. I would like to have the website show a download prompt to download the resulting file. The controller actions executes fine, but no download prompt is shown. Nothing happens.

I've tried:

         MemoryStream mstream = ... //generated file;

         return File(mstream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", model.DisplayName + ".xlsx");

I've tried:

        return new FileStreamResult(mstream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") { FileDownloadName = model.DisplayName + ".xlsx" };

I've tried:

        Response.Clear();
        Response.AddHeader("Content-Disposition", "attachment; filename=" + model.DisplayName + ".xlsx");
        Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";

        Response.Write(mstream.ToArray());
        Response.End();

        return Content("");

I even tried saving the file to disk, then returning via the filepath

        return File(filepath, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")

What am I doing wrong? Thanks!

Upvotes: 1

Views: 2365

Answers (2)

Amila
Amila

Reputation: 3816

Add the header as follows.

var cd = new System.Net.Mime.ContentDisposition
            {
                FileName =  model.DisplayName + ".xlsx",
                Inline = false
            };
Response.AppendHeader("Content-Disposition", cd.ToString());

then return the file as follows

return File(mstream, ".xlsx");

Regarding download prompt. If you mean a prompt where it asks where to save the file, then it depends on how the user has set it up in their browser settings. For example in chrome, users can choose not to get a prompt when downloading files and have it downloaded to a pre specified location like the download folder. http://malektips.com/google-chrome-prompt-download-file.html#.VM-DbFWsUm8

Upvotes: 0

user1573618
user1573618

Reputation: 1816

I am using the following code in an MVC project.

public ActionResult GetCSV()
{
    string filename = "example";
    string csv = MyHelper.GetCSVString();
    return File(Encoding.UTF8.GetBytes(csv.ToString()), "text/csv", string.Format("{0}.csv", filename));
}

My csv string could look something like this

"Col1,Col2,Col3\nRow1Val1,Row1Val2,Row1Val3\n"

To trigger this download in a new window I call the following JavaScript

window.open('/MyUrl/GetCSV', 'DownloadWindowName');

Upvotes: 1

Related Questions