public static ActionResult ExportActionResult(PivotGridExportOptionsModel optionsModel, BusinessIntelligenceModel model) { if (exportTypes == null) { exportTypes = CreateExportTypes(); } var format = optionsModel.ExportFormat; switch (format) { //case ExportFormats.Excel: // return exportTypes[format].ExcelMethod(model.PivotGridSettings, model.BindData, new XlsxExportOptionsEx() { ExportType = ExportType.WYSIWYG }); case ExportFormats.Excel: XlsxExportOptionsEx exportOptions = new XlsxExportOptionsEx() { ExportType = ExportType.DataAware }; exportOptions.AllowFixedColumnHeaderPanel = exportOptions.AllowFixedColumns = optionsModel.DataAwareOptions.AllowFixedColumnAndRowArea ? DefaultBoolean.True : DefaultBoolean.False; exportOptions.AllowGrouping = optionsModel.DataAwareOptions.AllowGrouping ? DefaultBoolean.True : DefaultBoolean.False; exportOptions.RawDataMode = optionsModel.DataAwareOptions.ExportRawData; exportOptions.TextExportMode = optionsModel.DataAwareOptions.ExportDisplayText ? TextExportMode.Text : TextExportMode.Value; return(exportTypes[format].ExcelMethod(model.PivotGridSettings, model.PivotGridData, exportOptions)); default: return(exportTypes[format].Method(model.PivotGridSettings, model.PivotGridData)); } }
public BusinessIntelligenceModel() { PivotGridExportOptions = new PivotGridExportOptionsModel(); PivotGridSettings = new PivotGridSettings(); }