public void TestExcelExport() { var excelFileName = Directory.GetCurrentDirectory() + @"\ExportTest.xlsx"; var bern = new City("Bern", "Switzerland", 5000, 46.95, 7.44); var zuerich = new City("Zürich", "Switzerland", 100000, 32.876174, 13.187507); var aarau = new City("Aarau", "Switzerland", 10000, 35.876174, 12.187507); var link1 = new Link(bern, aarau, 15, TransportModes.Ship); var link2 = new Link(aarau, zuerich, 20, TransportModes.Ship); var links = new List <Link>(); links.Add(link1); links.Add(link2); var excel = new ExcelExchange(); var statusMessage = excel.WriteToFile(excelFileName, bern, zuerich, links); excel.WriteToFile(excelFileName, bern, zuerich, links); Assert.IsTrue(File.Exists(excelFileName), excelFileName + " / " + statusMessage); }
public static void excel() { var excelFileName = @"C:\tmp\out.xlsx"; System.Console.WriteLine(excelFileName); var bern = new City("Bern", "Switzerland", 5000, 46.95, 7.44); var zuerich = new City("Zürich", "Switzerland", 100000, 32.876174, 13.187507); var aarau = new City("Aarau", "Switzerland", 10000, 35.876174, 12.187507); var link1 = new Link(bern, aarau, 15, TransportModes.Ship); var link2 = new Link(aarau, zuerich, 20, TransportModes.Ship); var links = new List <Link>(); links.Add(link1); links.Add(link2); var excel = new ExcelExchange(); excel.WriteToFile(excelFileName, bern, zuerich, links); }
static void Main(string[] args) { Version version = Assembly.GetEntryAssembly().GetName().Version; Console.WriteLine("Welcome to RoutePlanner ({0})", version); WayPoint wayPoint = new WayPoint("Windisch", 47.479319847061966, 8.212966918945312); Console.WriteLine(wayPoint.ToString()); WayPoint wpBern = new WayPoint("Bern", 46.9472221, 7.451202500000022); WayPoint wpTripolis = new WayPoint("Tripolis", 59.86062519999999, 17.650885199999948); Console.WriteLine("Distanz Bern-Tripolis: {0}km", wpBern.Distance(wpTripolis)); City cBern = new City("Bern", "Schweiz", 75000, 47.479319847061966, 8.212966918945312); City c0 = new City("Mumbai", "India", 12383146, 18.96, 72.82); string serializedCity = string.Empty; using (StringWriter outstream = new StringWriter()) { SimpleObjectWriter writer = new SimpleObjectWriter(outstream); writer.Next(cBern); serializedCity = outstream.ToString(); } Console.WriteLine(serializedCity); using (StringReader inStream = new StringReader(serializedCity)) { SimpleObjectReader reader = new SimpleObjectReader(inStream); object o = reader.Next(); } WayPoint wp = c0.Location; Cities c = new Cities(); c.ReadCities("citiesTestDataLab2.txt"); c.FindNeighbours(wp, 2000); c.ReadCities("citiesTestDataLab2.txt"); var routes = new RoutesDijkstra(c); var reqWatch = new RouteRequestWatcher(); routes.RouteRequestEvent += reqWatch.LogRouteRequests; routes.FindShortestRouteBetween("Mumbai", "India", TransportModes.Rail); routes.FindShortestRouteBetween("Mumbai", "India", TransportModes.Rail); routes.FindShortestRouteBetween("India", "Mumbai", TransportModes.Rail); Console.WriteLine("City found: {0}", c.FindCity("Mumbai").Name); c.ReadCities("citiesTestDataLab4.txt"); Routes r = new RoutesDijkstra(c); r.RouteRequestEvent += reqWatch.LogRouteRequests; r.ReadRoutes("linksTestDataLab4.txt"); List <Link> l = r.FindShortestRouteBetween("Zürich", "Winterthur", TransportModes.Rail); foreach (Link link in l) { Console.WriteLine("from {0} to {1} in {2}", link.FromCity.Name, link.ToCity.Name, link.Distance); } Console.ReadKey(); City zurich = c.FindCity("Zürich"); City winterthur = c.FindCity("Winterthur"); ExcelExchange export = new ExcelExchange(); export.WriteToFile("Test.xls", zurich, winterthur, l); }