Export csv file in .net web app

Question

I have already saved csv file as /Exports/test.csv. I want to allow user to download file on button click . I have create a handler for that code is as :

<%@ WebHandler Language="C#" Class="Downloadfile" %>

using System;
using System.Web;
using System.Net;

public class Downloadfile : IHttpHandler
{
    public void ProcessRequest(HttpContext context)
    {
        HttpContext.Current.Response.ClearHeaders();
        HttpContext.Current.Response.Clear();

        context.Response.ContentType = "text/csv";
        context.Response.AddHeader("Content-Disposition", 
            "attachment; filename=" + context.Request.QueryString["file"]);

        context.Response.End();
    }

    public bool IsReusable
    {
        get
        {
            return true;
        }
    }
}

Above code download the file but its empty. I want just download csv file with its content.

So your response header says there is a file in the response, but you don't actually send the file. — Cloudy
– Cloudy, Commented Mar 11, 2013 at 17:38

Sławomir Rosiek · Accepted Answer · 2013-03-11 17:41:57Z

3

You need to transmit file. You can do that by using TransmitFile method or instead of write to disk you can just write directly to context.Response.OutputStream.

public void ProcessRequest(HttpContext context)
{
    context.Response.ClearHeaders();
    context.Response.Clear();
    context.Response.ContentType = "text/csv";
    context.Response.AddHeader("Content-Disposition", "attachment; filename=" +  context.Request.QueryString["file"]);
    context.Response.TransmitFile("/Exports/test.csv");
    context.Response.End();
}

answered Mar 11, 2013 at 17:41

Sławomir Rosiek

4,0733 gold badges28 silver badges44 bronze badges

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

1 Comment

Amit Kumar Over a year ago

it works what show the downloaded file content as: ‹ I-.QÈMÌÓQ±Âól š÷Æ and actual is "Test man, Test Woman"

Chris Doggett · Accepted Answer · 2013-03-11 17:44:07Z

3

I actually had to do the same thing the other day, depending on what the users pass in the "Accepts" header. I used the example from the MSDN article on Media Formatters, and it worked perfectly.

Mine was a bit different from yours since I'm using MVC's WebApi, but the underlying concepts are the same.

answered Mar 11, 2013 at 17:44

Chris Doggett

21k4 gold badges63 silver badges87 bronze badges

Collectives™ on Stack Overflow

Export csv file in .net web app

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related