SpreadJS製品ヘルプ
add メソッド
GC.Spread.Sheets 名前空間 > PivotTableManager タイプ : add メソッド
シンタックス
var instance = new GC.Spread.Sheets.PivotTableManager(sheet);
var value; // Type: PivotTable
value = instance.add(name,
                     sourceData,
                     row,
                     col,
                     layout,
                     theme,
                     options,
                     options.allowMultipleFiltersPerField,
                     options.insertBlankLineAfterEachItem,
                     options.grandTotalPosition,
                     options.subTotalsPosition,
                     options.displayFieldsInPageFilterArea,
                     options.reportFilterFieldsPerColumn,
                     options.bandRows,
                     options.bandColumns,
                     options.showRowHeader,
                     options.showColumnHeader,
                     options.showDrill,
                     options.showMissing,
                     options.missingCaption,
                     options.fillDownLabels,
                     options.rowLabelIndent,
                     options.printDrill,
                     options.itemPrintTitles,
                     options.fieldPrintTitles,
                     options.showFilter,
                     options.showToolTip,
                     options.mergeItem);
function add( 
   name : string,
   sourceData : string,
   row : number,
   col : number,
   layout : PivotTableLayoutType,
   theme : PivotTableTheme,
   options : Object,
   (optional) options.allowMultipleFiltersPerField : boolean,
   (optional) options.insertBlankLineAfterEachItem : boolean,
   (optional) options.grandTotalPosition : GrandTotalPosition,
   (optional) options.subTotalsPosition : SubtotalsPosition,
   (optional) options.displayFieldsInPageFilterArea : DisplayFields,
   (optional) options.reportFilterFieldsPerColumn : number,
   (optional) options.bandRows : boolean,
   (optional) options.bandColumns : boolean,
   (optional) options.showRowHeader : boolean,
   (optional) options.showColumnHeader : boolean,
   (optional) options.showDrill : boolean,
   (optional) options.showMissing : boolean,
   (optional) options.missingCaption : boolean,
   (optional) options.fillDownLabels : boolean,
   (optional) options.rowLabelIndent : boolean,
   (optional) options.printDrill : boolean,
   (optional) options.itemPrintTitles : boolean,
   (optional) options.fieldPrintTitles : boolean,
   (optional) options.showFilter : boolean,
   (optional) options.showToolTip : boolean,
   (optional) options.mergeItem : boolean
) : PivotTable;

パラメータ

name
sourceData
row
col
layout
theme
options
options.allowMultipleFiltersPerField
options.insertBlankLineAfterEachItem
options.grandTotalPosition
options.subTotalsPosition
options.displayFieldsInPageFilterArea
options.reportFilterFieldsPerColumn
options.bandRows
options.bandColumns
options.showRowHeader
options.showColumnHeader
options.showDrill
options.showMissing
options.missingCaption
options.fillDownLabels
options.rowLabelIndent
options.printDrill
options.itemPrintTitles
options.fieldPrintTitles
options.showFilter
options.showToolTip
options.mergeItem
関連トピック

参照

PivotTableManager タイプ