LastNonEmptyRowIndex Property

Gets the last nonempty bound row index on the sheet.

Syntax

Visual Basic
C#

'Declaration
 
<DefaultValueAttribute()>
Public ReadOnly Property LastNonEmptyRowIndex As Integer

'Usage
 
Dim instance As Worksheet
Dim value As Integer
 
value = instance.LastNonEmptyRowIndex

[DefaultValue()]
public int LastNonEmptyRowIndex {get;}

Property Value

The last index of the nonempty row.

Example

This example uses the LastNonEmptyRowIndex property.

C#
VB.NET

gcSpreadSheet1.Sheets[0].DefaultColumnWidth = 30;
gcSpreadSheet1.Sheets[0].DefaultRowHeight = 20;
gcSpreadSheet1.Sheets[0].Cells(0, 0).Text = "test";
gcSpreadSheet1.Sheets[0].ReferenceStyle = GrapeCity.Xaml.SpreadSheet.Data.ReferenceStyle.A1;
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].LastNonEmptyRowIndex.ToString());

GcSpreadSheet1.Sheets(0).DefaultColumnWidth = 30
GcSpreadSheet1.Sheets(0).DefaultRowHeight = 20
GcSpreadSheet1.Sheets(0).Cells(0, 0).Text = "test"
GcSpreadSheet1.Sheets(0).ReferenceStyle = GrapeCity.Xaml.SpreadSheet.Data.ReferenceStyle.A1
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).LastNonEmptyRowIndex.ToString())

Reference

Worksheet Class
Worksheet Members