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ı");
}
}