export gridview to excel

See more:

ASP.NET

MS-Excel

hi everyone,
I am trying to export my gridview which has datatable as datasource but excel sheet is not created properly, its shows "डाटा उपलब्ध हुन सकेन!!" in excel sheet. I have unicode values in gridview(hindi values), below is my code, plz suggest me where I did mistake. Same code work if my datasource is Sqldatasource object...plz help...

 public void ExporttoExcel(GridView gv)
        {
            HttpContext.Current.Response.Clear();
            HttpContext.Current.Response.Buffer = true;
            HttpContext.Current.Response.AddHeader("content-disposition",        string.Format("attachment; filename={0}", "Customers.xls"));
            HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
            StringWriter sw = new StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw);            
            gv.AllowPaging = false;
            gv.DataBind();           
            gv.HeaderRow.Style.Add("background-color", "#FFFFFF");        
            gv.RenderControl(htw);
            HttpContext.Current.Response.Write(sw.ToString());
            HttpContext.Current.Response.End();
           
        }
 protected void btnExcel_Click(object sender, ImageClickEventArgs e)
    {

        at.ExporttoExcel(gvDailyAttendenceReport);
    }
protected void btnShow_Click(object sender, EventArgs e)
    {
        showDailyAttendance();//function to bindgridview (datatable as datasource)
    }