position メソッド

シンタックス

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Pivot.PivotTable(name, sheet, row, col, layout, style);
var value; // Type: any
value = instance.position(row, col, sheetName);

function position( 
   (optional) row : number,
   (optional) col : number,
   (optional) sheetName : string
) : any;

パラメータ

row: ピボットテーブルの開始行を示します。
col: ピボットテーブルの開始列を示します。
sheetName: ピボットテーブルが配置されているシート。

使用例

Javascript

var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
var sourceSheet = spread.getSheet(0);
var sheet = spread.getSheet(1);
var toSheet = spread.getSheet(2);
var sourceData = [["Date","Buyer","Type","Amount"],
                  ["01-Jan","Mom","Fuel",74],
                  ["15-Jan","Mom","Food",235],
                  ["17-Jan","Dad","Sports",20],
                  ["21-Jan","Kelly","Books",125]];
sourceSheet.setArray(0, 0, sourceData );
sourceSheet.tables.add('sourceData', 0, 0, 5, 4);
var layout = GC.Spread.Pivot.PivotTableLayoutType.compact;
var theme = GC.Spread.Pivot.PivotTableThemes.medium2;
var options = {showRowHeader: true, showColumnHeader: true};
var pivotTable = sheet.pivotTables.add("pivotTable_1", 'sourceData', 1, 1, layout, theme, options);
pivotTable.position(10,10,toSheet.name());
pivotTable.position(); //{row:10,col:10, sheetName: "Sheet3"}

参照

PivotTable タイプ