Hello, can anyone help me check on why will lead to this issue:
When I using this file:
template 25.2.24 (MU-rep).xlsx (42.1 KB)
there has some bug
1 ) the first three row is empty
2) the formula in cell T2 that generated by the robot is bug
Yet, if I use another file, the outcome is normal eg:
template 25.2.24 (MU-rep) 2.xlsx (51.1 KB)
template 15.3.24 (FA).xlsx (33.3 KB)
May I know how i can cope with this, if the file has problem, can anyone help me to check on it? Many thx!!
My workflow:
MU-Rep sorting (in_outrange) before confi…xaml (44.5 KB)
@Happydayyy ,
I remember the code I had helped you. To remove these blank rows, remove these blank rows from DataTable before writing in excel file.
Use Filter DataTable add condition on any column = “”
Thanks,
Ashok
1 Like
@Happydayyy Pls provide me more details
you are using two robo for same task?
both are performing read and write in the same excel file
both robots are performing the same kind of action and logic
but bot one working properly and bot two is failing
In this case, use the performer dispatcher bot concept, I will give you more clarity and solution after providing your input.
Pls try below it solve your issue
use sr no as unquie Identifyer
Read All Sr No and write to the template excel
read one by one sorce data in data table and write it to template
I think if you can push this data in SQL Database and perform logic and re-write the same time in excel it solve the your issue
I am sorry about that, maybe the code is loss, can you help me one more time by using my robot? Many thankssss!!!
[quote=“mukesh.singh, post:3, topic:727668”]
you are using two robo for same task? No , I am using one robot to perform 2 tasks
both are performing read and write in the same excel file, No, the two files are distinctive
A robot is performing the same kind of action and logic
May i ask why there happen this question…
Many thanks…
@ashokkarale
@Happydayyy ,
Give column name in the filter datatable like “Start Date” or any other column name as all columns are empty.
Save the project. Close the studio. Open project again and try to debug.
this time this problem…
I think studio remembered the earlier name of the column with invalid " symbol at the start.
Save the sequence and restart the studio and try.
I hope this will work this time as everything is good now.
1 Like
I am sorry that I type the wrong name, now the robot is work but the outcome is still remain problem…
I now shared the revised path for u.
Robot
MU-Rep sorting (in_outrange) before confi…xaml (45.7 KB)
excel
template 25.2.24 (MU-rep).xlsx (42.1 KB)
@Happydayyy ,
Got the issue. We should be using Is Empty for comparison.
Here is the output now:
Formula also seems fixed.
Updated workflow:
MU-Rep sorting (in_outrange) before confi…xaml (45.0 KB)
Thanks,
Ashok
2 Likes
Thank you so much, this single component is ok now, I am trying to combine it to my final version. If i face some issue when combining, can I ask you for help?
1 Like
Sure! I will try my best to help you
Thanks,
Ashok
1 Like
When I combine it to the final ver robot, there is an issue…Can you help me on this post, thank you so much!!
@ashokkarale
system
(system)
Closed
March 21, 2024, 6:30pm
18
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.