MESCIUS SPREAD for ASP.NET 10.0J
Add メソッド (ExcelSparklineGroup)

ICollectionに追加するオブジェクト。
ICollectionに項目を追加します。
構文
'Declaration
 
Public Sub Add( _
   ByVal item As ISparkline _
) 
public void Add( 
   ISparkline item
)

パラメータ

item
ICollectionに追加するオブジェクト。
例外
例外説明
System.NotSupportedExceptionICollectionは読み取り専用です。
次のサンプルコードは、スパークラインを作成します。
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 メンバ

 

 


© MESCIUS inc. All rights reserved.