Excel spreadsheet

Help Studio
,
1

I have 1000 records in the spreadsheet, I need to find only 2 desired records present in the spreadsheet. I have tried using ForEach but it was so time consuming. So, is there any alternate approach or way to attain it ?

2

Hi @priya_dharshini11,

Good day !!

We can find a desired record/data from the spreadsheet using Linq instead of using legacy foreach. Basically it help to find the exactly value and save more time.

Thanks in advance,
Jayavignesh G

3

Hi,

In general, we can use FiliterDataTable, DataTable.Select method or LINQ etc to improve throughput.
If possible, can you share your input, condition, expected output? We might be able to write sample for it.

Regards,

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.