Making the Bot fast-Excel Automation

Hi @Nithinkrishna @ermanoj3101

PFA bot i have used LINQ query for making bot fast.
But still it’s taking time.
Please help to optimize the bot.

Thanks
Boe Bot -2 Backup.zip (500.8 KB)

1 Like

@Nithinkrishna Please help on this…!!

1 Like

we would assume that not the LINQ is doing the slow execution. Set Range color will need its time and will take a particular portion from the execution time

a possible optimatzation strategy is to do all filtering / dataacrbatics in advance with the outcomde of row index information. So only rows needed to be colored will be colored

2 Likes

Hey @mitul_choudhary

Sorry I’m not in position to help immediately.

But will try… @ermanoj3101 if you can help please ?

You can even please try the optimisation point mentioned by @ppr
Thanks
#nK

1 Like

Hi @mitul_choudhary ,

No sure , how to optimise this as it will require loop to highlight rows.

Still let me check if i can do something.

Thanks.

1 Like

Hi @mitul_choudhary ,

Can you give me brief what exactly you want to achieve through this code?

1 Like

@ermanoj3101 bot is scanning the excel & coluring/highlighting the different values.

Hope it helps…!!

1 Like

I got it but it is already optimised with Linq, can’t optimise more .

Thanks

1 Like

@mitul_choudhary One optimizing is like you may use excel interop library or macro to perform the highlighting part.

But still I don’t have conclusive evidence that it will make it fast though.

Thanks
#nK

1 Like

But in that case also lopping will work as their is not always a sequence of row that can be highlighted, the rows can be at any place.

2 Likes

Yep, Exactly.

But we can still group some common ranges and then highlight. But need a bit complex logic to be built.

1 Like

I agree, this is totally a Macro stuff.

2 Likes

Macros is been already used for highlighting.

1 Like