When trying two file using same robot, why one is ok but another has bug

[Happydayyy (22035153d)]

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)

[ashokkarale]

@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

[mukesh.singh]

@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

[Happydayyy (22035153d)]

I am sorry about that, maybe the code is loss, can you help me one more time by using my robot? Many thankssss!!!

[Happydayyy (22035153d)]

[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

[Happydayyy (22035153d)]

May i ask why there happen this question…

Many thanks…

@ashokkarale

[ashokkarale]

@Happydayyy,

Give column name in the filter datatable like “Start Date” or any other column name as all columns are empty.

[Happydayyy (22035153d)]

@ashokkarale

“Start Date

This error…

[ashokkarale]

Save the project. Close the studio. Open project again and try to debug.

[lrtetala (Lakshman Reddy)]

Hi @Happydayyy

Retype the double quotes

Cheers!!

[Happydayyy (22035153d)]

this time this problem…

[ashokkarale]

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.

[Happydayyy (22035153d)]

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)

[ashokkarale]

@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

[Happydayyy (22035153d)]

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?

[ashokkarale]

Sure! I will try my best to help you

Thanks,
Ashok

[Happydayyy (22035153d)]

When I combine it to the final ver robot, there is an issue…Can you help me on this post, thank you so much!!

Why the formular cell need to write by robot is disappear

@ashokkarale