We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Referencing cells by their A1-style address

Thread ID:

Created:

Updated:

Platform:

Replies:

103235 Apr 15,2012 12:29 AM Jan 13,2015 12:27 PM Windows Forms 2
loading
Tags: GridControl
Administrator [Syncfusion]
Asked On April 15, 2012 12:29 AM

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 [Syncfusion]
Replied On April 24, 2012 04:21 AM

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
Replied On January 13, 2015 12:27 PM

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")



CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;