private void RunExportToCSV(string fileName, ref bool openExportFile) { ExportToCSV csvExporter = new ExportToCSV(this.radGridView1); csvExporter.CSVCellFormatting += csvExporter_CSVCellFormatting; //set export settings csvExporter.ExportHierarchy = true; csvExporter.HiddenColumnOption = HiddenOption.DoNotExport; try { this.Cursor = Cursors.WaitCursor; csvExporter.RunExport(fileName); RadMessageBox.SetThemeName(radGridView1.ThemeName); DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?", "Export to CSV", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (dr == DialogResult.Yes) { openExportFile = true; } } catch (IOException ex) { RadMessageBox.SetThemeName(this.radGridView1.ThemeName); RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error); } finally { this.Cursor = Cursors.Default; } }
private void RunExportToCSV(string fileName, ref bool openExportFile) { ExportToCSV csvExporter = new ExportToCSV(this.radGridView1); switch (this.radComboBoxSummaries.SelectedIndex) { case 0: csvExporter.SummariesExportOption = SummariesOption.ExportAll; break; case 1: csvExporter.SummariesExportOption = SummariesOption.ExportOnlyTop; break; case 2: csvExporter.SummariesExportOption = SummariesOption.ExportOnlyBottom; break; case 3: csvExporter.SummariesExportOption = SummariesOption.DoNotExport; break; } //set export settings csvExporter.ExportHierarchy = this.radCheckBoxExportHierarchy.IsChecked; csvExporter.HiddenColumnOption = HiddenOption.DoNotExport; try { this.Cursor = Cursors.WaitCursor; csvExporter.RunExport(fileName); RadMessageBox.SetThemeName(this.radGridView1.ThemeName); DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?", "Export to CSV", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (dr == DialogResult.Yes) { openExportFile = true; } } catch (IOException ex) { RadMessageBox.SetThemeName(this.radGridView1.ThemeName); RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error); } finally { this.Cursor = Cursors.Default; } }
public static void ExportGridCSV(RadGridView rv) { //sv.fi sv.Filter = "Spread Sheet files (*.csv)|*.csv|All files (*.csv)|*.csv"; sv.Title = "Save an CSV File"; sv.ShowDialog(); if (sv.FileName != "") { ExportToCSV exporter = new ExportToCSV(rv); exporter.FileExtension = "csv"; exporter.ColumnDelimiter = ","; exporter.HiddenColumnOption = HiddenOption.DoNotExport; exporter.HiddenRowOption = HiddenOption.DoNotExport; exporter.SummariesExportOption = SummariesOption.DoNotExport; exporter.RunExport(sv.FileName); MessageBox.Show("Export Completed"); } }
public static void RunExportToCSV(string fileName, RadGridView radGridView) { ExportToCSV csvExporter = new ExportToCSV(radGridView); csvExporter.CSVCellFormatting += csvExporter_CSVCellFormatting; csvExporter.SummariesExportOption = SummariesOption.ExportAll; //set export settings //csvExporter.ExportHierarchy = this.radCheckBoxExportHierarchy.IsChecked; csvExporter.HiddenColumnOption = HiddenOption.DoNotExport; try { //this.Cursor = Cursors.WaitCursor; csvExporter.RunExport(fileName); RadMessageBox.SetThemeName(radGridView.ThemeName); DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?", "Export to CSV", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (dr == DialogResult.Yes) { try { System.Diagnostics.Process.Start(fileName); } catch (Exception ex) { string message = String.Format("The file cannot be opened on your system.\nError message: {0}", ex.Message); RadMessageBox.Show(message, "Open File", MessageBoxButtons.OK, RadMessageIcon.Error); } } } catch (IOException ex) { RadMessageBox.SetThemeName(radGridView.ThemeName); //RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error); System.Windows.Forms.MessageBox.Show(ex.Message, "ERR", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { //this.Cursor = Cursors.Default; } }
private void ExportCSVClick(object sender, EventArgs e) { SaveFileDialog sfd = new SaveFileDialog(); sfd.Filter = String.Format("{0} (*{1})|*{1}", "CSV Files", ".csv"); if (sfd.ShowDialog() == DialogResult.OK) { ExportToCSV exporter = new ExportToCSV(this.radGridView1); exporter.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport; exporter.SummariesExportOption = SummariesOption.DoNotExport; exporter.CSVCellFormatting += new Telerik.WinControls.UI.Export.CSV.CSVCellFormattingEventHandler(exporter_CSVCellFormatting); exporter.CSVTableCreated += new Telerik.WinControls.UI.Export.CSV.CSVTableCreatedEventHandler(exporter_CSVTableCreated); exporter.RunExport(sfd.FileName); MessageBox.Show("Export completed"); } }
private void RunExportToCSV(string fileName, ref bool openExportFile) { ExportToCSV csvExporter = new ExportToCSV(this.radGridView1); switch (this.radComboBoxSummaries.SelectedIndex) { case 0: csvExporter.SummariesExportOption = SummariesOption.ExportAll; break; case 1: csvExporter.SummariesExportOption = SummariesOption.ExportOnlyTop; break; case 2: csvExporter.SummariesExportOption = SummariesOption.ExportOnlyBottom; break; case 3: csvExporter.SummariesExportOption = SummariesOption.DoNotExport; break; } try { csvExporter.RunExport(fileName); RadMessageBox.SetThemeName(this.radGridView1.ThemeName); DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?", "Export to CSV", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (dr == DialogResult.Yes) { openExportFile = true; } } catch (IOException ex) { RadMessageBox.SetThemeName(this.radGridView1.ThemeName); RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error); } }
private void btnExportCSV_Click(object sender, EventArgs e) { if (grdEvtxData.DataSource == null) { MessageBox.Show("Önce dosya seçip Import ediniz."); return; } var r = MessageBox.Show("Bu işlem çoook uzun sürmekte devam etmek istiyor musunuz? :)", "", MessageBoxButtons.OKCancel); if (r != DialogResult.OK) return; var exporter = new ExportToCSV(grdEvtxData) { HiddenColumnOption = HiddenOption.DoNotExport, SummariesExportOption = SummariesOption.DoNotExport }; var saveFileDialog = new SaveFileDialog(); var result = saveFileDialog.ShowDialog(); if (result == DialogResult.OK) { exporter.RunExport(saveFileDialog.FileName); MessageBox.Show("Excel aktarımı tamamlandı"); } }