Spread for ASP.NET 7.0 Product Documentation
ExcelSparkline Constructor(Int32,Int32,String)
See Also Example Support Options

FarPoint.Web.Spread Assembly > FarPoint.Web.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].RowCount = 10; fpSpread1.Sheets[0].ColumnCount = 10; fpSpread1.Sheets[0].SetClip(0, 0, 1, 5, "1\t2\t3\t4\t5"); FarPoint.Web.Spread.ExcelSparkline es = new FarPoint.Web.Spread.ExcelSparkline(0, 5, "Sheet1!$A$1:$E$1"); FarPoint.Web.Spread.ExcelSparklineGroup esg = new FarPoint.Web.Spread.ExcelSparklineGroup(new FarPoint.Web.Spread.ExcelSparklineSetting(), FarPoint.Web.Spread.SparklineType.Column); esg.Add(es); fpSpread1.Sheets[0].SparklineContainer.Add(esg);

Copy Code

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

Visual Basic	Copy Code
FpSpread1.Sheets(0).RowCount = 10 FpSpread1.Sheets(0).ColumnCount = 10 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.Web.Spread.ExcelSparkline(0, 5, "Sheet1!$A$1:$E$1") Dim esg As New FarPoint.Web.Spread.ExcelSparklineGroup(New FarPoint.Web.Spread.ExcelSparklineSetting(), FarPoint.Web.Spread.SparklineType.Column) esg.Add(es) FpSpread1.Sheets(0).SparklineContainer.Add(esg)

Visual Basic

Copy Code

FpSpread1.Sheets(0).RowCount = 10
FpSpread1.Sheets(0).ColumnCount = 10
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.Web.Spread.ExcelSparkline(0, 5, "Sheet1!$A$1:$E$1")
Dim esg As New FarPoint.Web.Spread.ExcelSparklineGroup(New FarPoint.Web.Spread.ExcelSparklineSetting(), FarPoint.Web.Spread.SparklineType.Column)
esg.Add(es)
FpSpread1.Sheets(0).SparklineContainer.Add(esg)

Requirements

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

Syntax

Parameters

Example

Requirements

See Also

Reference