Convert txt to xlsx

[Vijay_Kumar_C]

Hi @syaheed22

please find attached code which will convert text file data into excel headers.

Steps Included

1. Read data from text file.
2. Split data by using split function delimiter as Environment.Newline which will return array.
3. Assign New Datatable() to the Datatable.
4. Use for each loop with add data column activity to add data to datatable as column.
5. add a single datarow to datatable.
6. Write range into excel file with Add headers option check.

TextToExcel.zip (16.3 KB)

Regards,
Vijay Kumar C.