const { CellsApi, UploadFileRequest, CellsPivotTables_PutPivotTableFieldRequest, PivotTableFieldRequest } = require("asposecellscloud");
const clientId = process.env.CellsCloudClientId;
const clientSecret = process.env.CellsCloudClientSecret;
const ApiURL = process.env.CellsCloudApiBaseUrl;
const fs = require('fs');
const path = require('path');
const cellsApi = new CellsApi(clientId, clientSecret,"v3.0",ApiURL);
const localPath = "D:/aspose-cells-cloud-node/TestData/"

const filename = "Book1.xlsx";
const data =fs.createReadStream(path.join(localPath, filename));

const req = new UploadFileRequest({
  path: "Temp/" + filename,
  file: data
});
cellsApi.uploadFile(req)
  .then((result) => {

    const req = new CellsPivotTables_PutPivotTableFieldRequest();
          req.name = filename;
          req.sheetName = "Sheet4";
          req.pivotTableIndex = 0;
          req.pivotFieldType = "Row";
          const request = new PivotTableFieldRequest();
          req.request.data = [1];
          req.needReCalculate = null;
          req.folder = "Temp";
    cellsApi.cellsPivotTablesPutPivotTableField(req)
     .then((result) => {
        console.log("successful")

       }).catch((error) => {
    console.error('Unhandled Promise Rejection:', error);
  })
  })