private void AddData(ExcelWorksheet worksheet)
{
var rowIndex = 2;
foreach (var taxon in _data)
{
worksheet.Cells[rowIndex, TaxonIdColumnIndex].Value = taxon.Item1;
worksheet.Cells[rowIndex, ScientificNameColumnIndex].Value = taxon.Item2;
worksheet.Cells[rowIndex, SwedishNameColumnIndex].Value = taxon.Item3;
long result;
if (aooEooExcelFormatter.TryConvertKm2StringToNumber(taxon.Item4, out result))
{
worksheet.Cells[rowIndex, AooColumnIndex].Value = result;
}
else
{
worksheet.Cells[rowIndex, AooColumnIndex].Value = "";
}
if (aooEooExcelFormatter.TryConvertKm2StringToNumber(taxon.Item5, out result))
{
worksheet.Cells[rowIndex, EooColumnIndex].Value = result;
}
else
{
worksheet.Cells[rowIndex, EooColumnIndex].Value = "";
}
rowIndex++;
}
}
/// <summary>
/// Initializes a new instance of the <see cref="SpeciesAOOEOOExcelXml"/> class.
/// </summary>
/// <param name="currentUser">The current user.</param>
/// <param name="data">The data.</param>
/// <param name="addSettings">if set to <c>true</c> settings report should be added.</param>
/// <param name="addProvenance">if set to <c>true</c> provenance report should be added.</param>
/// <param name="aooEooExcelFormatter">The aoo eoo excel formatter.</param>
public SpeciesAOOEOOExcelXml(
IUserContext currentUser,
Tuple <int, string, string, string, string>[] data,
bool addSettings,
bool addProvenance,
IAooEooExcelFormatter aooEooExcelFormatter)
: base()
{
_xmlBuilder = new StringBuilder();
// Add file definitions and basic format settings
_xmlBuilder.AppendLine(GetInitialSection());
// Specify column and row counts
CoordinateSystemId coordinateSystemId = (CoordinateSystemId)SessionHandler.MySettings.Calculation.GridStatistics.CoordinateSystemId.Value;
List <string> columns = new List <string>();
columns.Add(Resource.LabelTaxonId);
columns.Add(Resource.TaxonSharedScientificName);
columns.Add(Resource.TaxonSharedSwedishName);
columns.Add(aooEooExcelFormatter.GetAooHeader(coordinateSystemId));
columns.Add(aooEooExcelFormatter.GetEooHeader(coordinateSystemId));
_xmlBuilder.AppendLine(GetColumnInitialSection(columns.Count, data.Length));
// Specify column widths
foreach (var column in columns)
{
_xmlBuilder.AppendLine(GetColumnWidthLine(100));
}
// Add row with column headers
_xmlBuilder.AppendLine(GetRowStart());
foreach (string column in columns)
{
_xmlBuilder.AppendLine(GetColumnNameRowLine(column));
}
_xmlBuilder.AppendLine(GetRowEnd());
// Data values
foreach (var taxon in data)
{
_xmlBuilder.AppendLine(GetRowStart());
_xmlBuilder.AppendLine(GetDataRowLine("Number", taxon.Item1.ToString(CultureInfo.InvariantCulture)));
_xmlBuilder.AppendLine(GetDataRowLine("String", taxon.Item2));
_xmlBuilder.AppendLine(GetDataRowLine("String", taxon.Item3));
long result;
if (aooEooExcelFormatter.TryConvertKm2StringToNumber(taxon.Item4, out result))
{
_xmlBuilder.AppendLine(GetDataRowLine("Number", result.ToString(CultureInfo.InvariantCulture)));
}
else
{
_xmlBuilder.AppendLine(GetDataRowLine("String", ""));
}
if (aooEooExcelFormatter.TryConvertKm2StringToNumber(taxon.Item5, out result))
{
_xmlBuilder.AppendLine(GetDataRowLine("Number", result.ToString(CultureInfo.InvariantCulture)));
}
else
{
_xmlBuilder.AppendLine(GetDataRowLine("String", ""));
}
_xmlBuilder.AppendLine(GetRowEnd());
}
_xmlBuilder.AppendLine(GetFinalSection(GetAditionalSheets(currentUser, addSettings, addProvenance)));
}