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