Find Performance with Large Spreadsheet

3 posts, 0 answers
  1. Canon Fazenbaker
    Canon Fazenbaker avatar
    2 posts
    Member since:
    Apr 2010

    Posted 30 Apr Link to this post

    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. Dimitar
    Admin
    Dimitar avatar
    2790 posts

    Posted 01 May Link to this post

    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.
  3. Canon Fazenbaker
    Canon Fazenbaker avatar
    2 posts
    Member since:
    Apr 2010

    Posted 01 May in reply to Dimitar Link to this post

    Thank you Dimitar. I appreciate the quick response. 
Back to Top