//Initialization of first ICalcData object in CalcEngine,
calcData = new CalcData();
CalcEngine engine = new CalcEngine(calcData);
//Initialization of second ICalcData object in CalcEngine,
calcData1 = new calcData1();
engine = new CalcEngine(calcData1);
//Create a unique family id,
int i = CalcEngine.CreateSheetFamilyID();
//Register the first ICalcData object as "Sheet1",
engine.RegisterGridAsSheet("Sheet1", calcData, i);
//Register the second ICalcData object as "Sheet2",
engine.RegisterGridAsSheet("Sheet2", calcData1, i);
//Access the two sheet references in the formula,
string formula = “SUM(Sheet1!A1, Sheet2!A1)”;
//Computation of result,
string result = engine.ParseAndComputeFormula(formula); |
Hi Sergio,
Thanks for your update.
We have prepared the simple sample by using CalcQuickBase. Please find the attached sample and let us know if you have any queries,
Sample link:
Regards,Deivaselvan