泛型数据输入到Excel

xiaohong055 2009-03-01 03:19:49

For M5|Adr 00001|TO TAAN.DAT | | | |
For M5|Adr 00002|TO Start-Line aBFFB 16C| | | |
For M5|Adr 00003|KD1 S16 ABC 16C| m | m |Z 0.00000 m |
For M5|Adr 00004|KD1 S16 ABC 07:29:253 16C|Rb 1.49572 m |HD 9.558 m | |
For M5|Adr 00005|KD1 1 ABC 07:29:403 16C|Rf 1.42822 m |HD 9.666 m | |
For M5|Adr 00006|KD1 1 ABC 07:29:503 16C|Rf 1.42821 m |HD 9.666 m | |
For M5|Adr 00007|KD1 S16 ABC 07:30:023 16C|Rb 1.49570 m |HD 9.558 m | |
For M5|Adr 00008|KD1 1 ABC 07:30:02 16C| m | m |Z 0.06749 m |
For M5|Adr 00009|KD1 2 ABC 07:31:123 16C|Rf 0.39995 m |HD 9.584 m | |
For M5|Adr 00010|KD1 1 ABC 07:31:243 16C|Rb 1.53151 m |HD 10.085 m | |
For M5|Adr 00011|KD1 1 ABC 07:31:333 16C|Rb 1.53138 m |HD 10.085 m | |
For M5|Adr 00012|KD1 2 ABC 07:31:533 16C|Rf 0.40001 m |HD 9.584 m | |
For M5|Adr 00013|KD1 2 ABC 07:31:53 16C| m | m |Z 1.19896 m |
For M5|Adr 00014|KD1 P16 ABC 16C|Sh 1.19896 m |dz -1.19896 m |Z 0.00000 m |
For M5|Adr 00015|KD1 P16 ABC 2 16C|Db 19.640 m |Df 19.250 m |Z 1.19896 m |
For M5|Adr 00016|TO End-Line 16C|

static void Main(string[] args)
{
FileStream aFile = new FileStream("F://dini.txt", FileMode.Open);
StreamReader sr = new StreamReader(aFile);
char[] charArray = { '|' };
char[] charar = { ' ' };
List<List<string>> Lstlist = new List<List<string>>();
List<string> lst = new List<string>();
string strline = sr.ReadLine();//读取文件第一行，并创建一个字符串数组
while (strline != null)
{

lst.Clear();
string[] strArray = strline.Split(charArray);//只包含|的数组
for (int i = 0; i < strArray.Length; i++)
{
string[] strA = strArray[i].Split(charar);
for (int j = 0; j < strA.Length; j++)
{
if (strA[j] != "")
{
lst.Add(strA[j].ToString());
}

}
}
Lstlist.Add(lst);
strline = sr.ReadLine();
}

sr.Close();

输到EXCEL中

...全文