御用小本本

示意

using System.Collections.Generic;
using System.Globalization;
using System.IO;
using System.Linq;
using System.Threading.Tasks;
using CsvHelper;
using CsvHelper.Configuration;
using CsvHelper.Configuration.Attributes;

namespace AbpToExcel.CsvImport;

public class ImportFromCsvAppService : AbpToExcelAppService
{
    public Task<List<string>> ImportFromCsv()
    {
        var readConfiguration = new CsvConfiguration(CultureInfo.InvariantCulture)
        {
            HasHeaderRecord = true
        };
        using (var reader = new StreamReader(@"D:\\Example.csv"))
        using (var csv = new CsvReader(reader, readConfiguration))
        {
            var records = csv.GetRecords<Employee>();
            return Task.FromResult(records.Select(x => x.Name).Take(10).ToList()) ;
        }
    }
}

public class Employee
{
    [Name("CsvName")]
    public string Name { get; set; }
}

參照

[C#][.NET Core] CsvHelper : 透過 C# 讀寫 csv 檔案 (dog0416.blogspot.com)