Referencing cells by their A1-style address

[Administrator]

I'm using a GridControl. I need to programmatically reference several cells by their A1-style addresses. Is there any syntax for doing so? If not, does the Syncfusion library offer a function for converting between an A1-style address to a column number and row number?

-TC

[Jeya Preetha M]

Hi Tc,

Thank you for your interest in Syncfusion Products.

To convert the row number and column number to A1 style address, Please make use of "GetAlphaLabel()" and "GetNumericLabel()" methods.

 Console.Write(GridRangeInfo.GetAlphaLabel(3));
 Console.Write(GridRangeInfo.GetNumericLabel(3));

Please let me know if you have any concerns.

Regards,
Jeya Preetha M

[Chris Bishop]

I'm using a GridControl. I need to programmatically reference several cells by their A1-style addresses. Is there any syntax for doing so? If not, does the Syncfusion library offer a function for converting between an A1-style address to a column number and row number?

-TC

To convert "A1":
Row 1 = model.Engine.RowIndex("A1")
Col 1 = model.Engine.ColIndex("A1")