FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > SheetView クラス : 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
'使用法 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 )
true
。FarPoint.Win.Spread.SheetView sv = new FarPoint.Win.Spread.SheetView(); fpSpread1.Sheets[0] = sv; 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.Win.Spread.Chart.SheetCellRange newdata = new FarPoint.Win.Spread.Chart.SheetCellRange(sv, 4, 0, 2, 2); FarPoint.Win.Spread.Model.CellRange newlocation = new FarPoint.Win.Spread.Model.CellRange(6, 0, 1, 2); FarPoint.Win.Spread.ExcelSparklineSetting ex2 = new FarPoint.Win.Spread.ExcelSparklineSetting(); fpSpread1.Sheets[0].AddSquareSparkline(newdata, newlocation, FarPoint.Win.Spread.SparklineType.Column, ex2, true); )
Dim sv As New FarPoint.Win.Spread.SheetView() FpSpread1.Sheets(0) = sv 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.Win.Spread.Chart.SheetCellRange(sv, 4, 0, 2, 2) Dim newlocation = New FarPoint.Win.Spread.Model.CellRange(6, 0, 1, 2) Dim ex2 As New FarPoint.Win.Spread.ExcelSparklineSetting() FpSpread1.Sheets(0).AddSquareSparkline(newdata, newlocation, FarPoint.Win.Spread.SparklineType.Column, ex2, True)