实验数据处理的时候遇到一个问题,需要将程序日志中的数据转化到Excel中进行处理,原始数据是每行数据中用“,”分隔的多个数据信息,一共有多个行,如图所示。
![](https://img-blog.csdnimg.cn/dec3c5c2c87142da8a9104c6257f965d.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBASUw5Nw==,size_16,color_FFFFFF,t_70,g_se,x_16)
网上找到的C#实现的代码,需要自己加一些引用
string path = "c://date//xyu.txt";
StreamReader sr = new StreamReader(path);
string strLine = sr.ReadLine();
int rowNum = 1;
object missing = System.Reflection.Missing.Value;
ApplicationClass app = new ApplicationClass();
app.Application.Workbooks.Add(true);
Workbook book = (Workbook)app.ActiveWorkbook;
Worksheet sheet = (Worksheet)book.ActiveSheet;
while (!string.IsNullOrEmpty(strLine))
{
string[] tempArr;
tempArr = strLine.Split(',');
for (int k = 1; k |