/// <summary> /// Exporta la informaciĆ³n de un dataGridView a Excel de manera dinamica /// </summary> /// <param name="dataGridView">DataGridView de origen</param> /// <param name="pFullPath_toExport">Ruta del archivo exportado</param> /// <param name="nameSheet">Nombre de la hoja</param> public void dataGridView2ExcelDinamico(Xceed.Wpf.DataGrid.DataGridControl dataGridView, string pFullPath_toExport, string nameSheet) { System.Data.DataTable dt = new System.Data.DataTable(); ExcelExport myExcel = new ExcelExport(); myExcel.CreateWorksheet(nameSheet); //Recorro el DataGrid para buscar las columnas foreach (Xceed.Wpf.DataGrid.Column Column in dataGridView.Columns) { dt.Columns.Add(Column.Title.ToString()); } foreach (DataRow DataRow in dataGridView.Items) { DataRow dr = dt.NewRow(); foreach (Xceed.Wpf.DataGrid.Column Column in dataGridView.Columns) { dr[Column.Title.ToString()] = DataRow[Column.Title.ToString()]; } dt.Rows.Add(dr); } myExcel.PopulateFromDataTable(nameSheet, dt); myExcel.SaveToFile(pFullPath_toExport); //dataTable2ExcelDinamico(dt, dataGridView, pFullPath_toExport, nameSheet); }