I need to convert text file into xlsx file. The text file contains strings seperated with commas. So based on comma as delimmiters, i need to enter the data into excel. Can anyone help me with any idea?
Check the below post -
I’ll suggest you to use Generate Data Table activity,
With formatting options.
first you can split based on new line and loop through each line and split them with Commas
then use for each loop and use add data row give item.ItemArray for arrayrow in property panel