How to pass data from Notepad to Excel

Help
, ,
2

GI hope you can translate this into activities

Create a datatable with 3 columns.

string readText = File.ReadAllLines(“yourfile.txt”);
foreach(item in readText)
{
If (item<> string.empty)
{
Splititem= Split.string(item,“|”)

add data row activity here and in Array row property add “Splititem” and datatable variable in datatable.

}

}

Writerange to excel here