Convert text file to Excel

[Akshay07 (Akshay Suryawanshi)]

Hello @IndraVijay,

You can refer to this post for the solution

Convert txt to xlsx

Hi @syaheed22 please find attached code which will convert text file data into excel headers. Steps Included Read data from text file. Split data by using split function delimiter as Environment.Newline which will return array. Assign New Datatable() to the Datatable. Use for each loop with add data column activity to add data to datatable as column. add a single datarow to datatable. Write range into excel file with Add headers option check. TextToExcel.zip (16.3 KB) Regards, Vijay Kumar…