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);
}
/// <summary>
/// Opens the Pythagorean calculator.
/// </summary>
private void PythagoreanCalculatorButtonClick(object sender, EventArgs e)
{
if (PythagoreanCalculator.Instance == false)
{
var form = new PythagoreanCalculator(this);
form.Show(this);
PythagoreanCalculator.Instance = true;
}
else if (PythagoreanCalculator.Instance)
{
// Do nothing.
}
}
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();
}