FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > IRangeSupport Interface : AddColumns Method |
'Declaration Sub AddColumns( _ ByVal column As Integer, _ ByVal columnCount As Integer _ )
'Usage Dim instance As IRangeSupport Dim column As Integer Dim columnCount As Integer instance.AddColumns(column, columnCount)
void AddColumns( int column, int columnCount )
FarPoint.Win.Spread.Model.IRangeSupport irs; DialogResult dlg; irs = (FarPoint.Win.Spread.Model.IRangeSupport)fpSpread1.ActiveSheet.Models.Data; fpSpread1.ActiveSheet.ColumnCount = 2; fpSpread1.ActiveSheet.RowCount = 2; dlg = MessageBox.Show("Do you want to add some columns and rows?", "AddColumns", MessageBoxButtons.YesNo); if (dlg == DialogResult.Yes) { irs.AddColumns(1, 3); irs.AddRows(1, 3); }
Dim irs As FarPoint.Win.Spread.Model.IRangeSupport Dim dlg As DialogResult irs = FpSpread1.ActiveSheet.Models.Data FpSpread1.ActiveSheet.ColumnCount = 2 FpSpread1.ActiveSheet.RowCount = 2 dlg = MessageBox.Show("Do you want to add some columns and rows?", "AddColumns", MessageBoxButtons.YesNo) If dlg = DialogResult.Yes Then irs.AddColumns(1, 3) irs.AddRows(1, 3) End If
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8