水晶报表使用按钮导出EXCEL

最新推荐文章于 2025-04-30 14:40:52 发布

hongyanjava

最新推荐文章于 2025-04-30 14:40:52 发布

阅读量1k

点赞数

分类专栏：水晶报表文章标签：报表 excel exception string url button

本文链接：https://blog.youkuaiyun.com/hongyanjava/article/details/6893614

版权

水晶报表专栏收录该内容

1 篇文章

订阅专栏

这篇博客介绍了如何在C#中使用水晶报表组件导出报表为Excel文件。通过`ExportToExcel`方法，设置导出选项，然后利用HttpResponse对象响应导出的Excel文件，实现点击按钮直接下载。同时，博客提供了多个有用的资源链接，帮助读者深入理解和实践。

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

    public bool ExportToExcel(string ExcelFileName)
    {
        try
        {
            FileOPS.DiskFileName = ExcelFileName;

            ExportOptions ExOPS = myReport.ExportOptions;//cr.ExportOptions;
            ExOPS.ExportDestinationOptions = FileOPS;
            ExOPS.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
            ExOPS.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.ExcelRecord;
            myReport.Export();//myReport.Export(ExOPS);

            System.Web.HttpResponse Response = System.Web.HttpContext.Current.Response;
            Response.ClearContent();
            Response.ClearHeaders();

Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=" + ExcelFileName);//下载时要保存的默认文件名

            Response.WriteFile(ExcelFileName);
            Response.Flush();
            Response.Close();

            return true;
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
           // 创建Excel文件以及路径
            string map = Server.MapPath(@"../ExcelReport");
            string url = map + "/MonthReport{0:yyyyMMddHHmmss}.xls";
            string ExcelFileName = string.Format(url, DateTime.Now); //字符格式化

bool msg = ExportToExcel(ExcelFileName); //将水晶报表的信息保存到指定文件里

            if (msg == true)
            {
                string URL = "DownLoad.aspx?Path=" + url;
                Server.Transfer(URL);
            }

        }
        catch (Exception ex)
        {
           // ShowMessage(ex.Message);
        }
    }

有用的EXCEL链接
http://topic.youkuaiyun.com/u/20100428/16/72028ea4-fbab-49f3-b392-12d7524df9d5.html

http://topic.youkuaiyun.com/u/20090707/16/0618de94-4c4b-4186-8d48-f4a8f53117ae.html(完美Excel)

http://www.cnblogs.com/peaceli/archive/2008/04/13/1151520.html

http://topic.youkuaiyun.com/u/20081110/17/5d552cfd-9468-49bb-8767-c6ae80b117b3.html

水晶报表导出Excel:
http://qianshao.blog.51cto.com/935360/203640

水晶报表导出Excel/Word/Pdf:
http://cache.baidu.com/c?m=9d78d513d9d430df4f9ee3697d61c0151c4381132ba7d3020cde843890732c37506692ef7c7c47599184682041f14606acb6746536703daade8dcd5dddccc3747fd67a61310b8636438e46b2b51d5d867c925aecb24aa7ebaa69d7f9cfd3dd5656d751026780f1965f0710cf65fa033194fcdf174b&p=882a944292904ea802f6c3665648&user=baidu&fm=sc&query=%CB%AE%BE%A7%B1%A8%B1%ED+FileOPS&qid=95f784e812fd17f2&p1=1