Hello, I am filling my spreadsheet programmatically.
I need the cell "name" to use it in a formula.. For example:
string
formula =
"=SUM("
+ worksheet.Cells[row, column].GETNAME() +
";"
+ worksheet.Cells[row, column + 1].GETNAME() +
")"
;
* This GETNAME method should return "A1", "B1", "C1", etc...
And then, set the formula value to another cell:
worksheet.Cells[row + 3, column].SetValue(formula);
Is this the best way of doing this? Remember that the variables 'row' and 'column' are set before in a logic that I have to use. So it can change.