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