我们的导出有两种格式,一种是EXportFilters 另一种是RenderingExtensions
如果您用的是第一种方式我建议您用第二种方法试试
这是基于后台触发的写法:
- private void tsbExcel_Click(object sender, EventArgs e)
- {
- // 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;
- excelSetting.MultiSheet = false;
- 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 outputProvider = new GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider(outputDirectory, System.IO.Path.GetFileNameWithoutExtension(outputDirectory.Name));
- outputProvider.OverwriteOutputFile = false;
- _document.Render(excelRenderingExtension, outputProvider, excelSetting.GetSettings());
- }
复制代码 还有就是纯HTML5Viewer的写法:
- function OnExportExcel() {
- var viewModel = GetViewModel('WebViewer1');
- if (!viewModel.PageLoaded())
- return;
- viewModel.Export(ExportType.Xls, function (url) {
- try {
- window.open(url, '_blank');
- } catch (e) {
- }
- }, true, { FileName: 'ActiveReports报表.xlsx' });
- };
复制代码
|