MW
Melba Winshia
Syncfusion Team
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
AD
Administrator
Syncfusion Team
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..
MW
Melba Winshia
Syncfusion Team
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
