private void openFileDialog1_FileOk(object sender, System.ComponentModel.CancelEventArgs e)
{
TrainingSample[] samples = null;
string filename = openFileDialog.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)
{
var sampleTable = db.GetWorksheet(t.Selection);
samples = new TrainingSample[sampleTable.Rows.Count];
for (int i = 0; i < samples.Length; i++)
{
samples[i] = new TrainingSample();
samples[i].Sequence = new double[(sampleTable.Columns.Count - 1) / 2][];
for (int j = 0; j < samples[i].Sequence.Length; j++)
{
samples[i].Sequence[j] =
new double[]
{
(double)sampleTable.Rows[i][j] * 50,
(double)sampleTable.Rows[i][j + 1] * 50
};
}
samples[i].Output = (int)(double)sampleTable.Rows[i][sampleTable.Columns.Count - 1] - 1;
}
}
}
else if (extension == ".xml")
{
using (var stream = openFileDialog.OpenFile())
{
XmlSerializer serializer = new XmlSerializer(typeof(TrainingSample[]));
samples = (TrainingSample[])serializer.Deserialize(stream);
}
}
dataGridView1.Rows.Clear();
for (int i = 0; i < samples.Length; i++)
{
var sequence = samples[i].Sequence;
var label = samples[i].Output + 1;
var bitmap = ToBitmap(sequence);
var row = dataGridView1.Rows.Add(bitmap, label, null);
dataGridView1.Rows[row].Tag = sequence;
}
}
private void openFileDialog1_FileOk(object sender, System.ComponentModel.CancelEventArgs e)
{
TrainingSample[] samples = null;
string filename = openFileDialog.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)
{
var sampleTable = db.GetWorksheet(t.Selection);
samples = new TrainingSample[sampleTable.Rows.Count];
for (int i = 0; i < samples.Length; i++)
{
samples[i] = new TrainingSample();
samples[i].Sequence = new double[(sampleTable.Columns.Count - 1) / 2][];
for (int j = 0; j < samples[i].Sequence.Length; j++)
{
samples[i].Sequence[j] =
new double[]
{
(double)sampleTable.Rows[i][j] * 50,
(double)sampleTable.Rows[i][j+1] * 50
};
}
samples[i].Output = (int)(double)sampleTable.Rows[i][sampleTable.Columns.Count - 1] - 1;
}
}
}
else if (extension == ".xml")
{
using (var stream = openFileDialog.OpenFile())
{
XmlSerializer serializer = new XmlSerializer(typeof(TrainingSample[]));
samples = (TrainingSample[])serializer.Deserialize(stream);
}
}
dataGridView1.Rows.Clear();
for (int i = 0; i < samples.Length; i++)
{
var sequence = samples[i].Sequence;
var label = samples[i].Output + 1;
var bitmap = ToBitmap(sequence);
var row = dataGridView1.Rows.Add(bitmap, label, null);
dataGridView1.Rows[row].Tag = sequence;
}
}
