Use Variable in CalculateFormula

[madadkhani]

Hi

I want to use variable in CalculateFormaula Method. Something like this:

int num1 = 1;

int num2 = 2;

int num3 = 3;

_etcResultWorksheet.Cells[0, 0].Formula = “Average(num1,num2,num3)”;

_etcResultWorkbook.CalculateFormula();

var x = _etcResultWorksheet.Cells[0, 0].Value.ToString();

How i can do it?

[Amjad_Sahi]

Hi,

You may try as following for your reference, see the line of code in bold.

Sample code:

Workbook _etcResultWorkbook = new Workbook();

Worksheet _etcResultWorksheet = _etcResultWorkbook.Worksheets[0];

int num1 = 1;

int num2 = 2;

int num3 = 3;

_etcResultWorksheet.Cells[0, 0].Formula = “Average(” + num1 + “,” + num2 + “,” + num3 + “)”;

_etcResultWorkbook.CalculateFormula();

var x = _etcResultWorksheet.Cells[0, 0].Value.ToString(); //2 - OK

Thank you.