void LoadFinished(object sender, EventArgs ea)
{
if (InvokeRequired)
{
Invoke(new Action <object, EventArgs>(LoadFinished), sender, ea);
return;
}
if (whole_excel.Tables.Count < 2)
{
throw new Exception("Worksheet is not in expected format.");
}
// Add names to combolist
foreach (DataTable dts in whole_excel.Tables)
{
comboBox_sheet.Items.Add(dts.TableName.Replace("$", ""));
}
comboBox_type.SelectedIndex = 0;
comboBox_sheet.SelectedIndex = 0;
comboBox_sheet.Visible = true;
comboBox_type.Visible = true;
dataGridView1.Visible = true;
loadingBar.Visible = false;
sheet_and_type.Visible = true;
filename_holder.Visible = true;
Refresh_btn.Visible = true;
Reload_btn.Visible = true;
Export_btn.Visible = true;
filename_holder.Text = Path.GetFileName(filePath);
this.Refresh();
if (whole_excel.Tables["filter$"] == null)
{
MessageBox.Show("Data Imported Successfully But Filter sheet not found!");
}
else
{
MessageBox.Show("Data Imported Successfully!");
}
FlashWindow.Flash(this);
}
private void Export_Click(object sender, EventArgs e)
{
loadingBar.Visible = true;
loadingBar.Refresh();
sheet_and_type.Visible = false;
sheet_and_type.Refresh();
string selectedSheet = ((string)comboBox_sheet.SelectedItem);
string selectedType = (string)comboBox_type.SelectedItem;
Thread t3 = new Thread(delegate()
{
DataTable dt = (DataTable)dataGridView1.DataSource;
StringBuilder sb = new StringBuilder();
IEnumerable <string> columnNames = dt.Columns.Cast <DataColumn>().
Select(column => column.ColumnName);
sb.AppendLine(string.Join(",", columnNames));
foreach (DataRow row in dt.Rows)
{
IEnumerable <string> fields = row.ItemArray.Select(field => field.ToString().Replace(",", " "));
sb.AppendLine(string.Join(",", fields));
}
if (File.Exists(Path.GetDirectoryName(filePath) + "/" + Path.GetFileNameWithoutExtension(filePath) + "-" + selectedSheet + "-" + selectedType + ".csv"))
{
File.Delete(Path.GetDirectoryName(filePath) + "/" + Path.GetFileNameWithoutExtension(filePath) + "-" + selectedSheet + "-" + selectedType + ".csv");
}
File.WriteAllText(Path.GetDirectoryName(filePath) + "/" + Path.GetFileNameWithoutExtension(filePath) + "-" + selectedSheet + "-" + selectedType + ".csv", sb.ToString());
this.Invoke((MethodInvoker) delegate
{
loadingBar.Visible = false;
sheet_and_type.Visible = true;
FlashWindow.Flash(this);
MessageBox.Show("Data Exported Successfully!");
});
});
t3.Start();
}
public void setData(object sender, System.EventArgs e)
{
sheet_and_type.Text = "";
sheet_and_type.Visible = false;
sheet_and_type.Refresh();
loadingBar.Visible = true;
loadingBar.Refresh();
string selectedSheet = ((string)comboBox_sheet.SelectedItem);
string selectedType = (string)comboBox_type.SelectedItem;
if (selectedSheet == null)
{
return;
}
if (selectedSheet.StartsWith("'") && selectedSheet.EndsWith("'"))
{
selectedSheet = selectedSheet.Replace("'", "");
selectedSheet = "'" + selectedSheet + "$'";
}
else
{
selectedSheet += "$";
}
dta = whole_excel.Tables[selectedSheet];
int whole_Datarows = dta.Rows.Count;
Thread t2 = new Thread(delegate()
{
switch (selectedType)
{
case "Show All":
// dta = whole_excel.Tables[selectedSheet];
break;
case "Random 500":
dta = random(dta, 500);
break;
case "Random 1000":
dta = random(dta, 1000);
break;
case "Remaining True Positives":
dta = excludes(dta);
break;
}
this.Invoke((MethodInvoker) delegate
{
dataGridView1.Visible = true;
dataGridView1.DataSource = dta;
loadingBar.Visible = false;
loadingBar.Refresh();
sheet_and_type.Text = "Showing: " + selectedType + ", from sheet: " + selectedSheet.Replace("$", "") + ", Total: " + dta.Rows.Count + "/" + whole_Datarows;
sheet_and_type.Visible = true;
sheet_and_type.Refresh();
FlashWindow.Flash(this);
});
});
t2.Start();
}
