def test_cells_pivot_tables_put_pivot_table_field(self):
"""
Test case for cells_pivot_tables_put_pivot_table_field
Add pivot field into into pivot table
"""
name = 'TestCase.xlsx'
sheet_name = 'Sheet4'
pivotTableIndex = 0
pivotFieldType = "row"
request = PivotTableFieldRequest()
request.data = [1]
folder = "PythonTest"
result = AuthUtil.Ready(self.api, name, folder)
self.assertTrue(len(result.uploaded) > 0)
result = self.api.cells_pivot_tables_put_pivot_table_field(
name,
sheet_name,
pivotTableIndex,
pivotFieldType,
request=request,
need_re_calculate=True,
folder=folder)
self.assertEqual(result.code, 200)
pass
def test_cells_pivot_tables_delete_worksheet_pivot_table(self):
"""
Test case for cells_pivot_tables_delete_worksheet_pivot_table
Delete worksheet pivot table by index
"""
name = 'TestCase.xlsx'
sheet_name = 'Sheet4'
pivotTableIndex = 0
pivotFieldType = "row"
request = PivotTableFieldRequest()
request.data = [1]
folder = "Temp"
AuthUtil.Ready(name, folder)
result = self.api.cells_pivot_tables_delete_worksheet_pivot_table(
name, sheet_name, pivotTableIndex, folder=folder)
pass
def test_cells_pivot_tables_delete_worksheet_pivot_table(self):
"""
Test case for cells_pivot_tables_delete_worksheet_pivot_table
Delete worksheet pivot table by index
"""
name ='TestCase.xlsx'
sheet_name ='Sheet4'
pivotTableIndex = 0
pivotFieldType = "row"
request = PivotTableFieldRequest()
request.data = [1]
folder = "PythonTest"
result = AuthUtil.Ready(self.api, name, folder)
self.assertTrue(len(result.uploaded)>0)
result = self.api.cells_pivot_tables_delete_worksheet_pivot_table(name, sheet_name, pivotTableIndex, folder=folder)
self.assertEqual(result.code,200)
pass
def test_cells_pivot_tables_delete_pivot_table_field(self):
"""
Test case for cells_pivot_tables_delete_pivot_table_field
Delete pivot field into into pivot table
"""
name = 'TestCase.xlsx'
sheet_name = 'Sheet4'
pivotTableIndex = 0
pivotFieldType = "row"
request = PivotTableFieldRequest()
request.data = [1]
folder = "Temp"
AuthUtil.Ready(name, folder)
result = self.api.cells_pivot_tables_delete_pivot_table_field(
name,
sheet_name,
pivot_table_index=pivotTableIndex,
pivot_field_type=pivotFieldType,
request=request,
folder=folder)
pass
def test_cells_pivot_tables_put_pivot_table_field(self):
"""
Test case for cells_pivot_tables_put_pivot_table_field
Add pivot field into into pivot table
"""
name = 'TestCase.xlsx'
sheet_name = 'Sheet4'
pivotTableIndex = 0
pivotFieldType = "row"
request = PivotTableFieldRequest()
request.data = [1]
folder = "Temp"
AuthUtil.Ready(name, folder)
result = self.api.cells_pivot_tables_put_pivot_table_field(
name,
sheet_name,
pivotTableIndex,
pivotFieldType,
request=request,
need_re_calculate=True,
folder=folder)
pass
data_folder = "../../data/"
#Instantiate Aspose Storage API SDK
storage_apiClient = asposestoragecloud.ApiClient.ApiClient(apiKey, appSid, True)
storageApi = StorageApi(storage_apiClient)
#Instantiate Aspose Cells API SDK
api_client = asposecellscloud.ApiClient.ApiClient(apiKey, appSid, True)
cellsApi = CellsApi(api_client);
#set input file name
filename = "Sample_Pivot_Table_Example.xls"
sheetName = "Sheet2"
pivotTableIndex = 0
pivotFieldType = "Row"
body = PivotTableFieldRequest.PivotTableFieldRequest()
body.Data = [1,2]
#upload file to aspose cloud storage
storageApi.PutCreate(Path=filename, file=data_folder + filename)
try:
#invoke Aspose.Cells Cloud SDK API to add pivot field into pivot table
response = cellsApi.PutPivotTableField(name=filename, sheetName=sheetName, pivotTableIndex=pivotTableIndex, pivotFieldType=pivotFieldType, body=body)
if response.Status == "OK":
#download Workbook from storage server
response = storageApi.GetDownload(Path=filename)
outfilename = "c:/temp/" + filename
with open(outfilename, 'wb') as f:
for chunk in response.InputStream: