public static void CompareCellsOnTheSameWorkbook(ComparisonWorkbookBase source, string filename) { var settings = new CellsComparisonSettings(); Console.WriteLine("Comparing two cells on the same workbook and the same worksheet"); var result = source.Worksheets[0].CellRange["A1"].CompareWith(source.Worksheets[0].CellRange["B1"], settings); Console.WriteLine("Comparison Done. Creating a file with result changes"); result.GetWorkbook().Save(filename); Console.WriteLine("File with result changes was successfully created\n\n"); }
public static void CompareErrorCellWithNonError(ComparisonWorkbookBase source, ComparisonWorkbookBase target, string filename) { var settings = new CellsComparisonSettings(); Console.WriteLine("Comparing two cells on different workbook where source and target cells contain plain text"); var result = source.Worksheets[0].CellRange["A6"].CompareWith(target.Worksheets[0].CellRange["A6"], settings); Console.WriteLine("Comparison Done. Creating a file with result changes"); result.GetWorkbook().Save(filename); Console.WriteLine("File with result changes was successfully created\n\n"); }
public static void CompareWorksheetsFromOneDocuments(ComparisonWorkbookBase source, string filePath, string imagePath) { var settings = new CellsComparisonSettings(); Console.WriteLine("Comparing two worksheet from one workbook"); var result = source.Worksheets[1].CompareWith(source.Worksheets[2], settings); Console.WriteLine("Worksheets were successfully compared"); result.GetWorkbook().Save(filePath); Console.WriteLine("Results were successfully saved to a file"); result.GetWorkbook().SaveAsImages(imagePath); Console.WriteLine("Results were successfully saved to a bunch of images\n\n"); }
public static void CompareTwoWorkbooks(ComparisonWorkbookBase source, ComparisonWorkbookBase target, string filePath, string imagePath) { var settings = new CellsComparisonSettings(); Console.WriteLine("Comparing two workbooks with the same quantity of worksheets"); var result = source.CompareWith(target, settings); Console.WriteLine("Workbooks were successfully compared"); result.GetWorkbook().Save(filePath); Console.WriteLine("Results were successfully saved to file"); result.GetWorkbook().SaveAsImages(imagePath); Console.WriteLine("Results were successfully saved to a bunch of images\n\n"); }
public static void CompareWorksheetsWithDifferentContent(ComparisonWorkbookBase source, ComparisonWorkbookBase target, string filePath, string imagePath) { var settings = new CellsComparisonSettings(); Console.WriteLine("Comparing two worksheet with different content"); var result = source.Worksheets[3].CompareWith(target.Worksheets[3], settings); Console.WriteLine("Worksheets were successfully compared"); result.GetWorkbook().Save(filePath); Console.WriteLine("Results were successfully saved to a file"); result.GetWorkbook().SaveAsImages(imagePath); Console.WriteLine("Results were successfully saved to a bunch of images\n\n"); }
public static void CompareTwoWorkbooksWithDeletedAndAddedWorksheets(ComparisonWorkbookBase source, ComparisonWorkbookBase target, string filePath, string imagePath) { var settings = new CellsComparisonSettings(); Console.WriteLine( "Comparing two workbooks where both of them contain worksheets that are not presented in the opponent document"); var result = source.CompareWith(target, settings); Console.WriteLine("Workbooks were successfully compared"); result.GetWorkbook().Save(filePath); Console.WriteLine("Results were successfully saved to file"); result.GetWorkbook().SaveAsImages(imagePath); Console.WriteLine("Results were successfully saved to a bunch of images\n\n"); }
public static void CompareTwoWorkbooksWithDeletedWorksheets(ComparisonWorkbookBase source, ComparisonWorkbookBase target, string filePath, string imagePath) { var settings = new CellsComparisonSettings(); Console.WriteLine( "Comparing two workbooks where target document doesn't contain some worksheets from source workbook"); var result = source.CompareWith(target, settings); Console.WriteLine("Workbooks were successfully compared"); result.GetWorkbook().Save(filePath); Console.WriteLine("Results were successfully saved to file"); result.GetWorkbook().SaveAsImages(imagePath); Console.WriteLine("Results were successfully saved to a bunch of images\n\n"); }
public static void CompareEmptyWorksheetWithNotEmpty(ComparisonWorkbookBase source, ComparisonWorkbookBase target, string filePath, string imagePath) { var settings = new CellsComparisonSettings(); Console.WriteLine("Comparing two worksheet first worksheet is empty"); var result = source.Worksheets[3].CompareWith(target.Worksheets[1], settings); Console.WriteLine("Worksheets were successfully compared"); ComparisonWorkbookBase workbook = result.GetWorkbook(); workbook.Save(filePath); Console.WriteLine("Results were successfully saved to a file"); //result.GetWorkbook().SaveAsImages(imagePath); Console.WriteLine("Results were successfully saved to a bunch of images\n\n"); }
public static void CompareTwoBigWorkbooks(ComparisonWorkbookBase source, ComparisonWorkbookBase target, string filePath /*, string imagePath*/) { var settings = new CellsComparisonSettings(); Console.WriteLine("Comparing two workbooks with big amount of worksheet and cells in there"); Stopwatch watch = new Stopwatch(); watch.Start(); var result = source.CompareWith(target, settings); Console.WriteLine("Workbooks were successfully compared"); result.GetWorkbook().Save(filePath); Console.WriteLine("Results were successfully saved to file"); watch.Stop(); Console.WriteLine("Compared for - " + watch.ElapsedMilliseconds + "milliseconds\n\n"); }