We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Updated from 4.3 to 4.4 - writing cells 20 times slower

Thread ID:





58675 Mar 26,2007 07:24 PM UTC Mar 27,2007 04:04 AM UTC WinForms 2
Tags: XlsIO
Petr Vones
Asked On March 26, 2007 07:24 PM UTC

I've just updated from to and found that the code generating mostly text and number cells (seven sheets, approx. 50 rows and 20 columns) is 20 times slower comparing to ! It seems as if I comment out all IRange.Text and IRange.Number assignments the speed is back (without having written the content of course).

Are there any new properties I should use to optimize it (pre-allocate total number of cells or such) ? This is unacceptable, sorry.


Petr Vones
Replied On March 26, 2007 08:20 PM UTC

Attached is simple test project demonstrating the problem. It takes about 1 second with older version and 20 seconds with latest one.


Melba Winshia [Syncfusion]
Replied On March 27, 2007 04:04 AM UTC

Hi Petr,

I was able to reproduce the problem. However, this issue has been fixed in our upcoming version. I tested the sample in our upcoming version and it took only 2 seconds. Here is the video clip for your reference:


Our next release (v5) is scheduled to be released within this week, which has great improvement in performance (reduced memory and better speed).

Kindly let me know if you have any other questions.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon