用Response直接导出Excel

this.Response.ContentType = "application/octet-stream";
            string encodingFilename = Server.UrlPathEncode("统计信息1");
            // 通过 Content-Disposition 确定下载的文件名
            this.Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xls", encodingFilename));
            Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            Response.ContentType = "application/ms-excel";
            Response.Flush();
            Response.Write("nihao\t你好吗\t");
            Response.End();

// 如果从Datatable导出Excel，可以把DataTable生成字符串，\t是下一个单元格\n是换行

转载于:https://www.cnblogs.com/jiayongmao/archive/2009/02/04/1383665.html