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);
}
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);
}
private void button2_Click(object sender, EventArgs e)
{
DataTable tableOutput = null;
var adapter = new ExcelWorkBookAdaptor();
adapter.Open("C:/temp/Book1.xlsx");
adapter.Show();
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)
{
MessageBox.Show(ex.Message);
}
finally
{
adapter.CloseNoSave();
}
if (null != tableOutput)
{
adapter = new ExcelWorkBookAdaptor();
adapter.NewBook();
adapter.Show();
var tableAdapter = new DataTableToExcelAdapter(adapter[0], tableOutput);
tableAdapter.Write(topLeft);
//adapter.SaveAndClose("C:/temp/Book2.xlsx");
}
}