Removes columns from the specified starting position.
Syntax
Visual Basic (Usage) | Copy Code |
---|
Dim instance As IRangeSupport
Dim column As Integer
Dim columnCount As Integer
instance.RemoveColumns(column, columnCount) |
Parameters
- column
- Column index at which to start removing columns
- columnCount
- Number of columns to remove
Example
This example removes the specified number of columns and rows.
C# | Copy Code |
---|
FarPoint.Win.Spread.Model.IRangeSupport irs;
DialogResult dlg;
irs = (FarPoint.Win.Spread.Model.IRangeSupport)fpSpread1.ActiveSheet.Models.Data;
dlg = MessageBox.Show("Do you want to remove some columns and rows?", "RemoveColumns/Rows", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
irs.RemoveColumns(3, 496);
irs.RemoveRows(3, 496);
} |
Visual Basic | Copy Code |
---|
Dim irs As FarPoint.Win.Spread.Model.IRangeSupport
Dim dlg As DialogResult
irs = FpSpread1.ActiveSheet.Models.Data
dlg = MessageBox.Show("Do you want to remove some columns and rows?", "RemoveColumns/Rows", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
irs.RemoveColumns(3, 496)
irs.RemoveRows(3, 496)
End If |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also