°ÑaccessÊý¾Ý¿âµ¼Èëexcel±í¸ñ

    public void ExportExcel(DataTable dtData, string filename)
    {
        System.Web.UI.WebControls.DataGrid dgExport = null;
        // µ±Ç°¶Ô»°
        System.Web.HttpContext curContext = System.Web.HttpContext.Current;
        // IOÓÃÓÚµ¼³ö²¢·µ»ØexcelÎļþ
        System.IO.StringWriter strWriter = null;
        System.Web.UI.HtmlTextWriter htmlWriter = null;
        if (dtData != null)
        {
            // ÉèÖñàÂëºÍ¸½¼þ¸ñʽ
            curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(filename) + ".xls");//¼ÓHttpUtility.UrlEncode()·½·¨´¦ÀíÎļþÃûÂÒÂë
            curContext.Response.Charset = "gb2312";
            curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
            //HttpContext.Current.Response.ContentType=".xls/.txt/.doc";image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword
            curContext.Response.ContentType = ".xls";
            // µ¼³öexcelÎļþ
            strWriter = new System.IO.StringWriter();
            htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
            // ΪÁ˽â¾