public void CreateExcel(DataTable dt,string FileName)
{
HttpResponse resp;
resp=((Page)HttpContext.Current.Handler).Response;
resp.ContentEncoding = System.Text.Encoding.Default;
resp.AppendHeader("Content-Disposition", "attachment;filename="+HttpUtility.UrlPathEncode(FileName));
string colHeaders="";
string ls_item="";
int i=0;
DataRow[] myRow=dt.Select("");
for(i=0;i<dt.Columns.Count-1;i++)
{
colHeaders+=dt.Columns[i].Caption.ToString()+"/t";
}
colHeaders+=dt.Columns[i].Caption.ToString() +"/n";
resp.Write(colHeaders);
foreach(DataRow row in myRow)
{
for(i=0;i<dt.Columns.Count-1;i++)
{
ls_item +=row[i].ToString() + "/t";
}
ls_item += row[i].ToString() +"/n";
resp.Write(ls_item);
ls_item="";
}
resp.End();
}