FarPoint.Web.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	The data.
CellRange	location	The location.
SparklineType	type	The type.
ExcelSparklineSetting	setting	The setting.

Returns

Type	Description
ExcelSparklineGroup

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	The data.
CellRange[]	location	The location.
SparklineType	type	The type.
ExcelSparklineSetting	setting	The setting.

Returns

Type	Description
ExcelSparklineGroup

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	The data reference.
string	locationRef	The location reference.
SparklineType	type	The type.
ExcelSparklineSetting	setting	The setting.

Returns

Type	Description
ExcelSparklineGroup