//"[^a-zA-Z0-9-]+ public void AdaptDescription_ShouldCleanNotNeededSymbols() { string testFile = $@"{projectDirectory}\ProductExcelSheets.app.tests\testGlasses_{this.GetCurrentMethod()}.xlsx"; if (File.Exists(testFile)) { File.Delete(testFile); } File.Copy(filePath, testFile); ExcelManager excelManager = new ExcelManager(mockedFileLogger.Object, "test.info", testFile); string sheetName = "SaintGobain"; excelManager.AdaptDescription(sheetName); var fileinfo = new FileInfo(testFile); if (fileinfo.Exists) { using (ExcelPackage excelPackage = new ExcelPackage(fileinfo)) { ExcelWorkbook excelWorkBook = excelPackage.Workbook; ExcelWorksheet excelWorksheet = excelWorkBook.Worksheets.Where(s => s.Name == sheetName).FirstOrDefault(); var columnDescription = excelWorksheet.Cells["1:1"].First(c => c.Value.ToString() == "Description").Start.Column; int rangeMaxRows = excelWorksheet.Dimension.End.Row; for (int i = 2; i <= rangeMaxRows; i++) { string cellStrDescription = excelWorksheet.Cells[i, columnDescription].Value.ToString(); Assert.IsTrue(cellStrDescription.Length <= DescriptionStringMaxLength); Regex re = new Regex(@"^[a-zA-Z0-9- ]+$"); Assert.IsTrue(re.IsMatch(cellStrDescription)); } } } this.RemoveFile(testFile); }