MESCIUS SPREAD for Windows Forms 15.0J
NonEmptyRowCount プロパティ (DefaultSheetDataModel)
使用例 

モデル内のデータ(連結または非連結)を含む行の数を取得します。
構文
'宣言
 
Public Overrides ReadOnly Property NonEmptyRowCount As Integer
public override int NonEmptyRowCount {get;}

プロパティ値

空でない行の数を表す Integer
使用例
Dim strArray() As String = {"Ronnie", "Jack", "Lori", "Max", "Tricky"}
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5)
Dim i, j As Integer
dataModel.DataSource = strArray
FpSpread1.ActiveSheet.Models.Data = dataModel
i = dataModel.NonEmptyColumnCount
j = dataModel.NonEmptyRowCount
ListBox1.Items.AddRange(New Object() {i.ToString(), j.ToString()})
string[] strArray = new string[5] {"Ronnie", "Jack", "Lori", "Max", "Tricky"};
int i, j;
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(8, 8);
dataModel.DataSource = strArray;
fpSpread1.ActiveSheet.Models.Data = dataModel;
i = dataModel.NonEmptyColumnCount;
j = dataModel.NonEmptyRowCount;
listBox1.Items.AddRange(new object[] {i.ToString(), j.ToString()});
参照

DefaultSheetDataModel クラス
DefaultSheetDataModel メンバ

 

 


© MESCIUS inc. All rights reserved.