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.
Unfortunately, activation email could not send to your email. Please try again.

Traveling through sheet and slow, very slow

Thread ID:

Created:

Updated:

Platform:

Replies:

53104 Dec 8,2006 02:20 AM Dec 14,2006 11:52 PM Windows Forms 4
loading
Tags: XlsIO
Werner Plumot
Asked On December 8, 2006 02:20 AM

I just downloaded 4.4.051. My program that was reading the Excel sheet has become VERY slow. What was done in 3 second is taking 60-30 seconds now. I am traveling on an excel sheet to find positions of specific text with .Range[x,y] command. It is slow... (also saving an excel sheet becomes very slow).
I have functions like : GoToTheNextFilledPosition, GoToTheNextEmptyPosition,... if I loop with Range[x,y] for more then 265 places (without finding what I want) then an error is thrown.
Also I keep positions like thisSpecialPosition = Range[x,y]. If I browse them after a while for changing the format of the sheet (other borders, colors, etc...) then the address becomes when debugging unusefull, meaning it is not nulll, it is marked with a red exclam.-icon when debugging in VS2005.

Chella Pandian B [Syncfusion]
Replied On December 8, 2006 08:51 PM

Hi Werner Plumot ,

We are extremely Sorry for the inconvenience. I need 2 more days to discuss this issue with my team an get back to you.

Thanks for using Syncfusion XlsIO.

With regards,
Chella.

Chella Pandian B [Syncfusion]
Replied On December 11, 2006 05:53 PM

Hi Werner Plumot ,

I seriously regret for the delay. Can you please create a Direct-Trac incident for this issue so that I can give you some samples to test the performance between various operations?

We are extremely sorry for the inconvenience.
Thanks for your interest in Syncfusion Essentials XlsIO.

With regards,
Chella.

Werner Plumot
Replied On December 12, 2006 06:12 AM

I placed it on the Direct Trac but It seems that it is slow in debug mode.

Melba Winshia [Syncfusion]
Replied On December 14, 2006 11:52 PM

Hi Werner,

The performance issue is something we are working on currently. However, since there are major changes being made to the code it can also take a little bit more time to get a stable version out, but its something we are looking into very seriously. We regret for the inconvenience caused. Please let me know if you have any concerns regarding this issue.

Thanks,
Melba

CONFIRMATION

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.

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.

;