it is expected that there has data in row 2, eg.
but now the issue is:
can anyone help me to revise it?
Thx!!
robot
FA Sorting +writecell 24.2.23 (finanl).xaml (32.8 KB)
excel
template 23.2.24 (FA).xlsx (26.8 KB)
1 Like
Hi,
I used Input data table:-
Output:-
Use below attached xaml file for your ref.
Delete Empty Cell_forum.zip (3.5 KB)
1 Like
if i need to use this method, how i can revise?
FA Sorting +writecell 24.2.23 (finanl).xaml (32.8 KB)
excel
template 23.2.24 (FA).xlsx (26.8 KB)
1 Like
can anyone help me check on my workflow
1 Like
Hi,
Sure I will do that. Allow me time till EOD.
Thanks
2 Likes
@Jayesh_678 Can you go to Can anyone help me cope with this problem , or reply here. Thanks you so much!!
1 Like
Hi @Happydayyy
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.
→ 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.
→ After Copy\Paste range activity insert the delete rows activity to delete the last row which is not useful.
→ 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!!
1 Like
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)
s