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 ExportListResultsToExcelSPSS(ExcelWorkBookAdaptor wbk, List <LocalityResult> results, int policyIndex, ref int row)
{
int localityIndex = 1;
var policyIndexList = new List <int>();
Enumerable.Range(0, results[0].Data.Count).ToList().ForEach(x => policyIndexList.Add(policyIndex));
foreach (var result in results)
{
var startRow = row;
var pipe = new ListToExcelTableAdaptor <double>(wbk[0], result.Data);
pipe.Write(new ExcelCellCoordinate(startRow, 1), 1);
startRow = row;
var policyPipe = new ListToExcelTableAdaptor <int>(wbk[0], policyIndexList);
policyPipe.Write(new ExcelCellCoordinate(startRow, 2), 1);
startRow = row;
var localityIndexList = new List <int>();
Enumerable.Range(0, results[0].Data.Count).ToList().ForEach(x => localityIndexList.Add(localityIndex));
var localityPipe = new ListToExcelTableAdaptor <int>(wbk[0], localityIndexList);
localityPipe.Write(new ExcelCellCoordinate(startRow, 3), 1);
row += result.Data.Count;
localityIndex++;
}
}
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);
}
public static void Main(string[] args)
{
Console.WriteLine("Hello World!");
// TODO: Implement Functionality Here
//adaptor.OpenExisting(@"C:\Test Excel\Book1.xlsx");
var data = new List <double>();
data.Add(10);
data.Add(10);
data.Add(10);
data.Add(10);
data.Add(10);
var data2 = new List <string>();
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
var adaptor = new ExcelWorkBookAdaptor();
adaptor.NewBook();
var listAdapter = new ListToExcelTableAdaptor <string>(adaptor[0], data2);
listAdapter.Write(new ExcelCellCoordinate(10, 10), 2);
var format = new ExcelRangeTableStyle(adaptor[0], new ExcelCellCoordinate(10, 10), new ExcelCellCoordinate(15, 15))
{
FirstRowContainHeaders = true
};
format.Execute();
adaptor.Show();
Console.Write("Press any key to continue . . . ");
Console.ReadKey(true);
adaptor.SaveAndClose(@"C:\Test Excel\Book2.xlsx");
}
private void ExportListResultsToExcel(ExcelWorkBookAdaptor wbk, int sheetIndex, List <LocalityResult> results)
{
int column = 1;
foreach (var result in results)
{
var pipe = new ListToExcelTableAdaptor <double>(wbk[sheetIndex], result.Data);
pipe.Write(new ExcelCellCoordinate(1, column++), 1);
}
}
private void ExportResultsToExcel <T>(ExcelWorkBookAdaptor wbk, List <T> results, ExcelCellCoordinate coord)
{
var pipe = new ObjectPropertiesToExcelAdapter <T>(wbk[0], results);
pipe.Write(coord);
ExcelCellCoordinate bottomRight = new ExcelCellCoordinate(coord.Row + results.Count, coord.Col + PropertyCount(results) - 1);
ExcelRangeTableStyle style = new ExcelRangeTableStyle(wbk[0], coord, bottomRight)
{
FirstRowContainHeaders = true
};
style.Execute();
}
void ExportLocalityDetailToExcelTabular()
{
ExcelWorkBookAdaptor wbk = new ExcelWorkBookAdaptor();
wbk.NewBook();
ExportListResultsToExcel(wbk, 0, this.resultsComparisonPanel1.GetHomeResults());
ExportListResultsToExcel(wbk, 1, this.resultsComparisonPanel1.GetGPResults());
wbk[0].Name = "Home";
wbk[1].Name = "GP";
wbk.Show();
}
void ExportResultsToExcelToolStripMenuItemClick(object sender, EventArgs e)
{
ExcelWorkBookAdaptor wbk = new ExcelWorkBookAdaptor();
wbk.NewBook();
ExportResultsToExcel(wbk, this.allocationResultsPanel1.GetResults(), new ExcelCellCoordinate(1, 1));
ExportResultsToExcel(wbk, this.meanDifferenceConfidenceIntervalPanel1.GetResults(), new ExcelCellCoordinate(5, 1));
ExportResultsToExcel(wbk, this.resultsComparisonPanel1.GetHomeResults(), new ExcelCellCoordinate(1, 7));
ExportResultsToExcel(wbk, this.resultsComparisonPanel1.GetGPResults(), new ExcelCellCoordinate(10, 7));
wbk[0].Name = this.ResultsDescription.Substring(0, Math.Min(30, this.ResultsDescription.Length));
wbk.Show();
}
void ExportLocalityDetailToExcelSPSS()
{
ExcelWorkBookAdaptor wbk = new ExcelWorkBookAdaptor();
wbk.NewBook();
int row = 1;
ExportListResultsToExcelSPSS(wbk, this.resultsComparisonPanel1.GetHomeResults(), 1, ref row);
ExportListResultsToExcelSPSS(wbk, this.resultsComparisonPanel1.GetGPResults(), 2, ref row);
wbk[0].Name = "Home";
wbk[1].Name = "GP";
wbk.Show();
}
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();
}
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();
}
private void button1_Click(object sender, EventArgs e)
{
var adaptor = new ExcelWorkBookAdaptor();
adaptor.NewBook();
Point topLeft = new Point(1, 1);
Point bottomRight = new Point(this.grid.ScenarioData.Columns.Count, this.grid.ScenarioData.Rows.Count + 1);
var tableAdapter = new DataTableToExcelAdapter(adaptor[0], this.grid.ScenarioData);
tableAdapter.Write(topLeft);
var format = new ExcelRangeTableStyle(adaptor[0], topLeft, bottomRight)
{
FirstRowContainHeaders = true
};
format.Execute();
adaptor.Show();
}
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");
}
}
