Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetDataModel Class / RemoveColumn Method
Index of column to remove
Example


In This Topic
    RemoveColumn Method (DefaultSheetDataModel)
    In This Topic
    Removes a column at the specified position.
    Syntax
    'Declaration
     
    Public Sub RemoveColumn( _
       ByVal column As Integer _
    ) 
    'Usage
     
    Dim instance As DefaultSheetDataModel
    Dim column As Integer
     
    instance.RemoveColumn(column)
    public void RemoveColumn( 
       int column
    )

    Parameters

    column
    Index of column to remove
    Exceptions
    ExceptionDescription
    Specified column is out of range; must be between 0 and total number of columns
    Example
    This example creates a new DefaultSheetDataModel, sets its number of rows and columns in the constructor and attaches it to the DataModel of the active sheet. Data is added to the first cell in the first three columns. In a button click event the RemoveColumn method removes the first column.
    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);
    }
    See Also