NOTEPAD TO EXCEL

Help
, , , ,
1

How can do notepad to excel ,if the data :
image
i wont the data like that

image
image1366×738 48.3 KB

can help mee SAMPLE.TXT (1.2 KB)

1 Like
2

Hi
Did we try with READ TEXT FILE activity and getting the string variable as output which can be passed as input to GENERATE DATATABLE activity

Which in turn gives us datatable and write that to excel with write range activity

Cheers @den_bagus

3 Likes
3

i dont understand about this can you sample ,because i very2 beginner to this

4

1.open activties and search for “read text file” give the filepath of ur notepad
2.create a variable to stor ethe content of ur text file
3.search for generate data table activity in activities and give the created variable as input to this activity
4.it will give u a data table and now use the write range activity to write into a excel sheet

glad if u understand

1 Like
5

try it and post what errors u face