Esempio n. 1
0
        static void Main(string[] args)
        {
            DataTable tableOutput = null;
            var adapter = new ExcelWorkBookAdaptor();
            adapter.Open("C:/temp/Book1.xlsx");
            var xlRangeAdapter = new ExcelRangeToDataTableAdapter(adapter[0]);
            Point topLeft = new Point(1, 1);
            Point bottomRight = new Point(2, 20);

            try
            {
                tableOutput = xlRangeAdapter.ReadTable("A1:B21");
            }
            catch(Exception ex)
            {
                Console.Write(ex.Message);
            }
            finally
            {
                adapter.CloseNoSave();
            }

            var calc = new PythagoreanCalculator();

            //var generator = new CentroidDistanceGenerator(calc);
            //CentroidTest(tableOutput, generator);

            MatrixTest(tableOutput, ref adapter, ref topLeft, calc);
        }
Esempio n. 2
0
        private static void MatrixTest(DataTable tableOutput, ref ExcelWorkBookAdaptor adapter, ref Point topLeft, PythagoreanCalculator calc)
        {
            var generator = new MatrixGenerator(calc);
            var matrix = generator.GenerateMatrix(tableOutput, new EastingNorthingColumnIndexer(0, 1));

            if (null != matrix)
            {
                adapter = new ExcelWorkBookAdaptor();
                adapter.NewBook();
                adapter.Show();
                var tableAdapter = new DataTableToExcelAdaptor(adapter[0], matrix);
                tableAdapter.Write(topLeft);

            }

            var len = new SimpleTourLengthCalculator(matrix);
            Console.WriteLine(len.TourLength(Enumerable.Range(0, 4).ToList<int>()).ToString());
            Console.WriteLine("Press any key to exit");
            Console.ReadKey();
        }