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