MESCIUS SPREAD for ASP.NET 10.0J
AddSquareSparkline メソッド

データ。
位置。
型。
設定。
列の場合はtrue
シートのインデックス。
構文
'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

パラメータ

data
データ。
location
位置。
type
型。
setting
設定。
isColumn
列の場合はtrue
次のサンプルコードは、セルにスパークラインを作成します。
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)
参照

SheetView クラス
SheetView メンバ

 

 


© MESCIUS inc. All rights reserved.