Unable to paste list in Excel properly

Hi!
My Invoice numbers are read in List variable. I need to paste the list in excel. It is coming in one cell instead of Column. Everything else (Eg : Invoice Date) is working correctly. Below is the images from Execution file , Output File and coding. Please let me know where things are wrong .

image

image

image

Check what separator you have in the Clipboard action in 370. Perhaps, you need to change it to Linux / Mac OS separator.

Hi ! I tried to separate it with comma , but the results are going other way. please see below

image

image

@sbhambri try using Linux / Mac OS line break as a separator. It is used to separate rows in Excel, so the values should be pasted as a column.

Thanks ! its working well

1 Like