Convert txt to xlsx

Help
1

this example, i need to convert this example text to excel by row by column. i hope u undertand based on my attachment given.

123
1231280×1024 38.8 KB

456
4561280×1024 23.8 KB

output:

789
7891280×1024 43.1 KB

2

Hi @syaheed22,

Read that text file,check the data how it is coming
then proceed to convert

3

Use read csv activity and get the rows in the csv as datatable , then transpose the datatable and store it in another data table keep appending your main data table with all csv files and at the end use write range and set add headers …

1 Like
4

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.

4 Likes
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.