private void PopulateHeuristics(ExcelWorksheet sheet, CodeSmell smell)
        {
            var heuristics = _requiredSmells.GetHeuristics(smell);

            for (var i = 0; i < heuristics.Count; i++)
            {
                sheet.Cells[2, 4, 4, 5].Copy(sheet.Cells[2, 6 + (2 * i), 4, 7 + (2 * i)]);
                sheet.Cells[2, 4 + (2 * i)].Value = heuristics[i];
            }
            sheet.Cells[2, 4 + (2 * heuristics.Count)].Value = "Custom heuristics.";
        }
 internal List <string> GetHeuristics(CodeSmell smell)
 {
     _heuristics.TryGetValue(smell, out var retVal);
     return(retVal);
 }
        private void PopulateInstances(ExcelWorksheet sheet, List <DataSetInstance> instances, CodeSmell smell)
        {
            int numOfHeuristics = _requiredSmells.GetHeuristics(smell).Count() + 1; // +1 for custom heuristic

            for (var i = 0; i < instances.Count; i++)
            {
                var row = 4 + i;
                sheet.Cells[row, 1].Value = instances[i].CodeSnippetId;
                sheet.Cells[row, 2].Value = instances[i].Link;
                if (_includeMetrics)
                {
                    PopulateMetrics(sheet, instances[i], row, 4 + (numOfHeuristics * 2));
                }

                if (i == instances.Count - 1)
                {
                    break;
                }
                var nextRow = row + 1;
                sheet.Cells[row + ":" + row].Copy(sheet.Cells[nextRow + ":" + nextRow]);
            }
        }