FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class : RemoveColumn Method |
'Usage Dim instance As DefaultSheetDataModel Dim column As Integer instance.RemoveColumn(column)
Exception | Description |
---|---|
System.ArgumentOutOfRangeException | Specified column is out of range; must be between 0 and total number of columns |
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(0,1,"Second") FpSpread1.ActiveSheetView.SetValue(0,2,"Third") End Sub Private Sub Button1_Click(ByVal sender As Object,ByVal e As System.EventArgs)Handles Button1.Click Dim dm As FarPoint.Web.Spread.Model.DefaultSheetDataModel=FpSpread1.ActiveSheetView.DataModel dm.RemoveColumn(0) End Sub
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(0,1,"Second"); FpSpread1.ActiveSheetView.SetValue(0,2,"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.RemoveColumn(0); }
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6