NonEmptyRowCount Property

Gets the number of rows in cell blocks that contain data, styles, tags, or sparklines.

Syntax

Visual Basic
C#

'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public ReadOnly Property NonEmptyRowCount As System.Integer

'Usage
 
Dim instance As Worksheet
Dim value As System.Integer
 
value = instance.NonEmptyRowCount

[System.ComponentModel.DefaultValue()]
public System.int NonEmptyRowCount {get;}

Example

This example uses the NonEmptyRowCount property.

listBox1.Items.Add(gcSpreadSheet1.Sheets[0].NonEmptyRowCount.ToString());

VB.NET

ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).NonEmptyRowCount.ToString())

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

Worksheet Class
Worksheet Members