Find Performance with Large Spreadsheet

[Canon Fazenbaker]

I have a spreadsheet with about 30,000 rows and 20 columns. The "find" functionality works as expected, but the search itself takes over 5 seconds for it to find the relevant data. The same functionality in excel takes miliseconds.

I realize that it will never be as fast as searching in excel, but is there any way to improve performance to get closer to the excel search times (i.e. Indexing the data or only allowing searching through specific columns). 

Here is how I am loading the data currently: 

            string fileName = @"C:\temp\large_data.xlsx";
            var formatProvider = new XlsxFormatProvider();
            using (Stream input = new FileStream(fileName, FileMode.Open))
            {
                radSpreadsheet1.Workbook = formatProvider.Import(input);
            }

[Dimitar]

Hi Canon,

I have logged this in our Feedback Portal so our developers can investigate it and determine if the performance can be improved. You can track its progress, subscribe to status changes and add your comment to it here. I have also updated your Telerik Points.

Should you have any other questions do not hesitate to ask.

Regards,
Dimitar
Progress Telerik

[Canon Fazenbaker]

Thank you Dimitar. I appreciate the quick response.