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

MAXROWS Const?

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 11:16 AM UTC

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 05:33 PM UTC

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 09:37 AM UTC

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.

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

;