有多个表格的报表导出的Excel文件问题

登录

本帖最后由 fumasoft 于 2018-12-26 17:28 编辑

有多个表格的报表导出的Excel文件会生成多个sheet，请问能不能把多个表格的内容导出到一个sheet里

KearneyKang · KearneyKang

你好，你的意思是报表有多页，然后到处的时候会有多个sheet文件设这样吗？如果是这样请参考如下设置：设置 MultiSheet的属性为false

fumasoft · fumasoft

请问用代码做导出功能要怎么设置？

fumasoft · fumasoft

用代码怎么设置这个属性？

KearneyKang · KearneyKang

代码控制如下：主要是这句代码：excelSetting.MultiSheet = false;

GrapeCity.ActiveReports.PageReport rpt1 = new GrapeCity.ActiveReports.PageReport(new FileInfo(@"RdlReport1.rdlx"));
//rpt1.Document.LocateDataSource += new LocateDataSourceEventHandler(LocateData);
// Create an output directory.
System.IO.DirectoryInfo outputDirectory = new System.IO.DirectoryInfo(@"D:\MyExcel");
outputDirectory.Create();
// Provide settings for your rendering output.
GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtensionSettings excelSetting = new GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtensionSettings();
excelSetting.FileFormat = GrapeCity.ActiveReports.Export.Excel.Page.FileFormat.Xls;
GrapeCity.ActiveReports.Extensibility.Rendering.ISettings setting = excelSetting;
excelSetting.MultiSheet = false;
// Set the rendering extension and render the report.
GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtension excelRenderingExtension = new GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtension();
GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider outputProvider = new GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider(outputDirectory, System.IO.Path.GetFileNameWithoutExtension(outputDirectory.Name));
// Overwrite output file if it already exists.
outputProvider.OverwriteOutputFile = true;
rpt1.Document.Render(excelRenderingExtension, outputProvider, excelSetting.GetSettings());

复制代码

fumasoft · fumasoft

可以了，谢谢

KearneyKang · KearneyKang

		自动登录	找回密码
密码			立即注册

[已处理] 有多个表格的报表导出的Excel文件问题