Comment exporter un DataTable vers Excel
Comment exporter un DataTable vers Excel
Comment exporter un objet DataTable C# vers un fichier Excel ?
Re: Comment exporter un DataTable vers Excel
**Avec EPPlus :**
```csharp
using (var package = new ExcelPackage())
{
var ws = package.Workbook.Worksheets.Add("Données");
ws.Cells["A1"].LoadFromDataTable(dataTable, true);
package.SaveAs(new FileInfo("export.xlsx"));
}
```
**Avec ClosedXML :**
```csharp
using (var workbook = new XLWorkbook())
{
workbook.Worksheets.Add(dataTable, "Données");
workbook.SaveAs("export.xlsx");
}
```
```csharp
using (var package = new ExcelPackage())
{
var ws = package.Workbook.Worksheets.Add("Données");
ws.Cells["A1"].LoadFromDataTable(dataTable, true);
package.SaveAs(new FileInfo("export.xlsx"));
}
```
**Avec ClosedXML :**
```csharp
using (var workbook = new XLWorkbook())
{
workbook.Worksheets.Add(dataTable, "Données");
workbook.SaveAs("export.xlsx");
}
```