FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > WorksheetTemplate Class : Remove Method |
'Usage Dim instance As WorksheetTemplate Dim index As Integer Dim count As Integer instance.Remove(index, count)
protected void Page_Load(object sender, EventArgs e) { if (this.IsPostBack) return; FarPoint.Web.Spread.Model.DefaultSheetDataModel dm = new FarPoint.Web.Spread.Model.DefaultSheetDataModel(10, 10); FpSpread1.ActiveSheetView.DataModel = dm; FpSpread1.ActiveSheetView.LayoutMode = FarPoint.Web.Spread.SheetView.LayoutModeType.RowTemplateLayoutMode; FarPoint.Web.Spread.WorksheetTemplate template1; template1 = FpSpread1.Sheets[0].WorksheetTemplate; template1.ColumnCount = 3; template1.ColumnHeaderTemplate.RowCount = 2; template1.RowTemplate.RowCount = 2; template1.LayoutColumns[1].Width = 250; //Set row template's layout template1.RowTemplate.LayoutCells[1, 1].ColumnSpan = 2; //set column header template's layout template1.ColumnHeaderTemplate.LayoutCells[0, 0].RowSpan = 2; template1.ColumnHeaderTemplate.LayoutCells[1, 1].ColumnSpan = 2; //Add or Remove a template column //template1.Add(0, 1); //template1.Remove(0, 1); template1.LayoutDataModel = dm; }
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load, Me.Load If (IsPostBack) Then Return End If Dim dm As New FarPoint.Web.Spread.Model.DefaultSheetDataModel(10, 10) FpSpread1.ActiveSheetView.DataModel = dm FpSpread1.ActiveSheetView.LayoutMode = FarPoint.Web.Spread.SheetView.LayoutModeType.RowTemplateLayoutMode Dim template1 As FarPoint.Web.Spread.WorksheetTemplate template1 = FpSpread1.Sheets(0).WorksheetTemplate template1.ColumnCount = 3 template1.ColumnHeaderTemplate.RowCount = 2 template1.RowTemplate.RowCount = 2 template1.LayoutColumns(1).Width = 250 'Set row template's layout template1.RowTemplate.LayoutCells(1, 1).ColumnSpan = 2 'set column header template's layout template1.ColumnHeaderTemplate.LayoutCells(0, 0).RowSpan = 2 template1.ColumnHeaderTemplate.LayoutCells(1, 1).ColumnSpan = 2 'Add or Remove a template column 'template1.Add(0, 1); 'template1.Remove(0, 1); template1.LayoutDataModel = dm End Sub
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