How to put structured data from notepad to excel

[suraj23 (Suraj)]

Please suggest the proper solution for it. Attach the source file if u get the way.

VoiceDetails.xlsx (8.6 KB)

VoiceDetails text file.zip (349 Bytes)

[Manjuts90]

@suraj23 can u attach text file?

[indra]

@suraj23 Check below link

How to pass data from Notepad to Excel

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

[suraj23 (Suraj)]

VoiceDetails text file.zip (349 Bytes)

[Manjuts90]

@suraj23notepadToExcel.xaml (20.3 KB)
please find the attached file above