FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SpreadDataSource Class : SheetView Property |
'Declaration Public ReadOnly Property SheetView As SheetView
'Usage Dim instance As SpreadDataSource Dim value As SheetView value = instance.SheetView
public SheetView SheetView {get;}
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Value = "UserName"; FpSpread1.Sheets[0].Cells[0, 0].Value = "Test"; FpSpread1.Sheets[0].Cells[1, 0].Value = "Ann"; FpSpread1.Sheets[0].Cells[2, 0].Value = "Doug"; FarPoint.Web.Spread.SpreadDataSource spreadDS = new FarPoint.Web.Spread.SpreadDataSource(); spreadDS.SheetName = FpSpread1.ActiveSheetView.SheetName; spreadDS.SpreadID = "FpSpread1";//FpSpread1.ID; spreadDS.CellRange = new FarPoint.Web.Spread.Model.CellRange(0, 0, 3, 1); spreadDS.SheetView.BackColor = System.Drawing.Color.Pink; //will set backcolor of current sheetview of //FpSpread1 to "Pink" color spreadDS.Spread.Sheets.Count = 3; // will set sheetview count of FpSpread1 to 3
FpSpread1.Sheets(0).ColumnHeader.Cells(0, 0).value = "UserName" FpSpread1.Sheets(0).Cells(0, 0).Value = "Test" FpSpread1.Sheets(0).Cells(1, 0).Value = "Ann" FpSpread1.Sheets(0).Cells(2, 0).Value = "Doug" Dim spreadDS As New FarPoint.Web.Spread.SpreadDataSource() spreadDS.SheetName = FpSpread1.ActiveSheetView.SheetName spreadDS.SpreadID = "FpSpread1" spreadDS.CellRange = New FarPoint.Web.Spread.Model.CellRange(0, 0, 3, 1) Controls.Add(spreadDS) spreadDS.SheetView.BackColor = System.Drawing.Color.Pink spreadDS.Spread.Sheets.Count = 3
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