Asp.Net WebForm Rdlc 报表的使用之导出Excel

最新推荐文章于 2020-09-01 10:54:21 发布

原创最新推荐文章于 2020-09-01 10:54:21 发布 · 540 阅读

0 ·

CC 4.0 BY-SA版权

.Net 专栏收录该内容

111 篇文章

订阅专栏

本文介绍了一个使用代码实现的导出Excel报表的方法。通过绑定数据并利用_ReportViewer.LocalReport.Render方法，将报表转换为Excel格式，然后将转换后的字节流发送到客户端进行下载。这个过程包括设置MIME类型、文件名编码、二进制写入和刷新响应。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

实现代码

        /// <summary>
        /// 导出excel
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnExport_Click(object sender, EventArgs e)
        {
            //绑定数据
            SetReportViewer();
            // Variables
            Warning[] warnings;
            string[] streamIds;
            string mimeType = string.Empty;
            string encoding = string.Empty;
            string extension = string.Empty;
            byte[] bytes = _ReportViewer.LocalReport.Render("Excel", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
            // Now that you have all the bytes representing the PDF report, buffer it and send it to the client.
            Response.Buffer = true;
            Response.Clear();
            Response.ContentType = mimeType;
            String filename = HttpUtility.UrlEncode("报表导出", Encoding.UTF8);
            Response.AddHeader("content-disposition", "attachment; filename=" + filename + "." + extension);
            Response.BinaryWrite(bytes); // create the file
            Response.Flush(); // send it to the client to download
        }