StyleModel Property

Gets or sets the cell types and other style settings for the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Property StyleModel As ISheetStyleModel

'Usage
 
Dim instance As SheetView
Dim value As ISheetStyleModel
 
instance.StyleModel = value
 
value = instance.StyleModel

public ISheetStyleModel StyleModel {get; set;}

Property Value

ISheetStyleModel object containing the cell types and other style settings

Remarks

This property is available at run time only.

Example

The following example creates a sheet with 1000 rows and 7 columns. Alternate rows display a light cyan backcolor, and navy blue, bold text. The fifth row (0 index) is the starting row in the sheet.

FarPoint.Web.Spread.SheetView sv=FpSpread1.ActiveSheetView;
FarPoint.Web.Spread.StyleInfo altrowstyle=new FarPoint.Web.Spread.StyleInfo();
FarPoint.Web.Spread.Model.DefaultSheetStyleModel altrowmodel=new FarPoint.Web.Spread.Model.DefaultSheetStyleModel(1000,7);
sv.ColumnCount=7;
sv.RowCount=1000;
altrowstyle.BackColor=Color.LightCyan;
altrowstyle.ForeColor=Color.Navy;
altrowstyle.Font.Bold=true;
altrowmodel.SetDirectAltRowInfo(1,altrowstyle);
sv.StyleModel=altrowmodel;
sv.TopRow=4;

Visual Basic

Dim sv As FarPoint.Web.Spread.SheetView
Dim altrowstyle As New FarPoint.Web.Spread.StyleInfo()
Dim altrowmodel As New FarPoint.Web.Spread.Model.DefaultSheetStyleModel(1000,7)
sv=FpSpread1.ActiveSheetView
sv.ColumnCount=7
sv.RowCount=1000
altrowstyle.BackColor=Color.LightCyan
altrowstyle.ForeColor=Color.Navy
altrowstyle.Font.Bold=True
altrowmodel.SetDirectAltRowInfo(1,altrowstyle)
sv.StyleModel=altrowmodel
sv.TopRow=4

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SheetView Class
SheetView Members
ISheetStyleModel Interface

User-Task Documentation

Understanding the Style Model