有多个表格的报表导出的Excel文件问题
本帖最后由 fumasoft 于 2018-12-26 17:28 编辑有多个表格的报表导出的Excel文件会生成多个sheet,请问能不能把多个表格的内容导出到一个sheet里
你好,你的意思是报表有多页,然后到处的 时候会有多个sheet文件设这样吗?如果是这样请参考如下设置:设置 MultiSheet的属性为false
请问用代码做导出功能要怎么设置? 用代码怎么设置这个属性? 代码控制如下:主要是这句代码: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());
可以了,谢谢 :)
页:
[1]