Separate Excel column by comma and write to another file/tab

Image 1:

Image 2:

So I have to separate the address in the Addresses column from Image 1 where all the IP addresses are kept in a comma delimited cell into the output of Image 2. How do I do this?

Would really appreciate your help!

Thanks in advance!

Hi @abdul.aziz1

Please find the pseudo code below and implement according to in UIPath.
Please let me know if you need anything, note that delimitter to split string address is comma

1 Like

Hello! Thank you for your invaluable help! It kinda worked but for some reason, at certain points while running the program, I got the error message that “Write Cell: The range doesn’t exist”. But if I ignored it and continued on, then the program ran fine for some time after which the same error message popped up and if I ignored it, then it continued on. This happened 9 times during the runtime. What could be the issue do you think?

added in my workflow for your reference!

What are you assigning to ipaddressarray?

Also let me know cell value you are passing

the column where all the data is kept, separated by comma

ipAddressArray = row.Item(“Addresses”).ToString.Split(","c)

the cell values looks like this


I asked cell value of write cell activity

Oh sorry. It’s “A” + counter.ToString

share the excel and xaml @abdul.aziz1

Main.xaml (49.5 KB) Microsoft IPs.xlsx (19.7 KB)

here you go

Hello! Could you figure out what seems to be the problem? I can’t find it no matter how much I try. :frowning_face: