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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

increment an Excel comumn index with Syncfusion and csharp

Thread ID:

Created:

Updated:

Platform:

Replies:

95290 Jun 30,2010 09:31 AM UTC Jul 1,2010 08:37 AM UTC WinForms 1
loading
Tags: XlsIO
msmcool
Asked On June 30, 2010 09:31 AM UTC

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 [Syncfusion]
Replied On July 1, 2010 08:37 AM UTC

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

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.

Warning Icon 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.Close Icon

;