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.

MAXROWS Const?

Thread ID:

Created:

Updated:

Platform:

Replies:

58314 Mar 21,2007 09:31 PM Mar 23,2007 05:37 AM ASP.NET Web Forms (Classic) 3
loading
Tags: XlsIO
Jim Barry
Asked On March 21, 2007 09:31 PM

Is there a MAXROWS and/or MAXCOL value that I can reference in my C# ASP.NET Code?

Melba Winshia [Syncfusion]
Replied On March 22, 2007 07:16 AM

Hi JimB,

Thanks for your interest in Essential XlsIO.

I am not sure if I understand your requirements correctly. You can get the maximum rows count and maximum column count by using the following code snippets

[C#]

// Maximum row
int MAXROWs=sheet.UsedRange.Rows.Length;

// Maximum column
int MAXCOL=sheet.UsedRange.Columns.Length;

If this is not the case could you please provide more details on "Is there a MAXROWS and/or MAXCOL value that I can reference in my C# ASP.NET Code". This would help me in investigating further on this issue.

Thanks,
Melba

Administrator [Syncfusion]
Replied On March 22, 2007 01:33 PM

Thanks. I'm looking for the total number of rows that could be used on any particular sheeet. I know the number is around 64000, but I want to prepare for 2007 and not use a hard coded number. I'm not sure what qualifies the term 'Used' in your API..

Melba Winshia [Syncfusion]
Replied On March 23, 2007 05:37 AM

Hi JimB,

The total number of rows that could be used on any particular sheet is 65,536 and the total number of columns that could be used on any particular sheet is 256 columns. Here is the link for your reference:

http://www.datadynamics.com/forums/602/ShowPost.aspx

The UsedRange of our API refers to the maximum rows/columns which contains data or style.

Kindly let me know if you have any other questions.

Regards,
Melba

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.

;