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();
}
