private static void ExcelTest() { try { long loadingTime; long comparisonTime; ConsoleUtils.WriteTitle($"Excel files test", 1); ConsoleUtils.WriteLine(); ConsoleUtils.Write($"Excel file path (default = \n {excelFilePath},\n 'q' to quit) : "); userInput = Console.ReadLine(); ConsoleUtils.WriteLine(); if (userInput == "q") { return; } if (!string.IsNullOrEmpty(userInput)) { excelFilePath = userInput; } sw.Restart(); XLWorkbook workbook = new XLWorkbook(excelFilePath); IXLWorksheet worksheetRef = workbook.Worksheet(1); IXLWorksheet worksheetNew = workbook.Worksheet(2); var rowsRef = worksheetRef.RowsUsed(); var rowsNew = worksheetNew.RowsUsed(); sw.Stop(); loadingTime = sw.ElapsedMilliseconds; ConsoleUtils.WriteLine(); ConsoleUtils.WriteLine($"Excel file loading : {loadingTime} ms"); var excelComparer = new ListComparer <IXLRow>(); var xLRowContentComparer = new XLRowContentComparer(); var xLRowIdentityComparer = new XLRowIdentityComparer(); sw.Restart(); var r = excelComparer.Compare(rowsRef, rowsNew, xLRowIdentityComparer, xLRowContentComparer, (c) => c.RowNumber()); sw.Stop(); comparisonTime = sw.ElapsedMilliseconds; ConsoleUtils.WriteLine(); ConsoleUtils.WriteLine(ToString(r), InfoType.result); ConsoleUtils.WriteLine(); ConsoleUtils.WriteLine($"Comparison : {comparisonTime} ms"); executionTime = loadingTime + comparisonTime; sw.Start(); } catch (Exception e) { ConsoleUtils.WriteLine(e.ToStringEx(), InfoType.error); } }
private static void IntTest() { try { var previousNbItem = nbItem; var previousSpread = spread; long dataSetBuildTime; long comparisonTime; ConsoleUtils.WriteTitle($"Int collection test", 1); ConsoleUtils.WriteLine(); ConsoleUtils.Write($"Nb item (defaut = {nbItem}, 'q' to quit) : "); userInput = Console.ReadLine(); if (userInput == "q") { return; } var isUserInputValid = int.TryParse(userInput, out nbItem); if (!isUserInputValid) { nbItem = previousNbItem; } ConsoleUtils.Write($"Dispersion (defaut = {spread}, 'q' to quit) : "); userInput = Console.ReadLine(); if (userInput == "q") { return; } isUserInputValid = int.TryParse(userInput, out spread); if (!isUserInputValid) { spread = previousSpread; } sw.Restart(); CreateIntTestData(nbItem, spread); sw.Stop(); dataSetBuildTime = sw.ElapsedMilliseconds; ConsoleUtils.WriteLine(); ConsoleUtils.WriteLine($"Test data creation :{dataSetBuildTime} ms"); var ilc = new ListComparer <int>(); sw.Restart(); var comparison = ilc.Compare(intListRef, intListNew); Console.WriteLine(); sw.Stop(); comparisonTime = sw.ElapsedMilliseconds; sw.Start(); ConsoleUtils.WriteLine($"Comparison :{comparisonTime} ms"); Console.WriteLine(); ConsoleUtils.WriteLine(ToString(comparison), InfoType.result); executionTime = dataSetBuildTime + comparisonTime; } catch (Exception e) { ConsoleUtils.WriteLine(e.ToStringEx(), InfoType.error); } }