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: