This is a migrated thread and some comments may be shown as answers.

Find Performance with Large Spreadsheet

2 Answers 112 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Canon Fazenbaker
Top achievements
Rank 1
Canon Fazenbaker asked on 30 Apr 2019, 07:06 PM

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);
            }

2 Answers, 1 is accepted

Sort by
0
Dimitar
Telerik team
answered on 01 May 2019, 10:41 AM
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
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Canon Fazenbaker
Top achievements
Rank 1
answered on 01 May 2019, 10:55 AM
Thank you Dimitar. I appreciate the quick response. 
Tags
Spreadsheet
Asked by
Canon Fazenbaker
Top achievements
Rank 1
Answers by
Dimitar
Telerik team
Canon Fazenbaker
Top achievements
Rank 1
Share this question
or