如何将数据表导出到 Excel [英] How to export DataTable to Excel

问题描述

如何在 C# 中将 DataTable 导出到 Excel?我正在使用 Windows 窗体.DataTable 与 DataGridView 控件相关联.我必须将 DataTable 的记录导出到 Excel.

How can I export a DataTable to Excel in C#? I am using Windows Forms. The DataTable is associated with a DataGridView control. I have to export records of DataTable to Excel.

推荐答案

我推荐 ClosedXML -

您可以使用一些非常易读的代码将数据表转换为 Excel 工作表:

You can turn a DataTable into an Excel worksheet with some very readable code:

XLWorkbook wb = new XLWorkbook();
DataTable dt = GetDataTableOrWhatever();
wb.Worksheets.Add(dt,"WorksheetName");

开发人员响应迅速且乐于助人.该项目正在积极开发中，文档非常棒.

The developer is responsive and helpful. The project is actively developed, and the documentation is superb.

这篇关于如何将数据表导出到 Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！