jiayongmao

用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是换行

posted on 2009-02-04 10:48  贾永茂  阅读(940)  评论(0编辑  收藏  举报

导航