let range = "=Sheet2!A14";
let pivotTable = sheet2.pivotTables.add("ivotTable", range, 0, 0, GC.Spread.Pivot.PivotTableLayoutType.outline, GC.Spread.Pivot.PivotTableThemes.medium2);
let range = "=Sheet2!A1: D4";
let pivotTable = sheet2.pivotTables.add(" PivotTable", range, 0, 0, GC.Spread.Pivot.PivotTableLayoutType.outline, GC.Spread.Pivot.PivotTableThemes.medium2);