SAVE THE DATAGRIDVIEW CONTENTS AS EXCEL

[FreeVB]

At present, only DbDataReader can be saved as excel, but not datatable or datagridview?

[FreeVB]

I found a solution: first convert datagridview to datatable, then new DataTableReader(dataTable)

private void button2_Click(object sender, EventArgs e)
{
    string filePath = @"file.xlsx";
    using ExcelDataWriter edw = ExcelDataWriter.Create(filePath);
    edw.Write(DataGridView2DbDataReader(dataGridView1));
}

static DbDataReader DataGridView2DbDataReader(DataGridView Dgv)
{
    DataTable dt = new();
    foreach (DataGridViewColumn column in Dgv.Columns)
    {
        dt.Columns.Add(column.HeaderText, column.ValueType);
    }
    foreach (DataGridViewRow row in Dgv.Rows)
    {
        DataRow dr = dt.NewRow();
        foreach (DataGridViewCell cell in row.Cells)
        {
            dr[cell.ColumnIndex] = cell.Value;
        }
        dt.Rows.Add(dr);
    }
    return new DataTableReader(dt);
}