Export data to CSV file - Online Demo
Export.ashx
using System;
using System.Web;
using System.IO;
using System.Text;
using System.Globalization;
public class ExportCSV_demo : IHttpHandler
{
public void ProcessRequest (HttpContext context)
{
context.Response.Clear();
context.Response.ClearHeaders();
context.Response.CacheControl = "public";
context.Response.Cache.SetCacheability(HttpCacheability.Public);
context.Response.AddHeader("Content-Disposition", "attachment; filename=sample.csv");
context.Response.ContentType = "application/vnd.ms-excel";
Stream stream = context.Response.OutputStream;
Encoding encoding = context.Response.ContentEncoding;
CultureInfo cultureInfo = (CultureInfo)System.Globalization.CultureInfo.InvariantCulture.Clone();
using (StreamWriter writer = new StreamWriter(stream, encoding))
{
writer.WriteLine("\"Date\",\"Year\",\"Month\",\"Day\"");
DateTime Date = DateTime.Now;
for (Int32 i = 0; i <= 5; i++)
{
Date = Date.AddDays(1);
writer.WriteLine("\"{0}\",\"{1}\",\"{2}\",\"{3}\"", Date.ToString(cultureInfo),
Date.Year.ToString(), Date.Month.ToString(), Date.Day.ToString());
}
}
context.Response.End();
}
public bool IsReusable
{
get {
return false;
}
}
}