GetNonEmptyRows Method (Worksheet)

Returns a list of nonempty row indexes.

Syntax

Visual Basic
C#

'Declaration
 
Public Function GetNonEmptyRows() As System.Collections.Generic.List(Of Integer)

'Usage
 
Dim instance As Worksheet
Dim value As System.Collections.Generic.List(Of Integer)
 
value = instance.GetNonEmptyRows()

public System.Collections.Generic.List<int> GetNonEmptyRows()

Return Value

A list of indexes.

Example

This example uses the GetNonEmptyColumns method.

listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetNonEmptyColumns().Count.ToString());
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetNonEmptyRows().Count.ToString());
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetRowAutoText(3).ToString());

VB.NET

ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetNonEmptyColumns.Count.ToString())
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetNonEmptyRows.Count.ToString())
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetRowAutoText(3).ToString())

Reference

Worksheet Class
Worksheet Members