Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / AddSquareSparkline Method
The data.
The location.
The type.
The setting.
if set to true [is column].
Example


In This Topic
    AddSquareSparkline Method
    In This Topic
    Adds the sparkline.
    Syntax
    '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].
    Example
    This example creates a sparkline in a cell.
    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);
    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)
    See Also