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