Syntax
| 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) |  Copy Code |
|---|---|
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 reference.
- locationRef
- The location reference.
- type
- The type.
- setting
- The setting.
Remarks
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.
Example
This example creates a sparkline in a cell.
| C# | Copy Code |
|---|---|
FarPoint.Web.Spread.ExcelSparklineSetting ex = new FarPoint.Web.Spread.ExcelSparklineSetting(); ex.DisplayXAxis = true; ex.ShowMarkers = true; fpSpread1.Sheets[0].RowCount = 10; fpSpread1.Sheets[0].ColumnCount = 10; 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.Web.Spread.SparklineType.Line, ex); | |
| Visual Basic | Copy Code |
|---|---|
Dim ex As New FarPoint.Web.Spread.ExcelSparklineSetting() ex.DisplayXAxis = True ex.ShowMarkers = True FpSpread1.Sheets(0).RowCount = 10 FpSpread1.Sheets(0).ColumnCount = 10 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.Web.Spread.SparklineType.Line, ex) | |
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