I am using XlsIo to parse large (50k rows) Excel documents. This takes a while. I'm not expecting it to be instant, but I'm wondering if there's any simple tricks to improve performance. An example of my current code:
if (!double.IsNaN(latitude) && !double.IsNaN(longitude))
Location location = new Location(latitude, longitude);
For my test spreadsheet, this is taking about six seconds. The spreadsheet has nine columns, and if I remove all but the first two (which I'm actually interested in), I can get this down to under two seconds.
I notice that XlsIo tries to parse the values of each cell in a number of ways, which gives you nice Number and DateTime properties, but this probably has a performance cost. Is there any way to customize this behavior? I'd like to tell the parser: "the first two columns are numbers, don't do anything with the rest", or "columns zero and one are numbers, two is a DateTime, so don't try to parse dates into numbers or anything".
MKManoj Kumar G M Syncfusion Team May 2, 2013 09:10 AM UTC
Thank you for choosing Syncfusion products.
We have already logged a feature report to improve
performance while parsing large document and it will be implemented in any of
our forth-coming releases. We will get back to you once the feature has been implemented
Please let us know if you require any further