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?
ADAdministrator Syncfusion Team June 13, 2005 05:20 PM
Please find a sample that uses ExcelRW and Calculate to resolve a reference between 2 excel files linked to below:
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.