SQLDiagRunner.Runner.GetWorkSheetName C# (CSharp) Method

        private string GetWorkSheetName(string queryTitle, string worksheetPrefix)
        {
            var worksheetName = string.IsNullOrEmpty(worksheetPrefix) ? queryTitle : worksheetPrefix + " " + queryTitle;

            var worksheetNameSanitised = SanitiseWorkSheetName(worksheetName);

            // Check if name already exists: 31 char limit for worksheet names!
            while (_dictWorksheet.Contains(worksheetNameSanitised))
            {
                worksheetNameSanitised = worksheetNameSanitised.RandomiseLastNChars(3);
            }

            _dictWorksheet.Add(worksheetNameSanitised);

            return worksheetNameSanitised;
        }