'Usage Dim instance As DefaultSheetDataModel Dim row As Integer Dim count As Integer instance.RemoveRows(row, count)
Parameters
- row
- Index of first row to remove
- count
- Number of rows to remove
'Usage Dim instance As DefaultSheetDataModel Dim row As Integer Dim count As Integer instance.RemoveRows(row, count)
Exception | Description |
---|---|
System.ArgumentOutOfRangeException | Specified row is out of range; must be between 0 and total number of rows |
System.ArgumentOutOfRangeException | Specified number of rows is out of range; must be between 1 and total number of rows beyond the specified starting row |
private void Page_Load(object sender,System.EventArgs e) { if(this.IsPostBack)return; FarPoint.Web.Spread.Model.DefaultSheetDataModel dm=new FarPoint.Web.Spread.Model.DefaultSheetDataModel(8,8); FpSpread1.ActiveSheetView.DataModel=dm; FpSpread1.ActiveSheetView.SetValue(0,0,"First"); FpSpread1.ActiveSheetView.SetValue(1,0,"Second"); FpSpread1.ActiveSheetView.SetValue(2,0,"Third"); } private void Button1_Click(object sender,System.EventArgs e) { FarPoint.Web.Spread.Model.DefaultSheetDataModel dm=(FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel; dm.RemoveRows(0,2); }
Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load If(Me.IsPostBack)Then Return Dim dm As New FarPoint.Web.Spread.Model.DefaultSheetDataModel(8,8) FpSpread1.ActiveSheetView.DataModel=dm FpSpread1.ActiveSheetView.SetValue(0,0,"First") FpSpread1.ActiveSheetView.SetValue(1,0,"Second") FpSpread1.ActiveSheetView.SetValue(2,0,"Third") End Sub PrivateSubButton1_Click(ByValsenderAsObject,ByValeAsSystem.EventArgs)HandlesButton1.Click DimdmAsFarPoint.Web.Spread.Model.DefaultSheetDataModel=FpSpread1.ActiveSheetView.DataModel dm.RemoveRows(0,2) EndSub