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.

Multiple Excel Files

Thread ID:

Created:

Updated:

Platform:

Replies:

29571 May 27,2005 04:40 PM Jun 13,2005 06:20 PM Windows Forms 1
loading
Tags: XlsIO
Tim
Asked On May 27, 2005 04:40 PM

I just downloaded the evaluation version and I have a quick question before I get too far into the evaluation. Here is the situation: I have two excel files, file1.xls and file2.xls. file1.xls contains many references to cells in file2.xls. Is there a way to read in both excel files and then use the EssentialCalculate product to actually do the calculation correctly so that I can change a value in the second spreadsheet and have it correctly update in the first spreadsheet?

Administrator [Syncfusion]
Replied On June 13, 2005 06:20 PM

Hi Tim, Please find a sample that uses ExcelRW and Calculate to resolve a reference between 2 excel files linked to below: http://www.syncfusion.com/support/user/uploads/cs_usingformulasacrossworksheets.zip The method of resolving the reference is very minimal and hardcoded at present because the reference appears as an invalid refernce when ExcelRW loads the file. I will submit feature requests for solving this problem and also building in the ability to recursively resolve foreign references into the ExcelRW library itself. Thank you for your patience. Regards, Davis

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.

;