/// <summary> /// Creates an excel file. /// Writes the content of a list into a worksheet of an excelfile and save the file. /// </summary> /// <param name="autosizeColumnWidth"> /// If true, the columns will be autosized. /// </param> /// <returns> /// The <see cref="MemoryStream"/>. /// </returns> private MemoryStream CreateExcelFile(bool autosizeColumnWidth = false) { var memoryStream = new MemoryStream(); try { using (ExcelPackage package = new ExcelPackage(memoryStream)) { var resultCalculator = new SummaryStatisticsResultCalculator(currentUser, SessionHandler.MySettings); var data = resultCalculator.GetSummaryStatisticsFromCacheIfAvailableOrElseCalculate(); // Add a new worksheet to the empty workbook. // The name of the sheet can not be longer than 31 characters. var worksheet = package.Workbook.Worksheets.Add("SLW Data"); AddHeaders(worksheet); AddSpeciesObservationsData(worksheet, data); FormatHeader(worksheet, 1, 2); if (autosizeColumnWidth) { worksheet.Cells.AutoFitColumns(0); } //Add aditional sheets if user has request that AddAditionalSheets(package); package.Save(); } memoryStream.Position = 0; return(memoryStream); } catch (Exception) { memoryStream.Dispose(); throw; } }
/// <summary> /// Constructor of an excel xml file with summary 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> public SummaryStatisticsExcelXml(IUserContext currentUser, bool addSettings, bool addProvenance) : base() { var resultCalculator = new SummaryStatisticsResultCalculator(currentUser, SessionHandler.MySettings); var data = resultCalculator.GetSummaryStatisticsFromCacheIfAvailableOrElseCalculate(); _xmlBuilder = new StringBuilder(); //Add file definitions and basic format settings _xmlBuilder.AppendLine(base.GetInitialSection()); //Specify column and row counts _xmlBuilder.AppendLine(base.GetColumnInitialSection(2, data.Count)); //Specify column widths _xmlBuilder.AppendLine(base.GetColumnWidthLine(200)); _xmlBuilder.AppendLine(base.GetColumnWidthLine(90)); //Add row with column headers _xmlBuilder.AppendLine(base.GetRowStart()); _xmlBuilder.AppendLine(base.GetColumnNameRowLine(Resource.ResultViewSummaryStatisticsSpeciesObservationTableColumnCalculationHeader)); _xmlBuilder.AppendLine(base.GetColumnNameRowLine(Resource.ResultViewSummaryStatisticsSpeciesObservationTableColumnCountHeader)); _xmlBuilder.AppendLine(base.GetRowEnd()); //Data values foreach (KeyValuePair <string, string> row in data) { _xmlBuilder.AppendLine(base.GetRowStart()); _xmlBuilder.AppendLine(base.GetDataRowLine("String", row.Key)); _xmlBuilder.AppendLine(base.GetDataRowLine("Number", row.Value)); _xmlBuilder.AppendLine(base.GetRowEnd()); } // Add final section of the xml document. _xmlBuilder.AppendLine(GetFinalSection(GetAditionalSheets(currentUser, addSettings, addProvenance))); }