AddSquareSparkline Method

Visual Basic
C#

'Declaration
 
Public Function AddSquareSparkline( _
   ByVal data As SheetCellRange, _
   ByVal location As CellRange, _
   ByVal type As SparklineType, _
   ByVal setting As ExcelSparklineSetting, _
   ByVal isColumn As Boolean _
) As ExcelSparklineGroup

'Usage
 
Dim instance As SheetView
Dim data As SheetCellRange
Dim location As CellRange
Dim type As SparklineType
Dim setting As ExcelSparklineSetting
Dim isColumn As Boolean
Dim value As ExcelSparklineGroup
 
value = instance.AddSquareSparkline(data, location, type, setting, isColumn)

public ExcelSparklineGroup AddSquareSparkline( 
   SheetCellRange data,
   CellRange location,
   SparklineType type,
   ExcelSparklineSetting setting,
   bool isColumn
)

Parameters

data: The data.
location: The location.
type: The type.
setting: The setting.
isColumn: if set to true [is column].

This example creates a sparkline in a cell.

C#

FarPoint.Web.Spread.SheetView sv = new FarPoint.Web.Spread.SheetView();
fpSpread1.Sheets[0] = sv;
fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 10;
sv.Cells[4, 0].Value = 2;
sv.Cells[4, 1].Value = 1;
sv.Cells[5, 0].Value = 5;
sv.Cells[5, 1].Value = 3;
FarPoint.Web.Spread.Chart.SheetCellRange newdata = new FarPoint.Web.Spread.Chart.SheetCellRange(sv, 4, 0, 2, 2);
FarPoint.Web.Spread.Model.CellRange newlocation = new FarPoint.Web.Spread.Model.CellRange(6, 0, 1, 2);
FarPoint.Web.Spread.ExcelSparklineSetting ex2 = new FarPoint.Web.Spread.ExcelSparklineSetting();
fpSpread1.Sheets[0].AddSquareSparkline(newdata, newlocation, FarPoint.Web.Spread.SparklineType.Column, ex2, true);

Visual Basic

Dim sv As New FarPoint.Web.Spread.SheetView()
FpSpread1.Sheets(0) = sv
FpSpread1.Sheets(0).RowCount = 10
FpSpread1.Sheets(0).ColumnCount = 10
sv.Cells(4, 0).Value = 2
sv.Cells(4, 1).Value = 1
sv.Cells(5, 0).Value = 5
sv.Cells(5, 1).Value = 3
Dim newdata = New FarPoint.Web.Spread.Chart.SheetCellRange(sv, 4, 0, 2, 2)
Dim newlocation = New FarPoint.Web.Spread.Model.CellRange(6, 0, 1, 2)
Dim ex2 As New FarPoint.Web.Spread.ExcelSparklineSetting()
FpSpread1.Sheets(0).AddSquareSparkline(newdata, newlocation, FarPoint.Web.Spread.SparklineType.Column, ex2, True)

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