/// <summary> /// Add pivot field into into pivot table /// </summary> /// <param name="name">Document name.</param> /// <param name="sheetName">Worksheet name.</param> /// <param name="pivottableIndex">Pivot table index</param> /// <param name="pivotTableFieldRequest">PivotTableFieldRequest object</param> /// <param name="folder">Document folder.</param> /// <param name="storage">The document storage.</param> public void AddPivotFieldIntoIntoPivotTable(string name, string sheetName, int pivotTableIndex, string pivotFieldType, PivotTableFieldRequest pivotTableFieldRequest, string folder, string storage = "") { //put cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotField?appSid={appSid}&storage={storage}&folder={folder}&pivotFieldType={pivotFieldType} string apiUrl = string.Format(@"cells/{0}/worksheets/{1}/pivottables/{2}/PivotField?storage={3}&folder={4}&pivotFieldType={5}", name, sheetName, pivotTableIndex, storage, folder, pivotFieldType); JObject jObject = JObject.Parse(ServiceController.Put(apiUrl, AppSid, AppKey, JsonConvert.SerializeObject(pivotTableFieldRequest))); }
public void Cells_PivotTable_Tests() { try { storageService.File.CopyFile(Utils.CloudStorage_Input_Folder + "/cells-sample.xlsx", Utils.CloudStorage_Output_Folder + "/cells-sample.xlsx"); string name = "cells-sample.xlsx"; PivotTablesResponse pivotTablesResponse = cellsService.PivotTable.GetWorksheetPivottablesInfo(name, "sheet6", Utils.CloudStorage_Output_Folder); PivotTableResponse pivotTableResponse = cellsService.PivotTable.GetWorksheetPivottableInfoByIndex(name, "sheet6", 0, Utils.CloudStorage_Output_Folder); cellsService.PivotTable.DeleteWorksheetPivotTableByIndex(name, "sheet6", 0, Utils.CloudStorage_Output_Folder); cellsService.PivotTable.DeleteWorksheetPivotTables(name, "sheet6", Utils.CloudStorage_Output_Folder); CreatePivotTableRequest createPivotTableRequest = new CreatePivotTableRequest(); createPivotTableRequest.Name = "Test Pivot Table"; createPivotTableRequest.SourceData = "A1:C7"; createPivotTableRequest.DestCellName = "H10"; createPivotTableRequest.UseSameSource = true; createPivotTableRequest.PivotFieldRows = new List<int>(); createPivotTableRequest.PivotFieldRows.Add(1); createPivotTableRequest.PivotFieldColumns = new List<int>(); createPivotTableRequest.PivotFieldColumns.Add(1); createPivotTableRequest.PivotFieldData = new List<int>(); createPivotTableRequest.PivotFieldData.Add(1); cellsService.PivotTable.AddAPivotTableIntoWorksheet(name, "sheet7", createPivotTableRequest, Utils.CloudStorage_Output_Folder); PivotTableFieldRequest pivotTableFieldRequest = new PivotTableFieldRequest(); pivotTableFieldRequest.Data = new List<int>(); pivotTableFieldRequest.Data.Add(1); pivotTableFieldRequest.Data.Add(2); cellsService.PivotTable.AddPivotFieldIntoIntoPivotTable(name, "sheet6", 0, "Row", pivotTableFieldRequest, Utils.CloudStorage_Output_Folder); WorkbookStyleResponse workbookStyleResponse = cellsService.WorksheetColumns.ReadCellStyleInfo(name, "sheet6", "A8", Utils.CloudStorage_Output_Folder); cellsService.PivotTable.UpdateCellStyleForPivotTable(name, "sheet6", 0, 1, 1, workbookStyleResponse.Style, Utils.CloudStorage_Output_Folder); cellsService.PivotTable.UpdateStyleForPivotTable(name, "sheet6", 0, workbookStyleResponse.Style, Utils.CloudStorage_Output_Folder); storageService.File.DownloadFile(Utils.CloudStorage_Output_Folder + "/cells-sample.xlsx", "d:\\cells-sample.xlsx"); } catch (Exception ex) { Assert.Fail(ex.Message); } }