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.
Syncfusion Feedback

Open excel file with links

Thread ID:

Created:

Updated:

Platform:

Replies:

24545 Feb 7,2005 10:57 AM UTC Feb 11,2005 02:54 PM UTC Windows Forms 3
loading
Tags: XlsIO
Thierry Vessereau
Asked On February 7, 2005 10:57 AM UTC

Hello I try to open an Excel file with the method ExcelUtils.Open() of ExcelRW component. The file contains many links to external data source. Is it possible not to refresh these links? The links refresh takes a lot of a time and I only need the current values of the cells. Thanks Thierry

Administrator [Syncfusion]
Replied On February 9, 2005 02:37 PM UTC

Hi Thierry, Would it be possible to send the file to me at stephenj @ syncfusion.com . I dont think that the links are getting refreshed during file open. What is the size of the file that you are trying to open?. Thanks, Stephen. >Hello > >I try to open an Excel file with the method ExcelUtils.Open() of ExcelRW component. The file contains many links to external data source. > >Is it possible not to refresh these links? The links refresh takes a lot of a time and I only need the current values of the cells. > >Thanks >Thierry

Thierry Vessereau
Replied On February 10, 2005 09:21 AM UTC

Hi Stephen Unfortunately I can not send you the file because it contains sensitive data. The size of the file is around 2M and contains around 15 worksheets. But I need only a few data from this file (around 1000 cells) It takes however 3-4 minutes to open with the method ExcelUtils.Open(). I dont understand why it takes so long. With an application written in MS/Access I need only a few seconds to access the data. I have the idea now that all the data in the Excel file may be readen with the method Open()? Is it true? If yes, is there an other way to read an excel file? Thanks a lot Thierry >Hi Thierry, > >Would it be possible to send the file to me at > >stephenj @ syncfusion.com . I dont think that the links are getting refreshed during file open. What is the size of the file that you are trying to open?. > >Thanks, > >Stephen. > >>Hello >> >>I try to open an Excel file with the method ExcelUtils.Open() of ExcelRW component. The file contains many links to external data source. >> >>Is it possible not to refresh these links? The links refresh takes a lot of a time and I only need the current values of the cells. >> >>Thanks >>Thierry

Administrator [Syncfusion]
Replied On February 11, 2005 02:54 PM UTC

Hi Thierry, I am afraid, there is no other way to read specific information, ExcelRW reads and parses the whole file with formatting during the read process and populates the complete object model, so there is no way to avoid it. This is possibly a general performance issues with ExcelRW in handling some data in your spreadsheet. However, we are aware of this issue and are working on rectifying it based on sample spreadsheets sent by other customers. We expect to have a build in three weeks time that would address these performance issues with large files. Thank you for your patience. Best regards, Stephen. > >Hi Stephen > >Unfortunately I can not send you the file because it contains sensitive data. > >The size of the file is around 2M and contains around 15 worksheets. But I need only a few data from this file (around 1000 cells) > >It takes however 3-4 minutes to open with the method ExcelUtils.Open(). > >I dont understand why it takes so long. With an application written in MS/Access I need only a few seconds to access the data. > >I have the idea now that all the data in the Excel file may be readen with the method Open()? Is it true? If yes, is there an other way to read an excel file? > >Thanks a lot >Thierry > >>Hi Thierry, >> >>Would it be possible to send the file to me at >> >>stephenj @ syncfusion.com . I dont think that the links are getting refreshed during file open. What is the size of the file that you are trying to open?. >> >>Thanks, >> >>Stephen. >> >>>Hello >>> >>>I try to open an Excel file with the method ExcelUtils.Open() of ExcelRW component. The file contains many links to external data source. >>> >>>Is it possible not to refresh these links? The links refresh takes a lot of a time and I only need the current values of the cells. >>> >>>Thanks >>>Thierry

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.

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

;