就像这样简单：

string[][] results =
    File
        .ReadAllLines(csvFilePath)
        .Select(x => x.ParseCsvLine())
        .Select(x => x.Where(y => !String.IsNullOrEmpty(y)).ToArray())
        .ToArray();

ParseCsvLine将string从CSV转换为stringp[]。

看起来你把dynamic数据类型当作IDictionary数据类型。数据的类型转换将解决您的问题。

// Iterate through headers and check if any row in the column has data
foreach (var header in headers)
{
    if (records.Skip(1).Any(record => !string.IsNullOrWhiteSpace(((IDictionary<string, object>)record)[header]?.ToString())))
    {
        headersWithData.Add(header);
    }
}

你的想法是对的循环遍历记录，然后将dynamic记录转换为IDictionary<string, object>。使用LINQ查找列值不是string.IsNullOrWhiteSpace的项，然后选择Key，即列标题。使用string.Join连接返回的IEnumerable<string>头名称，这些头名称包含该行的数据。

using (var reader = new StringReader("Column A,Column B,Column C,Column D\nabc,,bcd,\nedf,sdg,,rzh"))
using (var csv = new CsvReader(reader, new CsvConfiguration(CultureInfo.InvariantCulture)))
{
    // Read the CSV records into a dynamic list
    var records = csv.GetRecords<dynamic>().ToList();

    // Create a list to store headers with data
    var headersWithData = new List<string>();

    // Iterate through each record and check if a column has data   
    foreach (var record in records)
    {
        var rowHeaders = ((IDictionary<string, object>)record)
            .Where(item => !string.IsNullOrWhiteSpace(item.Value?.ToString()))
            .Select(item => item.Key);
            
        headersWithData.Add(string.Join(",", rowHeaders));      
    }
    
    // Print the filtered column headers with data
    Console.WriteLine("Column Headers with Data:");
    foreach (var header in headersWithData)
    {
        Console.WriteLine(header);
    }
}