PowerTools SPREAD for ASP.NET 8.0J
Renderer プロパティ (ExcelSparklineGroup)

レンダラーを取得または設定します。
構文
'Declaration
 
Public Property Renderer As ISparklineRenderer
public ISparklineRenderer Renderer {get; set;}

プロパティ値

レンダラー。
次のサンプルコードは、スパークラインを作成します。
fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 10;
fpSpread1.Sheets[0].SetClip(0, 0, 1, 5, "1\t2\t3\t4\t5");
fpSpread1.Sheets[0].SetClip(1, 0, 1, 5, "5\t4\t3\t2\t1");
fpSpread1.Sheets[0].SetClip(2, 0, 1, 5, "1\t2\t3\t2\t1");

FarPoint.Web.Spread.ExcelSparkline es = new FarPoint.Web.Spread.ExcelSparkline(0, 6, fpSpread1.Sheets[0], new FarPoint.Web.Spread.Model.CellRange(0, 0, 1, 5));
FarPoint.Web.Spread.ExcelSparkline es1 = new FarPoint.Web.Spread.ExcelSparkline(1, 6, fpSpread1.Sheets[0], new FarPoint.Web.Spread.Model.CellRange(1, 0, 1, 5));
FarPoint.Web.Spread.ExcelSparkline es2 = new FarPoint.Web.Spread.ExcelSparkline(2, 6, fpSpread1.Sheets[0], new FarPoint.Web.Spread.Model.CellRange(2, 0, 1, 5));

FarPoint.Web.Spread.ExcelSparklineGroup esg = new FarPoint.Web.Spread.ExcelSparklineGroup();
esg.Setting = new FarPoint.Web.Spread.ExcelSparklineSetting();
esg.Renderer = new FarPoint.Web.Spread.ColumnSparklineRenderer();

esg.Add(es);
esg.Add(es1);
esg.Add(es2);
fpSpread1.Sheets[0].SparklineContainer.Add(esg);
textBox1.Text = fpSpread1.Sheets[0].SparklineContainer.Count.ToString();
textBox2.Text = esg.Count.ToString();
FpSpread1.Sheets(0).RowCount = 10
FpSpread1.Sheets(0).ColumnCount = 10
FpSpread1.Sheets(0).SetClip(0, 0, 1, 5, "1" + Chr(9) + "2" + Chr(9) + "3" + Chr(9) + "4" + Chr(9) + "5")
FpSpread1.Sheets(0).SetClip(1, 0, 1, 5, "5" + Chr(9) + "4" + Chr(9) + "3" + Chr(9) + "2" + Chr(9) + "1")
FpSpread1.Sheets(0).SetClip(2, 0, 1, 5, "1" + Chr(9) + "2" + Chr(9) + "3" + Chr(9) + "2" + Chr(9) + "1")

Dim es As New FarPoint.Web.Spread.ExcelSparkline(0, 6, FpSpread1.Sheets(0), New FarPoint.Web.Spread.Model.CellRange(0, 0, 1, 5))
Dim es1 As New FarPoint.Web.Spread.ExcelSparkline(1, 6, FpSpread1.Sheets(0), New FarPoint.Web.Spread.Model.CellRange(1, 0, 1, 5))
Dim es2 As New FarPoint.Web.Spread.ExcelSparkline(2, 6, FpSpread1.Sheets(0), New FarPoint.Web.Spread.Model.CellRange(2, 0, 1, 5))

Dim esg As New FarPoint.Web.Spread.ExcelSparklineGroup()
esg.Setting = New FarPoint.Web.Spread.ExcelSparklineSetting()
esg.Renderer = New FarPoint.Web.Spread.ColumnSparklineRenderer()

esg.Add(es)
esg.Add(es1)
esg.Add(es2)
FpSpread1.Sheets(0).SparklineContainer.Add(esg)
TextBox1.Text = FpSpread1.Sheets(0).SparklineContainer.Count.ToString()
textBox2.Text = esg.Count.ToString()
参照

ExcelSparklineGroup クラス
ExcelSparklineGroup メンバ

 

 


© 2003-2015, GrapeCity inc. All rights reserved.