Can anyone help me cope with this problem

[Happydayyy (22035153d)]

I am using this method:

but now the issue is:

My expected result is:

Besides, the robot sometimes work but sometimes can’t:
It may happen the following problem:

can anyone help me to cope with these two problems and revise the robot?
Thx!!

Robot:
FA Sorting +writecell 24.2.23 (finanl).xaml (41.4 KB)
excel
template 23.2.24 (FA).xlsx (29.1 KB)

[mkankatala (Mahesh Kankatala)]

Hi @Happydayyy

Follow the below workflow steps,
→ Use the Excel Process scope activity and insert the Use excel file activity inside of it and pass the File path.
→ Inside Use excel file activity, insert the Find First\Last row activity to find the last row number of the sheet of Column Item.
→ In the Source field give the Excel.Sheet(“FA controlC__ (robot)”) and check the headers, select the Last Populated row option in Configure Last row field and Create a variable in the Save last row number as field called LastRow.
→ After Find First\Last row activity, use the Copy\Paste range activity.
→ In the Source field give Excel.Sheet(“FA controlC__ (robot)”).Range(“B3:H”+LastRow.ToString)
and in the Destination field give Excel.Sheet(“FA controlC__ (robot)”).Range(“B2:H”+(LastRow-1).ToString)
and select the Values option from what to copy dropdown.
→ After Copy\Paste range activity insert the delete rows activity to delete the last row which is not useful.
→ In Range give Excel.Sheet(“FA controlC__ (robot)”) and Select the Specific rows option in the What to delete dropdown and pass the LastRow variable in the At position field.

Check the below workflow for better understanding,
Regex_Practice.xaml (18.4 KB)

Input -

Output -

Hope it helps!!

[Happydayyy (22035153d)]

But my robot sometimes occur this problem so that the robot cannot work

Can you also help me to check on the workflow and revise it?

Robot
FA Sorting +writecell 24.2.23 (finanl).xaml (41.4 KB)
Excel
template 23.2.24 (FA).xlsx (29.1 KB)

[ashokkarale]

@Happydayyy ,

Please find the revised solution.

FASorting.zip (41.1 KB)

Thanks,
Ashok

[Happydayyy (22035153d)]

Thank you so much, I am trying to add something based on my task, if I encounter some problem later, can you help me as well? HAHAHAHA…
Many thankssss!!

[ashokkarale]

Definitely I will try my best. Good luck.

Thanks,
Ashok