First automation Problem

[mohamed.saty2012 (Mohamed Saty)]

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)

[Yoichi]

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,

[mohamed.saty2012 (Mohamed Saty)]

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.

[lrtetala (Lakshman Reddy)]

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!!

[Yoichi]

Hi,

Just overwrite the file as the following.

Or we can use WriteCellWorkbook as the following.

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

MainV3.xaml (28.7 KB)

Regards,

[mohamed.saty2012 (Mohamed Saty)]

thanks, i appreciate your help.

[mohamed.saty2012 (Mohamed Saty)]

thanks to your help appreciate it