如何使用Javascript API在Excel中创建数据透视表

<script src="https://appsforoffice.microsoft.com/lib/1/hosted/office.js" type="text/javascript"></script>

Office.initialize = function() {
    Excel.run(function(context) {
        // 在这里编写创建数据透视表的代码
        return context.sync();
    });
};

var workbook = context.workbook;
workbook.open();

var worksheet = workbook.worksheets.getActiveWorksheet();
var dataRange = worksheet.getRange("A1:D10");
var pivotTable = worksheet.pivotTables.add("E1", dataRange, "MyPivotTable");

pivotTable.properties.rowFields.add("Category");
pivotTable.properties.columnFields.add("Month");
pivotTable.properties.values.add("Sales", "Sum");

pivotTable.refresh();

Office.initialize = function() {
    Excel.run(function(context) {
        var workbook = context.workbook;
        workbook.open();

        var worksheet = workbook.worksheets.getActiveWorksheet();
        var dataRange = worksheet.getRange("A1:D10");
        var pivotTable = worksheet.pivotTables.add("E1", dataRange, "MyPivotTable");

        pivotTable.properties.rowFields.add("Category");
        pivotTable.properties.columnFields.add("Month");
        pivotTable.properties.values.add("Sales", "Sum");

        pivotTable.refresh();

        return context.sync();
    });
};