Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / ExcelSparkline Class / Row Property
Example


In This Topic
    Row Property (ExcelSparkline)
    In This Topic
    Gets or sets the row.
    Syntax
    'Declaration
     
    Public Overrides Property Row As Integer
    'Usage
     
    Dim instance As ExcelSparkline
    Dim value As Integer
     
    instance.Row = value
     
    value = instance.Row
    public override int Row {get; set;}

    Property Value

    The row.
    Example
    This example creates sparklines.
    fpSpread1.Sheets[0].RowCount = 10;
    fpSpread1.Sheets[0].ColumnCount = 10;
    fpSpread1.Sheets[0].SetClip(0, 0, 1, 5, "1\t2\t3\t4\t5");
    FarPoint.Web.Spread.ExcelSparkline es = new FarPoint.Web.Spread.ExcelSparkline(0, 5, fpSpread1.Sheets[0], new FarPoint.Web.Spread.Model.CellRange(0, 0, 1, 5));
    FarPoint.Web.Spread.ExcelSparklineGroup esg = new FarPoint.Web.Spread.ExcelSparklineGroup(new FarPoint.Web.Spread.ExcelSparklineSetting(), FarPoint.Web.Spread.SparklineType.Column);
    esg.Add(es);
    fpSpread1.Sheets[0].SparklineContainer.Add(esg);
    
    FarPoint.Web.Spread.ExcelSparklineGroup esg1 = (FarPoint.Web.Spread.ExcelSparklineGroup)fpSpread1.Sheets[0].SparklineContainer[0];
    FarPoint.Web.Spread.ExcelSparkline es1 = (FarPoint.Web.Spread.ExcelSparkline)esg1[0];
    es1.Column = 6;
    es1.Row = 3;
    FpSpread1.Sheets(0).RowCount = 10
    FpSpread1.Sheets(0).ColumnCount = 10
    fpSpread1.Sheets(0).SetClip(0, 0, 1, 5, "1" & vbTab & "2" & vbTab & "3" & vbTab & "4" & vbTab & "5")
    Dim es As New FarPoint.Web.Spread.ExcelSparkline(0, 5, fpSpread1.Sheets(0), New FarPoint.Web.Spread.Model.CellRange(0, 0, 1, 5))
    Dim esg As New FarPoint.Web.Spread.ExcelSparklineGroup(New FarPoint.Web.Spread.ExcelSparklineSetting(), FarPoint.Web.Spread.SparklineType.Column)
    esg.Add(es)
    fpSpread1.Sheets(0).SparklineContainer.Add(esg)
    
    Dim esg1 As FarPoint.Web.Spread.ExcelSparklineGroup = DirectCast(fpSpread1.Sheets(0).SparklineContainer(0), FarPoint.Web.Spread.ExcelSparklineGroup)
    Dim es1 As FarPoint.Web.Spread.ExcelSparkline = DirectCast(esg1(0), FarPoint.Web.Spread.ExcelSparkline)
    es1.Column = 6
    es1.Row = 3
    See Also