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