6

I'm generating a CSV from an MVC 3 website and using a FileContentResult to pass this to the user. This worked great but it took 30 seconds for the csv to generate and therefore 30 seconds before the prompt to save was given to the user.

    public virtual FileContentResult GetSpreadsheet(string id)
    {
        var service = new SpreadsheetService();
        var result = service.GetCSV();
        return File(new System.Text.UTF8Encoding().GetBytes(result.Message), "text/csv", "Report123.csv");
    }

So I thought I'd just call it via JQuery - but this (unsurprisingly!) just dumps the CSV to the page. 

            $.post("/Home/GetSpreadsheet/" + id, null, function (data) {
                $('#resultDiv').html(data);
            });

Does anyone know how I'd generate the prompt to save now I've got the data back? Thanks

Andy Clarke
  • 3,114
  • 3
  • 36
  • 63

3 Answers3

12

You can't do that. Forget about that. It is impossible to download files using AJAX. In fact the AJAX call will work, you will hit the server, the server will send the file contents back to the client, the AJAX success callback will be triggered and passed as argument the contents of the file and that's where everything ends for you. Using javascript you cannot, for absolutely obvious reasons, save directly the file to the client computer and you cannot prompt for the Save As dialog.

So instead of using AJAX simply create an anchor:

@Html.ActionLink("download spreadsheet", "GetSpreadsheet", new { id = "123" })

Now if the server set the Content-Disposition header to attachment the browser will prompt the user to download and save the file at some chosen location on his computer.

Darin Dimitrov
  • 960,118
  • 257
  • 3,196
  • 2,876
  • You can also set the content-type header to the appropriate type if known, to prompt an open or save dialog (in most cases) For example: Content-type: application/vnd.ms-excel or text/csv – Hal Mar 22 '12 at 18:14
  • Love the answer. Made me think about that song "Screamager" by Therapy. – vapcguy Mar 12 '15 at 22:04
  • What are those "absolutely obvious" reasons? I managed to get the file bytes using ajax, I just need to render them – Nick Jun 19 '18 at 16:36
11

If you don't want to use an anchor, use a hidden iframe and set the src of the iframe to the url of the file to be downloaded.

<iframe id="hiddenFrame" src="" style="display:none; visibility:hidden;"></iframe>

Instead of the '$.post(...)' line use:

 downloadSpreadsheet('123');

 function downloadSpreadsheet(id) {
    var url = '@Url.Content("~/YourControllerName/GetSpreadsheet")' + "?id=" + id;
    $('#hiddenFrame').attr('src', url);
}

Or you can give a try on the jQuery Plugin for Requesting Ajax-like File Downloads

Using the plugin, you can download by invocking:

jQuery.download(url, data, method)
Kibria
  • 1,807
  • 1
  • 14
  • 17
5

You can use this in JavaScript:

function downloadSpreadsheet(id) {
    window.location.href = '@Url.Action("GetSpreadsheet", "Home")?id=' + id;
}
vapcguy
  • 5,607
  • 1
  • 45
  • 43