deserialize メソッド

シンタックス

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Pivot.PivotTable(name, sheet, row, col, layout, style);
var value; // Type: any
value = instance.deserialize(serializeInfo,
                             serializeInfo.layoutType,
                             serializeInfo.options,
                             serializeInfo.theme,
                             serializeInfo.valuePosition,
                             serializeInfo.pivotTablePosition,
                             serializeInfo.fieldsInfo,
                             serializeInfo.styles,
                             serializeInfo.collapseItems);

function deserialize( 
   serializeInfo : object,
   (optional) serializeInfo.layoutType : PivotTableLayoutType,
   (optional) serializeInfo.options : object,
   (optional) serializeInfo.theme : string,
   (optional) serializeInfo.valuePosition : object,
   (optional) serializeInfo.pivotTablePosition : array,
   (optional) serializeInfo.fieldsInfo : array,
   (optional) serializeInfo.styles : array,
   (optional) serializeInfo.collapseItems : object
) : any;

パラメータ

serializeInfo: シリアル化されたピボットテーブルのデータ。
serializeInfo.layoutType: ピボットテーブルのlayoutType
serializeInfo.options: ピボットテーブルのオプション
serializeInfo.theme: ピボットテーブルのテーマ
serializeInfo.valuePosition: ピボットテーブルのvaluePosition情報
serializeInfo.pivotTablePosition: ピボットテーブルの位置
serializeInfo.fieldsInfo: ピボットテーブルのフィールド情報
serializeInfo.styles: ピボットテーブルのピボットエリアのスタイル
serializeInfo.collapseItems: ピボットテーブルの折りたたみ情報

使用例

Javascript

var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
var sourceSheet = spread.getSheet(0);
var sheet = spread.getSheet(1);
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 pivotTable = sheet.pivotTables.add("pivotTable_1", 'sourceData', 1, 1, layout, theme);
pivotTable.add("Buyer","Buyer",GC.Spread.Pivot.PivotTableFieldType.rowField);
pivotTable.add("Type","Type",GC.Spread.Pivot.PivotTableFieldType.columnField);
pivotTable.add("Amount","Sum of Amount",GC.Spread.Pivot.PivotTableFieldType.valueField, GC.Pivot.SubtotalType.sum);
var serialization = pivotTable.serialize();
pivotTable.remove('Type');
pivotTable.deserialize(serialization);

参照

PivotTable タイプ