// General Approach
protected void Button_Click(object sender, EventArgs e)
{
var options = new CsvExportOptionsEx();
options.EncodeExecutableContent = DefaultBoolean.True;
ASPxGridView1.ExportCsvToResponse(options);
}
/// <summary>
/// 利用畫面上隱藏的grid,直接匯出CSV
/// </summary>
/// <param name="dtTarget"></param>
protected void ExportCsv(DataTable dtTarget, string filename)
{
//2.設定gvExport
gvExport.Columns.Clear();
gvExport.OptionsBehavior.AutoPopulateColumns = true;
gcExport.DataSource = dtTarget;
gvExport.BestFitColumns();
//3.export to csv (use GridControl)
CsvExportOptionsEx options = new CsvExportOptionsEx();//ken,如果有需要細部設定csv屬性可以用這個
//ken,數字格式不管的話,輸出時會自動加上千分位逗號,TextExportMode=Text會直接輸出
options.ExportType = DevExpress.Export.ExportType.WYSIWYG;
options.TextExportMode = TextExportMode.Text;
//ken,pb的時間輸出格式為 mm/dd/yy hh24:mi:ss ,直接在sql語法調整比較快
gcExport.ExportToCsv(filename, options);
#if DEBUG
if (FlagAdmin)
{
System.Diagnostics.Process.Start(filename);
}
#endif
}
private void ExportCSV(object sender, ItemClickEventArgs e) {
SaveFileDialog dialog = new SaveFileDialog {
Filter = @"CSV Files (*.csv)|*.csv",
RestoreDirectory = true
};
if (dialog.ShowDialog() == DialogResult.OK) {
CsvExportOptionsEx advOptions = new CsvExportOptionsEx {
ExportType = DevExpress.Export.ExportType.WYSIWYG,
TextExportMode = TextExportMode.Value
};
try {
gridControl1.ExportToCsv(dialog.FileName, advOptions);
Output.Current.Add($"Export to CSV: {dialog.FileName}");
}
catch (Exception ex) {
Output.Current.Add("Export to CSV failed", ex.Message);
XtraMessageBox.Show(ex.Message.Replace(". ", "." + Environment.NewLine), ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public static void TabloDisariAktar(this GridView tablo, DosyaTuru dosyaTuru, string dosyaFormati, string excelSayfaAdi = null)
{
if (Messages.TabloExportMessage(dosyaFormati) != DialogResult.Yes)
{
return;
}
if (!Directory.Exists(Application.StartupPath + @"\Temp"))
{
Directory.CreateDirectory(Application.StartupPath + @"\Temp");
}
var dosyaAdi = Guid.NewGuid().ToString();
var filePath = $@"{Application.StartupPath}\Temp\{dosyaAdi}";
switch (dosyaTuru)
{
case DosyaTuru.ExcelStandart:
{
var opt = new XlsxExportOptionsEx
{
ExportType = ExportType.Default,
SheetName = excelSayfaAdi,
TextExportMode = TextExportMode.Text,
};
filePath = filePath + ".Xlsx";
tablo.ExportToXlsx(filePath, opt);
}
break;
case DosyaTuru.ExcelFormatli:
{
var opt = new XlsxExportOptionsEx
{
ExportType = ExportType.WYSIWYG,
SheetName = excelSayfaAdi,
TextExportMode = TextExportMode.Text,
};
filePath = filePath + ".Xlsx";
tablo.ExportToXlsx(filePath, opt);
}
break;
case DosyaTuru.ExcelFormatsiz:
{
var opt = new CsvExportOptionsEx
{
ExportType = ExportType.WYSIWYG,
TextExportMode = TextExportMode.Text,
};
filePath = filePath + ".Csv";
tablo.ExportToCsv(filePath, opt);
}
break;
case DosyaTuru.WordDosyasi:
{
filePath = filePath + ".Rtf";
tablo.ExportToRtf(filePath);
}
break;
case DosyaTuru.PdfDosyasi:
{
filePath = filePath + ".Pdf";
tablo.ExportToPdf(filePath);
}
break;
case DosyaTuru.TxtDosyasi:
{
var opt = new TextExportOptions {
TextExportMode = TextExportMode.Text
};
filePath = filePath + ".Txt";
tablo.ExportToText(filePath, opt);
}
break;
}
if (!File.Exists(filePath))
{
Messages.HataMesaji("Tablo Verileri Dosyaya Aktarılamadı.");
return;
}
Process.Start(filePath);
}
public static void TableExport(this GridView table, FileType fileType, string fileFormat, string excelPageName = null)
{
if (Messages.TableExportMessage(fileFormat) != DialogResult.Yes)
{
return;
}
if (!Directory.Exists(Application.StartupPath + @"\Temp"))
{
Directory.CreateDirectory(Application.StartupPath + @"\Temp");
}
var fileName = Guid.NewGuid().ToString();
var filePath = $@"{Application.StartupPath}\Temp\{fileName}";
switch (fileType)
{
case FileType.ExcelStandart:
{
var opt = new XlsxExportOptionsEx
{
ExportType = DevExpress.Export.ExportType.Default,
SheetName = excelPageName,
TextExportMode = TextExportMode.Text
};
filePath = filePath + ".Xlsx";
table.ExportToXlsx(filePath, opt);
}
break;
case FileType.ExcelFormat:
{
var opt = new XlsxExportOptionsEx
{
ExportType = DevExpress.Export.ExportType.WYSIWYG,
SheetName = excelPageName,
TextExportMode = TextExportMode.Text
};
filePath = filePath + ".Xlsx";
table.ExportToXlsx(filePath, opt);
}
break;
case FileType.ExcelUnformatted:
{
var opt = new CsvExportOptionsEx
{
ExportType = DevExpress.Export.ExportType.WYSIWYG,
TextExportMode = TextExportMode.Text
};
filePath = filePath + ".Csv";
table.ExportToCsv(filePath, opt);
}
break;
case FileType.WordFile:
{
filePath = filePath + ".Rtf";
table.ExportToRtf(filePath);
}
break;
case FileType.PdfFile:
{
filePath = filePath + ".Pdf";
table.ExportToPdf(filePath);
}
break;
case FileType.TxtFile:
{
var opt = new TextExportOptions {
TextExportMode = TextExportMode.Text
};
filePath = filePath + ".Txt";
table.ExportToText(filePath, opt);
}
break;
}
if (!File.Exists(filePath))
{
Messages.ErrorMessage("File not found.");
return;
}
Process.Start(filePath);
}
