Spread Silverlight Documentation
GetNonEmptyRows Method (Worksheet)
Example 


Returns a list of nonempty row indexes.
Syntax
'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());
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())
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

Worksheet Class
Worksheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.