首页 > Windows开发 > 详细

FastReport C# 导出

时间:2019-12-13 13:05:11      阅读:271      评论:0      收藏:0      [点我收藏+]
Report report = new Report();
var frxfile = HttpContext.Current.Server.MapPath(StaticPathEnum.UserResRoot + filePath);
report.Load(frxfile);
report.RegisterData(ds, "Data");
var p = report.Prepare(true);

if (p)
{
    var xlsFileName = taskNo + "-" + DateTime.Now.ToString("HH-mm-ss") + ".xlsx";
     SavePrintXlsBakFile(xlsFileName, report);
}

导出Excel

        private static void SavePrintXlsBakFile(string xlsFileName, Report report)
        {
            FastReport.Export.OoXML.Excel2007Export xlsExport = new FastReport.Export.OoXML.Excel2007Export();
            xlsExport.ShowProgress = false;

            MemoryStream strm = new MemoryStream();
            report.Export(xlsExport, strm);

            strm.Position = 0;

            var xlsFilePath = HttpContext.Current.Server.MapPath(StaticPathEnum.PrintXlsBakPath + "\\" + DateTime.Now.ToString("yyyy-MM-dd"));
            if (!Directory.Exists(xlsFilePath))
            {
                Directory.CreateDirectory(xlsFilePath);
            }
            FileStream fs = new FileStream(xlsFilePath + "\\" + xlsFileName, FileMode.Create);
            strm.WriteTo(fs);
            strm.Close();
            fs.Close();

            xlsExport.Dispose();
            strm.Dispose();
            fs.Dispose();
        }

 PDF

        private static void SavePrintPdfBakFile(string xlsFileName, Report report)
        {
            FastReport.Export.Pdf.PDFExport pdfExport = new FastReport.Export.Pdf.PDFExport();
            pdfExport.ShowProgress = false;
            pdfExport.Subject = "Subject";
            pdfExport.Title = System.IO.Path.GetFileNameWithoutExtension(xlsFileName);
            pdfExport.Compressed = true;
            pdfExport.AllowPrint = true;
            pdfExport.EmbeddingFonts = true;

            MemoryStream strm = new MemoryStream();
            report.Export(pdfExport, strm);

            strm.Position = 0;

            var xlsFilePath = HttpContext.Current.Server.MapPath(StaticPathEnum.PrintFileBakPath + "\\" + DateTime.Now.ToString("yyyy-MM-dd"));
            if (!Directory.Exists(xlsFilePath))
            {
                Directory.CreateDirectory(xlsFilePath);
            }
            FileStream fs = new FileStream(xlsFilePath + "\\" + xlsFileName, FileMode.Create);
            strm.WriteTo(fs);
            strm.Close();
            fs.Close();

            pdfExport.Dispose();
            strm.Dispose();
            fs.Dispose();
        }

 

FastReport C# 导出

原文:https://www.cnblogs.com/sky-gfan/p/12034144.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!