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'))
pivotField = PivotField(show_compact= True )
request =  PostPivotTableUpdatePivotFieldRequest( 'TestCase.xlsx', 'Sheet4', 0, 0, 'Row', pivotField,need_re_calculate= True,folder= 'PythonTest',storage_name= '')
api.post_pivot_table_update_pivot_field(request)