区域报表与页面报表转化成Excel

您好，
excel导出主要使用XlsExport和Rendering两个方法。
XlsExport可以用于导出rpx和rdlx报表
Rendering只能用于导出rdlx报表。

虽然，XlsExport和Rendering都可以导出rdlx的报表，但是Rendering是最新实现的方法，对很多地方进行了增强。

XlsExport导出rpx格式的报表

1.         protected void Button5_Click(object sender, EventArgs e)
   
2.         {
   
3.             GrapeCity.ActiveReports.SectionReport sr = new GrapeCity.ActiveReports.SectionReport();
   
4.             System.Xml.XmlTextReader xtr = new System.Xml.XmlTextReader(Server.MapPath("") + "\\Reports\\RP_YN_YarnSalesSummary.rpx");
   
5.             sr.LoadLayout(xtr);
   
6.             xtr.Close();
   
7. 
   
8.             GrapeCity.ActiveReports.Export.Excel.Section.XlsExport XlsExport1 = new GrapeCity.ActiveReports.Export.Excel.Section.XlsExport();
   
9. 
   
10.             System.IO.MemoryStream ms = new System.IO.MemoryStream();
    
11.             XlsExport1.FileFormat = GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xlsx;
    
12.             XlsExport1.Export(sr.Document, ms);
    
13.             ms.Position = 0;
    
14. 
    
15.             Response.ContentType = "application/vnd.ms-excel";
    
16.             Response.AddHeader("content-disposition", Server.UrlPathEncode("attachment;filename=MyExport.xlsx"));
    
17.             Response.BinaryWrite(ms.ToArray());
    
18.             Response.End();
    
19.         }

复制代码

Rendering导出rdlx格式的报表

1.         protected void Button3_Click(object sender, EventArgs e)
   
2.         {
   
3.             // Provide the page report you want to render.
   
4.             GrapeCity.ActiveReports.PageReport _reportDef = new GrapeCity.ActiveReports.PageReport(new System.IO.FileInfo(Server.MapPath("/Reports/" + report + ".rdlx")));
   
5.             _reportDef.Report.DataSources[0].DataSourceReference = "";
   
6.             _reportDef.Report.DataSources[0].ConnectionProperties.DataProvider = "OLEDB";
   
7.             _reportDef.Report.DataSources[0].ConnectionProperties.ConnectString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};", Server.MapPath("/Data/NWind_CHS.mdb"));
   
8. 
   
9.             GrapeCity.ActiveReports.Document.PageDocument _reportRuntime = new GrapeCity.ActiveReports.Document.PageDocument(_reportDef);
   
10. 
    
11.             // Create an output directory
    
12.             System.IO.MemoryStream ms = new System.IO.MemoryStream();
    
13. 
    
14.             // Provide settings for your rendering output.
    
15.             GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtensionSettings
    
16.             excelSetting = new GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtensionSettings();
    
17.             excelSetting.FileFormat = GrapeCity.ActiveReports.Export.Excel.Page.FileFormat.Xls;
    
18.             //excelSetting.MultiSheet = false;
    
19.             GrapeCity.ActiveReports.Extensibility.Rendering.ISettings setting = excelSetting;
    
20. 
    
21.             //Set the rendering extension and render the report.
    
22.             GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtension
    
23.             excelRenderingExtension = new
    
24.             GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtension();
    
25.             GrapeCity.ActiveReports.Rendering.IO.MemoryStreamProvider outputProvider = new GrapeCity.ActiveReports.Rendering.IO.MemoryStreamProvider();
    
26.             _reportRuntime.Render(excelRenderingExtension, outputProvider, excelSetting.GetSettings());
    
27. 
    
28.             Response.ContentType = "application/vnd.ms-excel";
    
29.             Response.AddHeader("content-disposition", "inline;filename=MyExport.xls");
    
30.             outputProvider.GetPrimaryStream().OpenStream().CopyTo(ms);
    
31.             Response.BinaryWrite(ms.ToArray());
    
32.             Response.End();
    
33.         }

复制代码

希望能帮助到您。