Export string to CSV not working

Question

I am trying to download a string into CSV file with the following code:

string attachment = "attachment; filename=Test.csv";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
HttpContext.Current.Response.ContentType = "text/csv";
HttpContext.Current.Response.AddHeader("Pragma", "public");
HttpContext.Current.Response.Write("my,csv,file,contents");
HttpContext.Current.Response.End();

My Fiddler capture gave me the following:

 HTTP/1.1 200 OK
 Server: ASP.NET Development Server/10.0.0.0
 Date: Wed, 18 Sep 2013 22:06:19 GMT
 X-AspNet-Version: 4.0.30319
 content-disposition: attachment; filename=Test.csv
 Pragma: public
 Cache-Control: private
 Content-Type: text/csv; charset=utf-8
 Content-Length: 20
 Connection: Close

 my,csv,file,contents

But, the browser is not downloading any CSV file. Please help. Thanks,

Community · Accepted Answer · 2017-05-23 12:11:08Z

0

The header should be written as Content-Disposition - note the capital letters in the name. For more information, search for 19.5.1 Content-Disposition in http://www.w3.org/Protocols/rfc2616/rfc2616-sec19.html

For example:

Content-Disposition: attachment; filename="fname.ext"

Also note the double quotes around the file name.

Responding with a csv file in asp.net

edited May 23, 2017 at 12:11

CommunityBot

11 silver badge

answered Sep 18, 2013 at 22:18

xxbbcc

17.5k5 gold badges54 silver badges91 bronze badges

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

1 Comment

SKB Over a year ago

The issue was not this. I have found the answer and have posted it. Thanks for your response.

Community · Accepted Answer · 2017-05-23 12:20:21Z

0

The issue was an exception: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed.

Found a useful article here

and found a solution here

Thanks,

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Sep 19, 2013 at 17:49

SKB

1794 silver badges12 bronze badges

Collectives™ on Stack Overflow

Export string to CSV not working

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related