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)
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)
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
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
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.
Hi @mitul_choudhary ,
Can you give me brief what exactly you want to achieve through this code?
@ermanoj3101 bot is scanning the excel & coluring/highlighting the different values.
Hope it helps…!!
I got it but it is already optimised with Linq, can’t optimise more .
Thanks
@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
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.
Yep, Exactly.
But we can still group some common ranges and then highlight. But need a bit complex logic to be built.
I agree, this is totally a Macro stuff.
Macros is been already used for highlighting.