1

Here's the code snippet from my Controller... it all starts at my Index.

 public ActionResult Index(...){
       //some code here
       return GenerateReport(...);
    }

So far...exporter.GenerateReport() returns the correct path of the generated excel file...

public ActionResult GenerateReport(...){
      string pathOfGeneratedFile = exporter.GenerateReport(...);
      return DownloadFile(pathOfGeneratedFile, "application/vnd.ms-excel");
}


public FileResult DownloadFile(string filePath, string contentType = "application/octet-stream"){
         return File(filePath, contentType, Path.GetFileName(filePath)); 
}

There are actually no errors/exceptions happened along the way.... but I was expecting that I can download the file once it was generated... I manually open the file generated using OpenXMl and it did open and all the information was stored there...

Here is my View... I did some parsing with the value of my button to reflect the GenerateReport user action.... This will submit to the Index action where it determines the user action if it click the generate button...

<input class="btn btn-primary pull-right" type="submit" value="Generate Report" name="userAction"/>

EDIT: I used this also in my view...

@using (Ajax.BeginForm(new AjaxOptions { HttpMethod = "Get", UpdateTargetId = "recordList", InsertionMode = InsertionMode.Replace }))

BTW, once all the operation is finished...I can see a garbage value in my View. I just want the file to be downloaded. Thank you.

JYR
  • 109
  • 4
  • 15

1 Answers1

2

The reason why you are unable to download the file is that you are using AJAX async request. An AJAX response cannot contain a file download. You can try something like this in your controller:

public ActionResult Index(...) {
    var fileName = GenerateReport();

    // store the file name somewhere on the server - do NOT pass it through the URL.
    this.TempData["DownloadFileName"] = fileName;
    this.TempData["DownloadContentType"] = "application/vnd.ms-excel";
    this.TempData.Keep("DownloadFileName");
    this.TempData.Keep("DownloadContentType");

    return new JavaScriptResult() { Script = "document.location = \"" + this.Url.Action("Download") + "\";" };
}

public ActionResult Download() {
    return File((string)this.TempData["DownloadFileName"], (string)this.TempData["DownloadContentType"], Path.GetFileName(filePath)); 
}

So your AJAX request will result in a redirect (cannot use RedirectToAction since that will cause to browser to redirect inside the AJAX request). This redirect will then instruct the browser to download the file in a classic request.

Knaģis
  • 20,827
  • 7
  • 66
  • 80
  • im a little bit confused... who calls the Download() ? is it still GenerateReport() ? – JYR Nov 15 '12 at 09:28
  • also JavaScriptResult does not contain a constructor with 1 argument as what IDE is saying... – JYR Nov 15 '12 at 09:35
  • changed the answer to fix the error and describe what happens – Knaģis Nov 15 '12 at 09:56
  • thx Knagis but there's still error for return File(this.TempData["DownloadFileName"]); File constructor doesn't have a 1 argument constructor... and when I added a content type(string)...this.TempData["DownloadFileName"] something wrong on these in the FIle constructor... – JYR Nov 15 '12 at 10:20
  • you already had a working sample on how to execute File() result in your question. but I did add that missing code the my answer as well – Knaģis Nov 15 '12 at 10:27
  • i dont know why but i have convert this.TempData["DownloadFileName"] to String value... even if its value is already in string... anyways i've ran it successfully....thx Knagis for your time, effort and support :) – JYR Nov 15 '12 at 10:40