WPF DataGrid to Excel

It is going to have to be a manual process. Sample of what I have done to export Excel:

private static void Excel(string fileName, List<IDirectoryInventoryDataCollector> list)
{
    try
    {
        var xlApp = new Excel.Application();
        var xlWorkBook = xlApp.Workbooks.Add();
        var xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
        ExcelTitleRow(list[0], 1, xlWorkSheet);

        int row = 2;
        foreach (var item in list)
        {
            ExcelFillRow(item, row++, xlWorkSheet);
        }

        for (int i = 1; i < list[0].MaxLevel - 1; i++)
        {
            ((Range)xlWorkSheet.Columns[i]).ColumnWidth = 2;
        }
        ((Range)xlWorkSheet.Columns[list[0].MaxLevel - 1]).ColumnWidth = 30;
        ((Range)xlWorkSheet.Rows[1]).WrapText = true;
        ((Range)xlWorkSheet.Rows[1]).HorizontalAlignment = HorizontalAlignment.Center;
        ((Range)xlWorkSheet.Cells[1, 1]).WrapText = false;

        xlWorkBook.SaveAs(fileName);
        xlWorkBook.Close();
        xlApp.Quit();
    }
    catch (AccessViolationException)
    {
        System.Windows.Forms.MessageBox.Show(
             "Have encountered access violation. This could be issue with Excel 2000 if that is only version installed on computer",
             "Access Violation");
    }
    catch (Exception)
    {
        System.Windows.Forms.MessageBox.Show("Unknown error",
             "Unknown error");
    }
}

private static void ExcelFillRow(IDirectoryInventoryDataCollector item, int row, Excel.Worksheet sheet)
{
    sheet.Cells[row, item.Level] = item.Name;
    int column = item.MaxLevel;
    foreach (var property in item.GetProperties())
    {
        sheet.Cells[row, column++] = property;
    }
}

private static void ExcelTitleRow(IDirectoryInventoryDataCollector item, int row, Excel.Worksheet sheet)
{
    sheet.Cells[row, 1] = "Name";
    int column = item.MaxLevel;
    foreach (var property in item.GetPropertyNames())
    {
        sheet.Cells[row, column++] = property;
    }
}

The namespace you need are

using Excel = Microsoft.Office.Interop.Excel;
using Microsoft.Office.Interop.Excel;

Check this code for WPF DataGrid to Excel

dataGrid is name of DataGrid.

DataGrid dg = dataGrid;
dg.SelectAllCells();
dg.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader;
ApplicationCommands.Copy.Execute(null, dg);
dg.UnselectAllCells();
String Clipboardresult =(string)Clipboard.GetData(DataFormats.CommaSeparatedValue);
StreamWriter swObj = new StreamWriter("exportToExcel.csv");
swObj.WriteLine(Clipboardresult);
swObj.Close();
Process.Start("exportToExcel.csv");

Above code not required any dll to create the excel file.

Hi, I write a extension method for WPF Datagrid Export to Excel(CSV):

if "MyDatagrid" is the name of your datagrid, use one line code to call on own user control.

MyDatagrid.ExportToExcel(this);

and add this method to your extension static class

#region DataGrid Extentions

public static void ExportToExcel(this DataGrid dg, UserControl owner, string filename = "")
        {
            try
            {
                dg.SelectionMode = DataGridSelectionMode.Extended;
                dg.SelectAllCells();

                Clipboard.Clear();
                ApplicationCommands.Copy.Execute(null, dg);

                var saveFileDialog = new SaveFileDialog
                {
                    FileName = filename != "" ? filename : "gpmfca-exportedDocument",
                    DefaultExt = ".csv", 
                    Filter = "Common Seprated Documents (.csv)|*.csv"
                };

                if (saveFileDialog.ShowDialog() == true)
                {
                    var clip2 = Clipboard.GetText();
                    File.WriteAllText(saveFileDialog.FileName, clip2.Replace('\t', ','), Encoding.UTF8);
                    Process.Start(saveFileDialog.FileName);
                }

                dg.UnselectAllCells();
                dg.SelectionMode = DataGridSelectionMode.Single;
            }
            catch (Exception ex)
            {
                owner.ShowMessageBox(ex.Message);
                Clipboard.Clear();
            }
        }
#endregion

finally don't forget to

using Microsoft.Win32;

in extension class
and set

ClipboardCopyMode="IncludeHeader"

for your datagrid.