this example, i need to convert this example text to excel by row by column. i hope u undertand based on my attachment given.
output:
this example, i need to convert this example text to excel by row by column. i hope u undertand based on my attachment given.
output:
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 …
Hi @syaheed22
please find attached code which will convert text file data into excel headers.
Steps Included
TextToExcel.zip (16.3 KB)
Regards,
Vijay Kumar C.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.