Getting Cell Name (A1, B1 etc)

[Evelyn]

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.

[Deyan]

Hello Evelyn,

Thank you for contacting us.

You may use the NameConverter class to convert cell indices and cell ranges to spreadsheet names. More specifically you may use ConvertCellIndexToName and ConvertCellRangeToName methods.

I hope this is helpful. If you have any other questions or concerns please do not hesitate to contact us again.

Regards,
Deyan
the Telerik team