如电话沟通:
1.您先尝试将报表,使用报表设计器的导出功能来导成Excel文件,看是否正常。
2. 使用导出excel代码:- private ActionResult OutputReport(PageDocument _reportRuntime, string type)
- {
- var ms = new MemoryStream();
- FileContentResult result = null;
- if (type == "excel")
- {
- System.IO.DirectoryInfo outputDirectory = new System.IO.DirectoryInfo(@"D:\Demo");
- outputDirectory.Create();
- GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtensionSettings excelSetting = new GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtensionSettings();
- excelSetting.FileFormat = GrapeCity.ActiveReports.Export.Excel.Page.FileFormat.Xls;
- excelSetting.OpenXmlStandard = GrapeCity.ActiveReports.Export.Excel.Page.OpenXmlStandard.Transitional;
- excelSetting.Pagination = true;
- excelSetting.MultiSheet = true;
- GrapeCity.ActiveReports.Extensibility.Rendering.ISettings setting = excelSetting;
- GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtension excelRenderingExtension = new GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtension();
- GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider outprovider = new GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider(outputDirectory, System.IO.Path.GetFileName("outputDirectory.Name"));
- _reportRuntime.Render(excelRenderingExtension, outprovider, excelSetting.GetSettings());
-
- }
复制代码
|