We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Speed up FindAll()

I have two workbooks. A large one with several sheets and around 1500 rows. And a smaller one with around 50 rows.

I loop through the smaller one and call FindAll() for each row on two sheets.
This takes around 5 min.

I wonder if I can improve the speed.

3 Replies

AV Abirami Varadharajan Syncfusion Team June 13, 2019 01:28 PM UTC

Hi Paul, 
Greetings from Syncfusion. 
We are unable to reproduce the issue while invoking FindAll() for each row upto 50 rows. We are sharing the sample created as per your scenario for your reference which can be downloaded from following link. 
It is recommended to use FindAll() for worksheet  to find the specific word in entire worksheet. If the issue still persist, kindly share us issue reproducing sample to validate further from our side. 

PM Paul Meems June 21, 2019 02:38 PM UTC

I understand no special settings are available/
The slowness is most likely due to my sheet.

This issue can be closed.

AV Abirami Varadharajan Syncfusion Team June 24, 2019 07:38 AM UTC

Hi Paul, 

Thank you for updating us. 

Please let us know if you need any further assistance. 


Live Chat Icon For mobile
Up arrow icon