コーディングでグループ化を実行したい
対象製品
SPREAD for ASP.NET 8.0J
詳細
下記サンプルコードのように、データモデルからグループデータモデルオブジェクトを取得し、Group メソッドを実行することで、コーディングによるグループ化を行うことができます。
◎サンプルコード(VB)
◎サンプルコード(C#)
◎サンプルコード(VB)
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If IsPostBack Then
Return
End If
FpSpread1.ActiveSheetView.ColumnCount = 4
FpSpread1.ActiveSheetView.RowCount = 4
' テストデータを設定します
FpSpread1.ActiveSheetView.Cells(0, 0).Text = "Jack"
FpSpread1.ActiveSheetView.Cells(0, 1).Text = "Male"
FpSpread1.ActiveSheetView.Cells(0, 2).Text = "3000 USD"
FpSpread1.ActiveSheetView.Cells(0, 3).Text = "Teacher"
FpSpread1.ActiveSheetView.Cells(1, 0).Text = "Tommy"
FpSpread1.ActiveSheetView.Cells(1, 1).Text = "Male"
FpSpread1.ActiveSheetView.Cells(1, 2).Text = "3000 USD"
FpSpread1.ActiveSheetView.Cells(1, 3).Text = "Developer"
FpSpread1.ActiveSheetView.Cells(2, 0).Text = "Cassie"
FpSpread1.ActiveSheetView.Cells(2, 1).Text = "FeMale"
FpSpread1.ActiveSheetView.Cells(2, 2).Text = "3200 USD"
FpSpread1.ActiveSheetView.Cells(2, 3).Text = "Teacher"
FpSpread1.ActiveSheetView.Cells(3, 0).Text = "Mary"
FpSpread1.ActiveSheetView.Cells(3, 1).Text = "FeMale"
FpSpread1.ActiveSheetView.Cells(3, 2).Text = "2700 USD"
FpSpread1.ActiveSheetView.Cells(3, 3).Text = "Accountant"
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
' クライアント側の変更を確定します
FpSpread1.SaveChanges()
' グループ化を行います
Dim gm As New FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.ActiveSheetView.DataModel)
Dim sort(0) As FarPoint.Web.Spread.SortInfo
sort(0) = New FarPoint.Web.Spread.SortInfo(1, True)
gm.Group(sort)
FpSpread1.ActiveSheetView.DataModel = gm
End Sub
If IsPostBack Then
Return
End If
FpSpread1.ActiveSheetView.ColumnCount = 4
FpSpread1.ActiveSheetView.RowCount = 4
' テストデータを設定します
FpSpread1.ActiveSheetView.Cells(0, 0).Text = "Jack"
FpSpread1.ActiveSheetView.Cells(0, 1).Text = "Male"
FpSpread1.ActiveSheetView.Cells(0, 2).Text = "3000 USD"
FpSpread1.ActiveSheetView.Cells(0, 3).Text = "Teacher"
FpSpread1.ActiveSheetView.Cells(1, 0).Text = "Tommy"
FpSpread1.ActiveSheetView.Cells(1, 1).Text = "Male"
FpSpread1.ActiveSheetView.Cells(1, 2).Text = "3000 USD"
FpSpread1.ActiveSheetView.Cells(1, 3).Text = "Developer"
FpSpread1.ActiveSheetView.Cells(2, 0).Text = "Cassie"
FpSpread1.ActiveSheetView.Cells(2, 1).Text = "FeMale"
FpSpread1.ActiveSheetView.Cells(2, 2).Text = "3200 USD"
FpSpread1.ActiveSheetView.Cells(2, 3).Text = "Teacher"
FpSpread1.ActiveSheetView.Cells(3, 0).Text = "Mary"
FpSpread1.ActiveSheetView.Cells(3, 1).Text = "FeMale"
FpSpread1.ActiveSheetView.Cells(3, 2).Text = "2700 USD"
FpSpread1.ActiveSheetView.Cells(3, 3).Text = "Accountant"
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
' クライアント側の変更を確定します
FpSpread1.SaveChanges()
' グループ化を行います
Dim gm As New FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.ActiveSheetView.DataModel)
Dim sort(0) As FarPoint.Web.Spread.SortInfo
sort(0) = New FarPoint.Web.Spread.SortInfo(1, True)
gm.Group(sort)
FpSpread1.ActiveSheetView.DataModel = gm
End Sub
◎サンプルコード(C#)
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
FpSpread1.ActiveSheetView.ColumnCount = 4;
FpSpread1.ActiveSheetView.RowCount = 4;
// テストデータを設定します
FpSpread1.ActiveSheetView.Cells[0, 0].Text = "Jack";
FpSpread1.ActiveSheetView.Cells[0, 1].Text = "Male";
FpSpread1.ActiveSheetView.Cells[0, 2].Text = "3000 USD";
FpSpread1.ActiveSheetView.Cells[0, 3].Text = "Teacher";
FpSpread1.ActiveSheetView.Cells[1, 0].Text = "Tommy";
FpSpread1.ActiveSheetView.Cells[1, 1].Text = "Male";
FpSpread1.ActiveSheetView.Cells[1, 2].Text = "3000 USD";
FpSpread1.ActiveSheetView.Cells[1, 3].Text = "Developer";
FpSpread1.ActiveSheetView.Cells[2, 0].Text = "Cassie";
FpSpread1.ActiveSheetView.Cells[2, 1].Text = "FeMale";
FpSpread1.ActiveSheetView.Cells[2, 2].Text = "3200 USD";
FpSpread1.ActiveSheetView.Cells[2, 3].Text = "Teacher";
FpSpread1.ActiveSheetView.Cells[3, 0].Text = "Mary";
FpSpread1.ActiveSheetView.Cells[3, 1].Text = "FeMale";
FpSpread1.ActiveSheetView.Cells[3, 2].Text = "2700 USD";
FpSpread1.ActiveSheetView.Cells[3, 3].Text = "Accountant";
}
protected void Button1_Click(object sender, EventArgs e)
{
// クライアント側の変更を確定します
FpSpread1.SaveChanges();
// グループ化を行います
FarPoint.Web.Spread.Model.GroupDataModel gm = new FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.ActiveSheetView.DataModel);
FarPoint.Web.Spread.SortInfo[] sort = new FarPoint.Web.Spread.SortInfo[1];
sort[0] = new FarPoint.Web.Spread.SortInfo(1, true);
gm.Group(sort);
FpSpread1.ActiveSheetView.DataModel = gm;
}
{
if (IsPostBack)
{
return;
}
FpSpread1.ActiveSheetView.ColumnCount = 4;
FpSpread1.ActiveSheetView.RowCount = 4;
// テストデータを設定します
FpSpread1.ActiveSheetView.Cells[0, 0].Text = "Jack";
FpSpread1.ActiveSheetView.Cells[0, 1].Text = "Male";
FpSpread1.ActiveSheetView.Cells[0, 2].Text = "3000 USD";
FpSpread1.ActiveSheetView.Cells[0, 3].Text = "Teacher";
FpSpread1.ActiveSheetView.Cells[1, 0].Text = "Tommy";
FpSpread1.ActiveSheetView.Cells[1, 1].Text = "Male";
FpSpread1.ActiveSheetView.Cells[1, 2].Text = "3000 USD";
FpSpread1.ActiveSheetView.Cells[1, 3].Text = "Developer";
FpSpread1.ActiveSheetView.Cells[2, 0].Text = "Cassie";
FpSpread1.ActiveSheetView.Cells[2, 1].Text = "FeMale";
FpSpread1.ActiveSheetView.Cells[2, 2].Text = "3200 USD";
FpSpread1.ActiveSheetView.Cells[2, 3].Text = "Teacher";
FpSpread1.ActiveSheetView.Cells[3, 0].Text = "Mary";
FpSpread1.ActiveSheetView.Cells[3, 1].Text = "FeMale";
FpSpread1.ActiveSheetView.Cells[3, 2].Text = "2700 USD";
FpSpread1.ActiveSheetView.Cells[3, 3].Text = "Accountant";
}
protected void Button1_Click(object sender, EventArgs e)
{
// クライアント側の変更を確定します
FpSpread1.SaveChanges();
// グループ化を行います
FarPoint.Web.Spread.Model.GroupDataModel gm = new FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.ActiveSheetView.DataModel);
FarPoint.Web.Spread.SortInfo[] sort = new FarPoint.Web.Spread.SortInfo[1];
sort[0] = new FarPoint.Web.Spread.SortInfo(1, true);
gm.Group(sort);
FpSpread1.ActiveSheetView.DataModel = gm;
}
キーワード
グループ化