dev....把pivotgridview和chart一起导出

首先~：

命名空间：

using DevExpress.XtraPrinting;
using DevExpress.XtraCharts.Native;
using DevExpress.XtraPrintingLinks;
using System.IO;

导出PDF：

　　写在，比如说是btn事件里的

 PrintingSystem ps = new PrintingSystem();

            PrintableComponentLink link1 = new PrintableComponentLink();

            link1.Component = Exporter;

            link1.PrintingSystem = ps;

            PrintableComponentLink link2 = new PrintableComponentLink();

            WebChart.DataBind();

            link2.Component = ((IChartContainer)WebChart).Chart;

            link2.PrintingSystem = ps;

            CompositeLink compositeLink = new CompositeLink();

            compositeLink.Links.AddRange(new object[] { link1, link2 });

            compositeLink.PrintingSystem = ps;

            compositeLink.CreateDocument();

            compositeLink.PrintingSystem.ExportOptions.Pdf.DocumentOptions.Author = "Test";

            using (MemoryStream stream = new MemoryStream())

            {

                compositeLink.PrintingSystem.ExportToPdf(stream);

                Response.Clear();

                Response.Buffer = false;

                Response.AppendHeader("Content-Type", "application/pdf");

                Response.AppendHeader("Content-Transfer-Encoding", "binary");

                Response.AppendHeader("Content-Disposition", "attachment; filename=test.pdf");

                Response.BinaryWrite(stream.GetBuffer());

                Response.End();

            }

            ps.Dispose();

导出XLS（excel）

PrintingSystem ps = new PrintingSystem();

            PrintableComponentLink link1 = new PrintableComponentLink();

            link1.Component = Exporter;

            link1.PrintingSystem = ps;

            PrintableComponentLink link2 = new PrintableComponentLink();

            WebChart.DataBind();

            link2.Component = ((IChartContainer)WebChart).Chart;

            link2.PrintingSystem = ps;

            CompositeLink compositeLink = new CompositeLink();

            compositeLink.Links.AddRange(new object[] { link1, link2 });

            compositeLink.PrintingSystem = ps;

            compositeLink.CreateDocument();

            //compositeLink.PrintingSystem.ExportOptions.Xls.DocumentOptions.Author = "Test";

            using (MemoryStream stream = new MemoryStream())

            {

                compositeLink.PrintingSystem.ExportToXls(stream);

                Response.Clear();

                Response.Buffer = false;

                Response.AppendHeader("Content-Type", "application/xls");

                Response.AppendHeader("Content-Transfer-Encoding", "binary");

                Response.AppendHeader("Content-Disposition", "attachment; filename=test.xls");

                Response.BinaryWrite(stream.GetBuffer());

                Response.End();

            }

            ps.Dispose();

这样就可以把表格还有图表一起导出来了~

巴特西

dev....把pivotgridview和chart一起导出

最新文章

热门文章