/// <summary>
/// Method that generates an Excel (xml/xlsx) file with combined grid statistics.
/// </summary>
/// <param name="addSettings"></param>
/// <param name="addProvenance"></param>
/// <returns>An Excel file of the type xml or xlsx.</returns>
public FileResult CombinedGridStatisticsAsExcel(bool addSettings = true, bool addProvenance = true)
{
SetServerDone();
if (SessionHandler.MySettings.Presentation.FileFormat.ExcelFileSettings.IsSettingsDefault())
{
CombinedGridStatisticsExcelXlsx file = FileExportManager.GetCombinedGridStatisticsAsExcelXlsx(GetCurrentUser(), addSettings, addProvenance);
MemoryStream returnStream = file.ToStream();
return(File(returnStream, XlsxExcelFileMimeType, CreateXlsxExcelFileName("CombinedGridStatistics")));
}
else
{
CombinedGridStatisticsExcelXml file = FileExportManager.GetCombinedGridStatisticsAsExcelXml(GetCurrentUser(), addSettings, addProvenance);
MemoryStream returnStream = file.ToStream();
return(File(returnStream, XmlExcelFileMimeType, CreateXmlExcelFileName("CombinedGridStatistics")));
}
}
/// <summary>
/// Creates an xlsx excel file with combined grid statistics.
/// </summary>
/// <param name="currentUser">Current user context</param>
/// <param name="addSettings">True if settings sheet should be included</param>
/// <param name="addProvenance">True if provenance sheet should be included.</param>
/// <returns>The xlsx excel file.</returns>
public static CombinedGridStatisticsExcelXlsx GetCombinedGridStatisticsAsExcelXlsx(IUserContext currentUser, bool addSettings, bool addProvenance)
{
CombinedGridStatisticsExcelXlsx file = new CombinedGridStatisticsExcelXlsx(currentUser, addSettings, addProvenance);
return(file);
}