public void CreateForceDirectedTable_OurimbahMNGT20062018S2()
        {
            var consoleReader = new ConsoleReaderForTests("OurimbahMNGT20062018S2PATHWAY", "OurimbahMNGT20062018S2OUTPUT", "OurimbahMNGT20062018S1TESTFILE1");

            var forceDirectedTableMaker = new ForceDirectedTableMakerTool();

            forceDirectedTableMaker.CreateForceDirectedTable(consoleReader);

            var worksheetTableComparer = new WorksheetTableComparerForTests(consoleReader.GetTestFilePath(), consoleReader.GetNewSaveFilePath(), "ForceDirectedTable");

            worksheetTableComparer.Compare();
        }
        public void GeneratePathwaysForListOfStudentsFromEnrollmentData(ConsoleReaderForTests consoleReader)
        {
            var pathwayMakerTool = new PathwayMakerTool();

            pathwayMakerTool.MakePathways(consoleReader);

            var tableComparer = new WorksheetTableComparerForTests(consoleReader.GetTestFilePath(), consoleReader.GetNewSaveFilePath(), consoleReader.GetWorksheetName());

            tableComparer.Compare();
            //var rowCount = 2;
            //while (rowCount <= (testFile as Worksheet).UsedRange.Rows.Count)
            //{
            //    var colCount = 2;
            //    while (colCount <= (testFile as Worksheet).UsedRange.Columns.Count)
            //    {
            //        Assert.AreEqual((((testFile as Worksheet).Cells[rowCount, colCount] as Range).Value as string)?.Trim(),
            //            (((outputFile as Worksheet).Cells[rowCount, colCount] as Range).Value as string)?.Trim(),
            //            String.Format("Pathways didn't match. Student: {0} Semester {1}, {2}",
            //                    ((testFile as Worksheet).Cells[rowCount, 1] as Range).Value.ToString(),
            //                    ((testFile as Worksheet).Cells[2, colCount] as Range).Value.ToString(),
            //                    ((testFile as Worksheet).Cells[1, colCount] as Range).Value.ToString()));
            //        colCount++;
            //    }
            //    rowCount++;
            //}



            //}
            //catch (Exception ex)
            //{
            //    outputWorkbook.Close();
            //    app.Quit();
            //    System.Runtime.InteropServices.Marshal.ReleaseComObject(outputFile);
            //    System.Runtime.InteropServices.Marshal.ReleaseComObject(outputWorkbook);
            //    System.IO.File.Delete(consoleReader.GetNewSaveFilePath());
            //    throw;
            //}
        }