const { CellsApi, UploadFileRequest, CellsPivotTables_PutWorksheetPivotTableRequest } = 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_PutWorksheetPivotTableRequest();
          req.name = filename;
          req.sheetName = "Sheet4";
          req.request = null;
          req.folder = "Temp";
          req.sourceData = "Sheet1!C6:E13";
          req.destCellName = "C1";
          req.tableName = "TestPivot";
          req.useSameSource = true;
    cellsApi.cellsPivotTablesPutWorksheetPivotTable(req)
     .then((result) => {
        console.log("successful")

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