最終ページのインデックス(全ページ数)を取得したい
対象製品
SPREAD for ASP.NET 8.0J
詳細
GetPageIndex メソッドにて任意の行が表示されるページのインデックスを取得することができますので、GetPageIndex メソッドに最終行(RowCount - 1)を指定することで最終ページのインデックスを取得することができます。
◎サンプルコード(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.RowCount = 101
FpSpread1.ActiveSheetView.PageSize = 15
FpSpread1.Pager.Mode = FarPoint.Web.Spread.PagerMode.Both
FpSpread1.Pager.Position = FarPoint.Web.Spread.PagerPosition.Top
Dim lastpage As Integer
lastpage = FpSpread1.GetPageIndex(FpSpread1.ActiveSheetView.RowCount - 1)
FpSpread1.ActiveSheetView.Cells(1, 1).Value = "ページ数:" + (lastpage + 1).ToString()
End Sub
If IsPostBack Then
Return
End If
FpSpread1.ActiveSheetView.RowCount = 101
FpSpread1.ActiveSheetView.PageSize = 15
FpSpread1.Pager.Mode = FarPoint.Web.Spread.PagerMode.Both
FpSpread1.Pager.Position = FarPoint.Web.Spread.PagerPosition.Top
Dim lastpage As Integer
lastpage = FpSpread1.GetPageIndex(FpSpread1.ActiveSheetView.RowCount - 1)
FpSpread1.ActiveSheetView.Cells(1, 1).Value = "ページ数:" + (lastpage + 1).ToString()
End Sub
◎サンプルコード(C#)
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
FpSpread1.ActiveSheetView.RowCount = 101;
FpSpread1.ActiveSheetView.PageSize = 15;
FpSpread1.Pager.Mode = FarPoint.Web.Spread.PagerMode.Both;
FpSpread1.Pager.Position = FarPoint.Web.Spread.PagerPosition.Top;
int lastpage = 0;
lastpage = FpSpread1.GetPageIndex(FpSpread1.ActiveSheetView.RowCount - 1);
FpSpread1.ActiveSheetView.Cells[1, 1].Value = "ページ数:" + (lastpage + 1).ToString();
}
{
if (IsPostBack)
{
return;
}
FpSpread1.ActiveSheetView.RowCount = 101;
FpSpread1.ActiveSheetView.PageSize = 15;
FpSpread1.Pager.Mode = FarPoint.Web.Spread.PagerMode.Both;
FpSpread1.Pager.Position = FarPoint.Web.Spread.PagerPosition.Top;
int lastpage = 0;
lastpage = FpSpread1.GetPageIndex(FpSpread1.ActiveSheetView.RowCount - 1);
FpSpread1.ActiveSheetView.Cells[1, 1].Value = "ページ数:" + (lastpage + 1).ToString();
}