Fhnw.Ecnf.RoutePlanner.RoutePlannerLib.Export.ExcelExchange.WriteToFile C# (CSharp) Method

        public void WriteToFile(String fileName, City from, City to, List<Link> links)
        {
            var excel = new Excel.Application();
            excel.DisplayAlerts = false;
            excel.Workbooks.Add();

            excel.Range["A1", "D1"].Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
            excel.Range["A1", "D1"].Font.Size = 14;
            excel.Range["A1", "D1"].Font.Bold = true;
            excel.Range["A1"].Value = "From";
            excel.Range["B1"].Value = "To";
            excel.Range["C1"].Value = "Distance";
            excel.Range["D1"].Value = "Transport Mode";

            int row = 2;
            foreach (var l in links)
            {
                excel.Range["A" + row.ToString()].Value = l.FromCity.Name;
                excel.Range["B" + row.ToString()].Value = l.ToCity.Name;
                excel.Range["C" + row.ToString()].Value = l.Distance;
                excel.Range["D" + row.ToString()].Value = l.TransportMode.ToString();
                row++;
            }

            excel.Columns.AutoFit();

            Excel._Workbook doc = excel.ActiveWorkbook;

            doc.SaveAs(fileName);
            doc.Close();
        }

        public void TestExcelExport()
        {
            string excelFileName = Directory.GetCurrentDirectory() + @"\ExportTest.xlsx";

            City bern = new City("Bern", "Switzerland", 5000, 46.95, 7.44);
            City zuerich = new City("Zürich", "Switzerland", 100000, 32.876174, 13.187507);
            City aarau = new City("Aarau", "Switzerland", 10000, 35.876174, 12.187507);
            Link link1 = new Link(bern, aarau, 15, TransportModes.Ship);
            Link link2 = new Link(aarau, zuerich, 20, TransportModes.Ship);
            List<Link> links = new List<Link>();
            links.Add(link1);
            links.Add(link2);

            // TODO: Fix starting Excel on sever (not robust)
            ExcelExchange excel = new ExcelExchange();

            Console.WriteLine("Export Path is: {0}", excelFileName);

            excel.WriteToFile(excelFileName, bern, zuerich, links);

            // first verify that file exists
            Assert.IsTrue(File.Exists(excelFileName));

            // now verify the content of the file
            // TODO: Fix reading file on sever
            VerifyExcelContent(excelFileName);
        }