Spread Windows Forms 7.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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Syntax

Parameters

Example

Requirements

See Also

Reference