Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Fri Oct 05, 2018 2:22 am

Hi

What is the difference between these two properties? Why do they sometimes have different values?

Thanks

mongoose
 
Posts: 11
Joined: Wed Jan 13, 2016 5:07 pm

Fri Oct 05, 2018 4:41 am

Dear Samuel,

Thanks for your inquiry.
The Rows.Length represents the calculation of row's length, and the LastRow property represents the index of last row. In general, the value of them should be the same in most occasions. Could you please provide your detailed case (such as your sample Excel or your code) which demonstrates the different values of the two properties to us? Then we can look into it and provide an accurate response to you.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Tue Oct 09, 2018 9:23 am

Hi,

Greetings from E-iceblue.
How is your issue going? Could you please give us some feedback at your convenience?
Thanks in advance.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Return to Spire.XLS