/// <summary> /// Method that generates an Excel (xml) file with grid based counts of number of species observations. /// </summary> /// <param name="addSettings"></param> /// <param name="addProvenance"></param> /// <returns>An Excel file of the type xml.</returns> public FileResult GridStatisticsOnSpeciesObservationCountsAsExcel(bool addSettings = true, bool addProvenance = true) { SetServerDone(); if (SessionHandler.MySettings.Presentation.FileFormat.ExcelFileSettings.IsSettingsDefault()) { GridStatisticsOnSpeciesObservationCountExcelXlsx file = FileExportManager.GetGridSpeciesObservationCountsAsExcelXlsx(GetCurrentUser(), SessionHandler.MySettings.Presentation.Map.DownloadCoordinateSystemId, addSettings, addProvenance); MemoryStream returnStream = file.ToStream(); return(File(returnStream, XlsxExcelFileMimeType, CreateXlsxExcelFileName("GridStatisticsOnSpeciesObservationCounts"))); } else { GridStatisticsOnSpeciesObservationCountExcelXml file = FileExportManager.GetGridSpeciesObservationCountsAsExcelXml(GetCurrentUser(), SessionHandler.MySettings.Presentation.Map.DownloadCoordinateSystemId, addSettings, addProvenance); MemoryStream returnStream = file.ToStream(); return(File(returnStream, XmlExcelFileMimeType, CreateXmlExcelFileName("GridStatisticsOnSpeciesObservationCounts"))); } }
/// <summary> /// Creates an xlsx excel file with grid based data on species observation counts. /// </summary> /// <param name="currentUser">Current user context</param> /// <param name="coordinateSystem">The coordinate system.</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 GridStatisticsOnSpeciesObservationCountExcelXlsx GetGridSpeciesObservationCountsAsExcelXlsx(IUserContext currentUser, CoordinateSystemId coordinateSystem, bool addSettings, bool addProvenance) { GridStatisticsOnSpeciesObservationCountExcelXlsx file = new GridStatisticsOnSpeciesObservationCountExcelXlsx(currentUser, coordinateSystem, addSettings, addProvenance); return(file); }