private void loadDataButton_Click(object sender, EventArgs e)
{
plotDataGridView.Visible = true;
Refresh();
if (openDataFile.ShowDialog(this) == DialogResult.OK)
{
string filename = openDataFile.FileName;
string extension = Path.GetExtension(filename);
if (extension == ".xls" || extension == ".xlsx")
{
ExcelReader db = new ExcelReader(filename, true, false);
TableSelectDialog t = new TableSelectDialog(db.GetWorksheetList());
if (t.ShowDialog(this) == DialogResult.OK)
{
DataTable tableSource = db.GetWorksheet(t.Selection);
this.plotDataGridView.DataSource = tableSource;
//this.dgvProjectionSource.DataSource = tableSource.Copy();
//double[,] graph = tableSource.ToMatrix(out sourceColumns); FIX ME HERE
//CreateScatterplot(graphInput, graph);
}
}
}
}
/// <summary>
/// Sends the data grid values to the plot window.
/// </summary>
private void plotButton_Click(object sender, EventArgs e)
{
if (openDataFile.ShowDialog(this) == DialogResult.OK)
{
string filename = openDataFile.FileName;
string extension = Path.GetExtension(filename);
if (extension == ".xls" || extension == ".xlsx")
{
ExcelReader db = new ExcelReader(filename, true, false);
TableSelectDialog t = new TableSelectDialog(db.GetWorksheetList());
if (t.ShowDialog(this) == DialogResult.OK)
{
DataTable tableSource = db.GetWorksheet(t.Selection);
this.plotDataGridView.DataSource = tableSource;
CreateACModeGraph(zedGraphControl, CreateList(tableSource));
}
}
}
}