Visual Basic (Declaration) | |
---|---|
Public Overloads Function AddSparkline( _ ByVal dataRef As String, _ ByVal locationRef As String, _ ByVal type As SparklineType, _ ByVal setting As ExcelSparklineSetting _ ) As ExcelSparklineGroup |
Visual Basic (Usage) | ![]() |
---|---|
Dim instance As SheetView Dim dataRef As String Dim locationRef As String Dim type As SparklineType Dim setting As ExcelSparklineSetting Dim value As ExcelSparklineGroup value = instance.AddSparkline(dataRef, locationRef, type, setting) |
C# | |
---|---|
public ExcelSparklineGroup AddSparkline( string dataRef, string locationRef, SparklineType type, ExcelSparklineSetting setting ) |
Parameters
- dataRef
- The data ref.
- locationRef
- The location ref.
- type
- The type.
- setting
- The setting.
The data for the sparkline is limited to one column or row of values. The Dataref parameter is the range of cells that contains the data for the graph. The Locationref is the cell or cells that the sparkline is displayed in.
This example creates a sparkline cell.
C# | ![]() |
---|---|
FarPoint.Win.Spread.ExcelSparklineSetting ex = new FarPoint.Win.Spread.ExcelSparklineSetting(); ex.DisplayXAxis = true; ex.ShowMarkers = true; fpSpread1.Sheets[0].Cells[0, 0].Value = 2; fpSpread1.Sheets[0].Cells[0, 1].Value = 5; fpSpread1.Sheets[0].Cells[0, 2].Value = 4; fpSpread1.Sheets[0].Cells[0, 3].Value = -1; fpSpread1.Sheets[0].Cells[0, 4].Value = 3; fpSpread1.Sheets[0].AddSparkline("Sheet1!$A$1:$E$1", "Sheet1!$A$2:$A$2", FarPoint.Win.Spread.SparklineType.Line, ex); |
Visual Basic | ![]() |
---|---|
Dim ex As New FarPoint.Win.Spread.ExcelSparklineSetting() ex.DisplayXAxis = True ex.ShowMarkers = True FpSpread1.Sheets(0).Cells(0, 0).Value = 2 FpSpread1.Sheets(0).Cells(0, 1).Value = 5 FpSpread1.Sheets(0).Cells(0, 2).Value = 4 FpSpread1.Sheets(0).Cells(0, 3).Value = -1 FpSpread1.Sheets(0).Cells(0, 4).Value = 3 FpSpread1.Sheets(0).AddSparkline("Sheet1!$A$1:$E$1", "Sheet1!$A$2:$A$2", FarPoint.Win.Spread.SparklineType.Line, ex) |
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2