increment an Excel comumn index with Syncfusion and csharp

[msmcool]

Hello!
I want to make a counter to increment column range but the problem that the index is in letter and after 'Z' there 'AA' so how to use sheet.Range[C+R] to increment the column
Thanks in advance

[Geetha M]

Hi,

Thank you for your interest in Syncfusion products.

You can use row and column numbers to refer a range. Here is the code snippet:

sheet[1, i].Text = "Col " + i.ToString();

I have placed the sample here.
http://help.syncfusion.com/samples/XlsIO.Windows/F95290/F95290.zip

Please let us know if you have any questions.

Regards,
Geetha