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

Multiple Excel Files

Thread ID:





29571 May 27,2005 08:40 PM UTC Jun 13,2005 10:20 PM UTC WinForms 1
Tags: XlsIO
Asked On May 27, 2005 08:40 PM UTC

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 10:20 PM UTC

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


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