private void ExportCSV(DataGridView dgv) { string filename = EssentialMethods.SaveFileDialogResult(EssentialMethods.Filters.CSV); if (filename != null && dgv != null) { //Save File.WriteAllText(filename, DatagridViewToCSV(dgv)); } }
private void ExportExcel(DataGridView dgv) { string file_name = EssentialMethods.SaveFileDialogResult(EssentialMethods.Filters.Excelfiles); if (file_name != null && dgv != null) { using (ExcelPackage package = new ExcelPackage(new FileInfo(file_name))) { ExcelWorksheet worksheet = package.Workbook.Worksheets.Add(Path.GetFileNameWithoutExtension(file_name)); worksheet.Cells["A1"].LoadFromText(DatagridViewToCSV(dgv), new ExcelTextFormat() { Delimiter = ',', EOL = "\r\n" }, OfficeOpenXml.Table.TableStyles.Medium27, true); package.Save(); } } }