C#导出EXCEL数据

using System.IO;
using System.Data;
using System.Drawing;
using System.Windows;
using OfficeOpenXml;
namespace mySiC_Framework{
    public partial class NewPage5 : Page
    {
        public NewPage5()
        {
            InitializeComponent();
        }
        private void ExportButton_Click(object sender, RoutedEventArgs e)
        {
            DataTable dataTable = new DataTable("MyData");
            dataTable.Columns.Add("Name", typeof(string));
            dataTable.Columns.Add("Age", typeof(int));
            dataTable.Rows.Add("John Doe", 30);
            dataTable.Rows.Add("Jane Smith", 25);
            ExcelPackage.LicenseContext = LicenseContext.NonCommercial;//许可声明
            using (ExcelPackage excelPackage = new ExcelPackage())
            {
                ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("MySheet");
                int row = 1;
                worksheet.Cells[row, 1].Value = "Name";
                worksheet.Cells[row, 2].Value = "Age";
                row++;
                foreach (DataRow dataRow in dataTable.Rows)
                {
                    worksheet.Cells[row, 1].Value = dataRow["Name"].ToString();
                    worksheet.Cells[row, 2].Value = Convert.ToInt32(dataRow["Age"]);
                    row++;
                }
                string fileName = @"D:\MyExcelFile.xlsx";
                FileInfo fileInfo = new FileInfo(fileName);
                excelPackage.SaveAs(fileInfo);
                System.Windows.Forms.MessageBox.Show("导出成功！");
            } 
        }
    }
}

记得NuGet安装EPPLUS包