C# 逐行读取 CSV 文件
using Microsoft.Office.Interop.Excel;
using Microsoft.VisualBasic.FileIO;
public List<string> ReadFromCsv()
{
var partList = new List<string>();
using (TextFieldParser parser = new TextFieldParser(@"D:/List.csv"))
{
parser.TextFieldType = FieldType.Delimited;
parser.SetDelimiters(",");
while (!parser.EndOfData)
{
string[] fileds = parser.ReadFields();
foreach (var filed in fileds)
{
partList.Add(filed);
}
}
}
return partList;
}