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