Reg : RPA UiPath / Excel Activity /Lookup Function

I am having

1 Master XL Sheet

4 child XL sheet

Each Sheet Having 2 headers *SerialNumber(Column A) and *Status (Column C)

Target is:

At a time Need to update the master sheet based on the SerialNumber from 4 child Sheet *Status.

Current Status is :
After the studio Design , if I ran a single single Child Sheet na it’s updating perfectly.

But

When I am using the whole child Sheet to update in master sheet it’s only printing the SINGLE child Sheet *Status.

What it’s doing na, it’s is removing the *status Of initially ran child Sheet Status…

Design for single Child sheet,

1 Read Range for Master sheet ,

2 Read Range for Child Sheet,

3 For Each Row,

3.1 lookup Function

3.2 write Cell Activity.

Given Condition is

–>> “C”+(DT1.Rows.indexof(row)+2).ToString <<–

Design for Whole Child sheet is Repeating the same design one by one in sequence…

Finally it’s show’s single Child sheet status only…

It’s updating a single Child Sheet only.

Please suggest me what I need to do to resolve this issue…

Hi @SIVANITHRAN_K_R welcome to forum

I think you are not looping through all sheets

HI @NIVED_NAMBIAR,

Thanks for your response. Can you please guide me, from where i need to create looping for that whole sheet.

i am beginner for UiPath.

Hi @SIVANITHRAN_K_R

Is the child sheet are different workbook or in sheets in same workbooks

Different worksheet
(Microsoft Excel Worksheet (.xlsx))
image

Hi @SIVANITHRAN_K_R

Then there is small changes to made here

Try to put the child workbooks in one folder

Then at beginning of Workflow , use Assign activitiy

File_list= Directory.GetFiles(folderpath)

File_list stores the path of all files in folder which contains child worksheet

Now loop through all filepath in the File_list using for each loop with argument type in property panel as string (for each file in File_list)

Put the workflow whatever u had done in that loop
But in read range of child workbooks specify the path as file ( since we are iterating through each file in File_list)

Hope it helps you

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed:

Hi @NIVED_NAMBIAR,

Thanks for you suggestions, Will check and update to soon .

Regards,
Sivanithan K R

1 Like

HI NIVED,
Good Morning,

After changing the design also facing the same issue.

what my understanding is, While performing the write activity its erasing the old data presents on that particular write “cell”.

Here I attached my design flow OLD and New in flowchart with worksheets .

i think need some changes in write condition, But I am not clear in that.
–>> “C”+(DT1.Rows.indexof(row)+2).ToString <<–

Requesting you to please refer my design and guide me.

Testing Project Doc.zip (43.9 KB)

Regards,
Sivanithran K R

@SIVANITHRAN_K_R

You are absolutely correct. To avoid this issue use a read cell activity and check with if condition i.e if the cell value is NullorWhiteSpace then only use write cell activity.
FYR…
image

It works fine now:

image

Hope this solves your issue…!
Cheers!!

2 Likes

Hi @ManiPrajwal_K

Sorry for the delayed response.

Thanks for your suggestions. Will check and update you ASAP.

Regards,
SIVANITHRAN K R

No worries mate… If you find it a solution to your issue mark the same and close this thread.!
Cheers!!

HI @ManiPrajwal_K and @NIVED_NAMBIAR,

My issue resolved now. thanks for your response and support. :slight_smile:

Regards,
SIVANITHRAN K R

2 Likes

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