如何读取文本文件中的每行以“，”分割的数据，并逐行读取？？？

Question

数据文件 text.tx1O_STC,X2-4-17,0,0,0.400000,0.000000,X2-2-DW18,0,0,0.300000,0.000000,1243.293213,0,D
O_STC,X2-4-17,0,0,0.400000,0.000000,X2-2-DW19,0,1,0.400000,0.000000,1334.719482,0,D
O_STC,X2-4-17,0,0,0.400000,0.000000,X2-3-16,0,0,0.200000,0.000000,510.004913,0,D
O_STC,X2-4-17,0,0,0.400000,0.000000,X2-3-17,0,0,0.400000,0.000000,540.800354,0,D
.....
如何读取文本文件中的每行以“，”分割的数据，并逐行读取？？？

Answer 1

给你个读一行的例子 private void button1_Click(object sender, System.EventArgs e)
{
System.IO.StreamReader sr=new System.IO.StreamReader(@"d:\text.txt",System.Text.Encoding.Default);
string txt = string.Empty;
txt = sr.ReadLine();
sr.Close();
string[] array =txt.Split(',');
string s = string.Empty;
for(int i=0;i<array.Length;i++)
{
s += array[i] + "\r\n";
}
MessageBox.Show(s);

}

Answer 2

//逐行读取的例子 private void button1_Click(object sender, System.EventArgs e)
{
System.IO.StreamReader sr=new System.IO.StreamReader(@"d:\text.txt",System.Text.Encoding.Default);
string txt = string.Empty;
while (sr.Peek() > 0)
{
txt = sr.ReadLine();
string[] array =txt.Split(',');
string s = string.Empty;
for(int i=0;i<array.Length;i++)
{
s += array[i] + "\r\n";
}
MessageBox.Show(s);
}
sr.Close();
}

Answer 3

就是一个.csv文件,用ole就可以读的

Answer 4

string[] array =txt.Split(',');是正解.或者用EXCEL的接口,EXCEL的CSV就是这种格式的,太WS了..