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; } }