Excel scope not working

I have records almost 4 lakh I used activity read range activity in excel scope its successfully work 4-5 time.But now it stuck in read range after 30 mint it still showing execution read range

1 Like

@Aditya10989

Could you please give it a try with Workbook Activities and check it.

1 Like

@lakshman yes try but not work showing executing

Hi @Aditya10989,

Can you elaborate the situation of using read range ?

Regards
Balamurugan.S

I have almost 4 lakh records in one column contain value is zero or almost like 0.01,-.01 I need to delete those records
I have created the condition
amount >.0.9 and amount <0.01
Now I want delete all the record those record which exist in this condition

HI @Aditya10989,

Really it a huge record count.You send a file or sample one . I can able to give the suggestion to delete the row. (If it is confidential , you can send me by message).

Regards
Balamurugan.S

1 Like

thanks for help actually I need this code because do this activity every month end right now I got one activity right now its taking time but main thing is its working

1 Like

@Aditya10989,

What is the activity ? it will helpful to others…

Regards
Balamurugan.S

1 Like

yes sure UIPathteam.XLActivities

1 Like

It is a cool activity. It reads the data using the OpenXml way. Even it won’t crash the excel while using large data…
Good choice…

Regards
Balamurugan.S

2 Likes

Now my requirement is
amount >.0.9 and amount <0.01
I want delete all the record those record which exist in this condition.
how to delete complete entire row can you please help me on this…?

2 Likes

Hi @Aditya10989,

As I said already we are sharing our opinions and suggestions.The thing is. Only we can give the right solution , when we have the real thing. Because yours is different

Thank you
Balamurugan.S

Sorry I did not understand.