Example_PostPivotTableUpdatePivotFields.py

import os
import sys
from asposecellscloud.apis.cells_api import CellsApi
from asposecellscloud.models import *
from asposecellscloud.requests import *

api  = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
remote_folder = 'TestData/In'

local_name = 'TestCase.xlsx'
remote_name = 'TestCase.xlsx'

pivotField = PivotField(show_compact= True )
mapFiles = { 
    local_name:  local_name             
}
request =  UploadFileRequest( mapFiles, remote_folder + '/' + remote_name,storage_name= '')
api.upload_file(request)
 
request =  PostPivotTableUpdatePivotFieldsRequest( remote_name, 'Sheet4', 0, 'Row', pivotField,need_re_calculate= True,folder= remote_folder,storage_name= '')
api.post_pivot_table_update_pivot_fields(request)