Magicodes.IE.Excel导入动态列

using Magicodes.IE.Excel;
using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Threading.Tasks;

class Program
{
    static async Task Main()
    {
        string filePath = "your_excel_file.xlsx";
        var importer = new ExcelImporter();
        var importResult = await importer.Import<dynamic>(filePath);

        if (importResult.HasError)
        {
            foreach (var error in importResult.Errors)
            {
                Console.WriteLine($"Row {error.RowIndex}: {error.ErrorMessage}");
            }
        }
        else
        {
            // 处理动态列数据
            foreach (var item in importResult.Data)
            {
                var dataRow = (DataRow)item;
                foreach (DataColumn column in dataRow.Table.Columns)
                {
                    var columnName = column.ColumnName;
                    var value = dataRow[columnName];
                    Console.WriteLine($"Column: {columnName}, Value: {value}");
                }
            }
        }
    }
}