.NET6怎么导出EXCEL
时间: 2023-10-26 22:05:12 浏览: 39
在.NET6中,可以使用以下步骤导出Excel:
1. 安装NuGet包:Microsoft.Office.Interop.Excel。这个包提供了操作Excel的接口。
2. 添加以下命名空间:using Microsoft.Office.Interop.Excel;
3. 创建Excel应用程序对象:Application excel = new Application();
4. 创建一个新的工作簿:Workbook workbook = excel.Workbooks.Add(Type.Missing);
5. 获取工作表:Worksheet worksheet = (Worksheet)workbook.ActiveSheet;
6. 循环遍历数据,将数据写入工作表中:for (int i = 0; i < data.Rows.Count; i++) { for (int j = 0; j < data.Columns.Count; j++) { worksheet.Cells[i + 1, j + 1] = data.Rows[i][j].ToString(); } }
7. 保存工作簿:workbook.SaveAs("export.xlsx");
8. 关闭Excel应用程序:excel.Quit();
完整代码示例:
using Microsoft.Office.Interop.Excel;
public void ExportToExcel(DataTable data)
{
Application excel = new Application();
Workbook workbook = excel.Workbooks.Add(Type.Missing);
Worksheet worksheet = (Worksheet)workbook.ActiveSheet;
for (int i = 0; i < data.Rows.Count; i++)
{
for (int j = 0; j < data.Columns.Count; j++)
{
worksheet.Cells[i + 1, j + 1] = data.Rows[i][j].ToString();
}
}
workbook.SaveAs("export.xlsx");
excel.Quit();
}