/// <summary>
/// Сохранение в файл
/// </summary>
private void сохранитьToolStripMenuItem_Click(object sender, EventArgs e)
{
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
string path = saveFileDialog1.FileName;
var aa = new ClosedXML.Excel.XLWorkbook();
var ws = aa.AddWorksheet(ToDataTable(dataGridView1), "name");
ws.Tables.First().ShowAutoFilter = false;
ws.Tables.First().Theme = XLTableTheme.None;
ws.Style = XLWorkbook.DefaultStyle;
aa.SaveAs(path);
MessageBox.Show("Файл сохранен.");
}
}
private static void ExportDataSet(DataSet ds)
{
var workbook = new ClosedXML.Excel.XLWorkbook();
foreach (DataTable dt in ds.Tables)
{
var worksheet = workbook.Worksheets.Add(dt.TableName);
worksheet.Cell(1, 1).InsertTable(dt);
worksheet.Columns().AdjustToContents();
}
SaveFileDialog sFD = new SaveFileDialog();
sFD.Filter = "Excel file (.xlsx)|*.xlsx";
if (sFD.ShowDialog() == true)
{
workbook.SaveAs(sFD.FileName);
workbook.Dispose();
}
}
private static void ExportDataSet(DataSet ds)
{
var workbook = new ClosedXML.Excel.XLWorkbook();
foreach (DataTable dt in ds.Tables)
{
var worksheet = workbook.Worksheets.Add(dt.TableName);
worksheet.Cell(1, 1).InsertTable(dt);
worksheet.Columns().AdjustToContents();
}
SaveFileDialog sFD = new SaveFileDialog();
sFD.Filter = "Excel file (.xlsx)|*.xlsx";
if (sFD.ShowDialog() == true)
{
workbook.SaveAs(sFD.FileName);
workbook.Dispose();
}
}