C# WinForm报表导出Word功能

官方文档是无参的示例,注释为英文,这里注释为中文,并且导出的报表是有参数的格式
官方文档:https://help.grapecity.com.cn/pages/viewpage.action?pageId=47647535

示例基于SQLite数据库

1. //定义报表的路径和名称
   
2. string file_name = @"询问笔录.rdlx"; //报表格式为:页面报表(pageReport)
   
3. 
   
4. // 提供页面报表到你想要的状态 Provide the page report you want to render.
   
5. GrapeCity.ActiveReports.PageReport pageReport = new GrapeCity.ActiveReports.PageReport(new System.IO.FileInfo(file_name));   //简写方式 var pageReport = new PageReport(new System.IO.FileInfo(file_name));   
   
6. GrapeCity.ActiveReports.Document.PageDocument reportDocument = new GrapeCity.ActiveReports.Document.PageDocument(pageReport);
   
7. 
   
8. // 定义页面报表(Rdlx)的数据库连接参数
   
9. pageReport.Report.DataSources[0].DataSourceReference = "";
   
10. pageReport.Report.DataSources[0].ConnectionProperties.DataProvider = "ODBC";
    
11. pageReport.Report.DataSources[0].ConnectionProperties.ConnectString = @"DRIVER=SQLITE3 ODBC DRIVER;DATABASE=data\YiFa.db";
    
12. pageReport.Report.ReportParameters[0].DefaultValue.Values.Clear();
    
13. pageReport.Report.ReportParameters[0].DefaultValue.Values.Add(this.uiTextBox询问号.Text.Trim());
    
14. pageReport.Report.ReportParameters[1].DefaultValue.Values.Clear();
    
15. pageReport.Report.ReportParameters[1].DefaultValue.Values.Add(this.uiTextBox年度.Text.Trim());
    
16. 
    
17. // 创建输入目录 Create an output directory.
    
18. System.IO.DirectoryInfo outputDirectory = new System.IO.DirectoryInfo(@"D:\易罚Word导出");
    
19. outputDirectory.Create();
    
20. 
    
21. // 为您的渲染输出提供设置 Provide settings for your rendering output.
    
22. GrapeCity.ActiveReports.Export.Word.Page.Settings wordSetting = new GrapeCity.ActiveReports.Export.Word.Page.Settings();
    
23. 
    
24. // 将FileFormat属性设置为.OOXML Set the FileFormat property to .OOXML.
    
25. wordSetting.FileFormat = GrapeCity.ActiveReports.Export.Word.Page.FileFormat.OOXML;
    
26. 
    
27. // 设置呈现扩展名并呈现报告 Set the rendering extension and render the report.
    
28. GrapeCity.ActiveReports.Export.Word.Page.WordRenderingExtension wordRenderingExtension = new GrapeCity.ActiveReports.Export.Word.Page.WordRenderingExtension();
    
29. GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider outputProvider = new GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider(outputDirectory, System.IO.Path.GetFileNameWithoutExtension(outputDirectory.Name));
    
30. 
    
31. // 如果输出文件已经存在，则覆盖它 Overwrite output file if it already exists.
    
32. outputProvider.OverwriteOutputFile = true;
    
33. 
    
34. //提交状态
    
35. reportDocument.Render(wordRenderingExtension, outputProvider, wordSetting);
    
36. 
    
37. MessageBox.Show("导出Word成功！");

复制代码

给大佬点个赞，非常感谢大佬的分享，奖励您1000金币。