只需在'|'字符上使用spliter并使用该数组以excel简单方式填充单元格

@ 使用C＃向Excel写入数据

Just use spliter on '|' character and use that array to fill cell in excel simple way as done
@Write Data to Excel using C#