First automation Problem

At UiPath course they give an example for how to create unicorn name only for on user. i have managed to create a unicorn name for many names. but i need to take the unicorn names for those users and insert them to the same excel sheet in a new column.
Main.xaml (27.4 KB)
Unicorn Name.xlsx (8.8 KB)

Hi,

Can you try to add the following expression just after GeText activty?

CurrentRow("UnicornName") = uniName

Then Write the datatable to the file using WriteRange outside the loop.

MainV2.xaml (28.1 KB)

Regards,

1 Like

thanks this worked fine, but not the same way i wanted.
i want to take only the unicorn name and add it to the same excel file in the Unicorn name column.
this created a new excel file. is there a way to do it.
thanks in advance your support is highly appreciated. :heart:

Hi @mohamed.saty2012

If you want to write the data in the same excel and sheet then give the details as below

Hope this helps!!

1 Like

Hi,

Just overwrite the file as the following.

image

Or we can use WriteCellWorkbook as the following.

image

note: please set int32 type idx variable at Index property of ForEachRow activity

MainV3.xaml (28.7 KB)

Regards,

1 Like

thanks, i appreciate your help.

1 Like

thanks to your help appreciate it

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.