c#(WinForms-App)将DataSet导出到Excel

Install-Package EPPlus

using OfficeOpenXml;
using System;
using System.Data;
using System.IO;

namespace ExportDataSetToExcel
{
    class Program
    {
        static void Main(string[] args)
        {
            DataSet ds = GetDataSet(); // 获取数据集
            ExportToExcel(ds, "output.xlsx"); // 导出到Excel文件
        }

        static DataSet GetDataSet()
        {
            DataSet ds = new DataSet("ExampleDataSet");
            DataTable dt = new DataTable("ExampleDataTable");

            dt.Columns.Add("Column1", typeof(string));
            dt.Columns.Add("Column2", typeof(int));
            dt.Columns.Add("Column3", typeof(double));

            dt.Rows.Add("Row1", 1, 1.1);
            dt.Rows.Add("Row2", 2, 2.2);
            dt.Rows.Add("Row3", 3, 3.3);

            ds.Tables.Add(dt);

            return ds;
        }

        static void ExportToExcel(DataSet ds, string outputFile)
        {
            using (ExcelPackage package = new ExcelPackage(new FileInfo(outputFile)))
            {
                foreach (DataTable dt in ds.Tables)
                {
                    ExcelWorksheet worksheet = package.Workbook.Worksheets.Add(dt.TableName);
                    worksheet.Cells["A1"].LoadFromDataTable(dt, true);
                }

                package.Save();
            }
        }
    }
}