在Blazor .NET Core 3.1中使用Infragistics.WPF.Excel

using Infragistics.WPF.Excel;
using System.IO;

public class ExcelHelper
{
    public static void ExportToExcel(string filePath, DataTable dataTable)
    {
        using (var excelEngine = new ExcelEngine())
        {
            var application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;

            var workbook = application.Workbooks.Create();
            var worksheet = workbook.Worksheets[0];

            for (int i = 0; i < dataTable.Columns.Count; i++)
            {
                worksheet.Cells[0, i].Value = dataTable.Columns[i].ColumnName;
            }

            for (int i = 0; i < dataTable.Rows.Count; i++)
            {
                for (int j = 0; j < dataTable.Columns.Count; j++)
                {
                    worksheet.Cells[i + 1, j].Value = dataTable.Rows[i][j];
                }
            }

            workbook.SaveAs(filePath);
        }
    }
}

@inject ExcelHelper ExcelHelper

<button @onclick="Export">Export to Excel</button>

@code {
    private void Export()
    {
        DataTable dataTable = new DataTable();
        dataTable.Columns.Add("Column1");
        dataTable.Columns.Add("Column2");
        dataTable.Rows.Add("Value1", "Value2");

        string filePath = "data.xlsx";
        ExcelHelper.ExportToExcel(filePath, dataTable);
    }
}