Angular download csv file with Web Api 2

Question

I am trying to download a csv file using web api 2 and angular js.

This is my controller code

public IHttpActionResult ExportCsvData()
{
    var stream = new FileStream("Testcsv.csv", FileMode.Open, FileAccess.Read);
    var response = new HttpResponseMessage(HttpStatusCode.OK);
    response.Content = new StreamContent(stream);
    response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");
    response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
    {
        FileName = "Testcsv.csv"
    };

    return Ok(response);
 }

This is my angular code,

var filename = 'testcsv.csv';
var contentType = 'text/csv;charset=utf-8';
var blob = new Blob([data], { type: contentType });
if (navigator.msSaveBlob) {
    navigator.msSaveBlob(blob, filename);
}

I am using IE 11, but when I open the file in excel, it looks like this,

{   "version": {
    "major": 1
    "minor": 1
    "build": -1
    "revision": -1
    "majorRevision": -1
    "minorRevision": -1   }   "content": {
    "headers": [
      {
        "key": "Content-Type"
        "value": [
          "application/octet-stream"
        ]
      }
      {
        "key": "Content-Disposition"
        "value": [
          "attachment; filename=testcsv.csv"
        ]
      }
    ]

What am I doing wrong?

Thanks !

Nkosi · Accepted Answer · 2016-03-11 19:58:51Z

7

You need to return a response message. The Ok() will serialize the HttpResponseMessage as is.

public IHttpActionResult ExportCsvData()
{

        var stream = new FileStream("Testcsv.csv", FileMode.Open, FileAccess.Read);
        var response = new HttpResponseMessage(HttpStatusCode.OK);
        response.Content = new StreamContent(stream);
        response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");
        response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
        {
            FileName = "Testcsv.csv"
        };

        return ResponseMessage(response);
 }

answered Mar 11, 2016 at 19:58

Nkosi

249k38 gold badges472 silver badges506 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Steve Over a year ago

I see that you switched it from text/csv to application/octet-stream. Is that necessary? Or can you just use a new StringContent() instead of a new StreamContent()

Nkosi Over a year ago

They all eventually convert down to a stream. The StreamContent was used to match the file stream that was opened to get the file data.

Neel Over a year ago

ResponseMessage comes under which namespace? I can not find it

Nkosi Over a year ago

@Neel it is a method of the ApiController.ResponseMessage, which is assumed to be used in the OP given the version of Web API being used.

Collectives™ on Stack Overflow

Angular download csv file with Web Api 2

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related