FarPoint.Win.Spread.SheetView.AddSparkline

AddSparkline Method

AddSparkline(SheetCellRange, CellRange, SparklineType, ExcelSparklineSetting)

Adds the sparkline.

Declaration

public ExcelSparklineGroup AddSparkline(SheetCellRange data, CellRange location, SparklineType type, ExcelSparklineSetting setting)

Public Function AddSparkline(data As SheetCellRange, location As CellRange, type As SparklineType, setting As ExcelSparklineSetting) As ExcelSparklineGroup

Parameters

Type	Name	Description
SheetCellRange	data	Data
CellRange	location	Location for the sparkline
SparklineType	type	Type of sparkline
ExcelSparklineSetting	setting	Setting

Returns

Type	Description
ExcelSparklineGroup	The new created instance of the sparkline group.

AddSparkline(SheetCellRange[], CellRange[], SparklineType, ExcelSparklineSetting)

Adds the sparkline.

Declaration

public ExcelSparklineGroup AddSparkline(SheetCellRange[] data, CellRange[] location, SparklineType type, ExcelSparklineSetting setting)

Public Function AddSparkline(data As SheetCellRange(), location As CellRange(), type As SparklineType, setting As ExcelSparklineSetting) As ExcelSparklineGroup

Parameters

Type	Name	Description
SheetCellRange[]	data	Data
CellRange[]	location	Location of sparkline
SparklineType	type	Type of sparkline
ExcelSparklineSetting	setting	Setting

Returns

Type	Description
ExcelSparklineGroup	The new created instance of the sparkline group.

AddSparkline(string, string, SparklineType, ExcelSparklineSetting)

Adds the sparkline.

Declaration

public ExcelSparklineGroup AddSparkline(string dataRef, string locationRef, SparklineType type, ExcelSparklineSetting setting)

Public Function AddSparkline(dataRef As String, locationRef As String, type As SparklineType, setting As ExcelSparklineSetting) As ExcelSparklineGroup

Parameters

Type	Name	Description
string	dataRef	Data reference
string	locationRef	Location reference
SparklineType	type	Type of sparkline
ExcelSparklineSetting	setting	Setting

Returns

Type	Description
ExcelSparklineGroup	The new created instance of the sparkline group.