另存成EXCEL不对应

登录

1.另存后效果不太理想
2.问题如图
3.控件类型：Active Report 8
报表类型：页面报表
浏览器版本：google chrome

如图：

iceman · iceman

回复 1楼KinnSoft的帖子

kinnSoft 你好，

这两个问题我都已经重现了，已经反馈给产品组，有进一步结果第一时间通知你。

谢谢

iceman · iceman

回复 1楼KinnSoft的帖子

导出时候需要设置 UseCellMerging=true：

GrapeCity.ActiveReports.Export.Excel.Section.XlsExport export = new GrapeCity.ActiveReports.Export.Excel.Page.XlsExport();
export.UseCellMerging = true;
GrapeCity.ActiveReports.PageReport pr = new GrapeCity.ActiveReports.PageReport(new System.IO.FileInfo(this.Server.MapPath("PageReport1.rdlx")));
pr.Document.LocateDataSource += Document_LocateDataSource;
export.Export(pr.Document, this.Server.MapPath("test.xls"));

复制代码

iceman · iceman

回复 1楼KinnSoft的帖子

这个问题在 AR9 中已经解决：

GrapeCity.ActiveReports.PageReport report = new GrapeCity.ActiveReports.PageReport(new System.IO.FileInfo(this.Server.MapPath("PageReport1.rdlx")));
GrapeCity.ActiveReports.Document.PageDocument reportDocument = new GrapeCity.ActiveReports.Document.PageDocument(report);
// Create an output directory
System.IO.DirectoryInfo outputDirectory = new System.IO.DirectoryInfo(this.Server.MapPath("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;
//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));
reportDocument.Render(excelRenderingExtension, outputProvider, excelSetting.GetSettings());

复制代码

KinnSoft · KinnSoft

还没更新到AR9,无法测试！
还有就是更新包没发吧

iceman · iceman

回复 5楼KinnSoft的帖子

AR9 下载链接为：
http://www.gcpowertools.com.cn/d ... rts-v9.0.1678.0.zip

请下载试用。

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

5 个回复