Spread Windows Forms 6.0 Product Documentation
ExcelSparkline Constructor(Int32,Int32,String)
See Also Example Support Options

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > ExcelSparkline Class > ExcelSparkline Constructor : ExcelSparkline Constructor(Int32,Int32,String)

Visual Basic (Declaration)
Visual Basic (Usage)
C#

row: The row.

column: The column.

formula: The formula that represents the sheet cell range.

Initializes a new instance of the ExcelSparkline class.

Syntax

Visual Basic (Declaration)
Public Function New( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal formula As String _ )

Visual Basic (Usage)	Copy Code
Dim row As Integer Dim column As Integer Dim formula As String Dim instance As New ExcelSparkline(row, column, formula)

C#
public ExcelSparkline( int row, int column, string formula )

Parameters

row: The row.
column: The column.
formula: The formula that represents the sheet cell range.

Example

This example creates sparklines.

C#	Copy Code
fpSpread1.Sheets[0].SetClip(0, 0, 1, 5, "1\t2\t3\t4\t5"); FarPoint.Win.Spread.ExcelSparkline es = new FarPoint.Win.Spread.ExcelSparkline(0, 5, "Sheet1!$A$1:$E$1"); FarPoint.Win.Spread.ExcelSparklineGroup esg = new FarPoint.Win.Spread.ExcelSparklineGroup(new FarPoint.Win.Spread.ExcelSparklineSetting(), FarPoint.Win.Spread.SparklineType.Column); esg.Add(es); fpSpread1.Sheets[0].SparklineContainer.Add(esg);

Copy Code

fpSpread1.Sheets[0].SetClip(0, 0, 1, 5, "1\t2\t3\t4\t5");
FarPoint.Win.Spread.ExcelSparkline es = new FarPoint.Win.Spread.ExcelSparkline(0, 5, "Sheet1!$A$1:$E$1");
FarPoint.Win.Spread.ExcelSparklineGroup esg = new FarPoint.Win.Spread.ExcelSparklineGroup(new FarPoint.Win.Spread.ExcelSparklineSetting(), FarPoint.Win.Spread.SparklineType.Column);
esg.Add(es);
fpSpread1.Sheets[0].SparklineContainer.Add(esg);

Visual Basic	Copy Code
FpSpread1.Sheets(0).SetClip(0, 0, 1, 5, "1" + Chr(9) + "2" + Chr(9) + "3" + Chr(9) + "4" + Chr(9) + "5") Dim es As New FarPoint.Win.Spread.ExcelSparkline(0, 5, "Sheet1!$A$1:$E$1") Dim esg As New FarPoint.Win.Spread.ExcelSparklineGroup(New FarPoint.Win.Spread.ExcelSparklineSetting(), FarPoint.Win.Spread.SparklineType.Column) esg.Add(es) FpSpread1.Sheets(0).SparklineContainer.Add(esg)

Visual Basic

Copy Code

FpSpread1.Sheets(0).SetClip(0, 0, 1, 5, "1" + Chr(9) + "2" + Chr(9) + "3" + Chr(9) + "4" + Chr(9) + "5")
Dim es As New FarPoint.Win.Spread.ExcelSparkline(0, 5, "Sheet1!$A$1:$E$1")
Dim esg As New FarPoint.Win.Spread.ExcelSparklineGroup(New FarPoint.Win.Spread.ExcelSparklineSetting(), FarPoint.Win.Spread.SparklineType.Column)
esg.Add(es)
FpSpread1.Sheets(0).SparklineContainer.Add(esg)

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Syntax

Parameters

Example

Requirements

See Also

Reference