BExIS.IO.Transform.Output.ExcelWriter.AddRows C# (CSharp) Метод

        protected void AddRows(WorksheetPart worksheetPart, int startRow, int endRow, List<AbstractTuple> dataTuples)
        {
            Worksheet worksheet = worksheetPart.Worksheet;
            SheetData sheetData = worksheet.GetFirstChild<SheetData>();

            int rowIndex = endRow;
            //add row
            foreach (DataTuple dataTuple in dataTuples)
            {

                // convert datatuple to row and add it to sheetdata
                Row row = DatatupleToRow(dataTuple, rowIndex);

                bool empty = true;
                foreach (Cell c in row.Elements<Cell>().ToList())
                {
                    if (!String.IsNullOrEmpty(c.InnerText))
                    {
                        empty = false;
                        break;
                    }
                }

                if (!empty)
                {
                    sheetData.Append(row);
                    if (!dataTuple.Equals(dataTuples.Last()))
                        rowIndex++;
                }
            }

            numOfDataRows = rowIndex;
        }