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