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); } }
public void CellsPivotTablesDeletePivotTableFieldTest() { string name = "TestCase.xlsx"; string sheetName = "SHEET4"; int? pivotTableIndex = 0; string pivotFieldType = "row"; PivotTableFieldRequest request = new PivotTableFieldRequest(); request.Data = new List <int?> { 1 }; string folder = "TEMPFOLDER"; new Config().UpdateDataFile(folder, name); var response = instance.CellsPivotTablesDeletePivotTableField(name, sheetName, pivotTableIndex, pivotFieldType, request, folder); Console.WriteLine(response); }
static void Main() { string dataDir = Common.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); string input = "sample1.xlsx"; string output = "output.xlsx"; Common.StorageService.File.UploadFile(dataDir + input, input, storage: Common.STORAGE); string sheetName = "Sheet1"; PivotTableFieldRequest pivotTableFieldRequest = new PivotTableFieldRequest(); pivotTableFieldRequest.Data = new System.Collections.Generic.List <int>(); pivotTableFieldRequest.Data.Add(1); pivotTableFieldRequest.Data.Add(1); Common.CellsService.PivotTable.AddPivotFieldIntoIntoPivotTable(input, sheetName, 0, "Row", pivotTableFieldRequest, Common.FOLDER, storage: Common.STORAGE); Common.StorageService.File.DownloadFile(input, dataDir + output, storage: Common.STORAGE); }
public void CellsPivotTablesDeletePivotTableFieldTest() { // TODO uncomment below to test the method and replace null with proper value string name = PivTestFile; string sheetName = SHEET4; int? pivotTableIndex = 0; string pivotFieldType = "row"; PivotTableFieldRequest request = new PivotTableFieldRequest(); request.Data = new List <int?> { 1 }; string folder = TEMPFOLDER; UpdateDataFile(instance, folder, name); var response = instance.CellsPivotTablesDeletePivotTableField(name, sheetName, pivotTableIndex, pivotFieldType, request, folder); Assert.IsInstanceOf <CellsCloudResponse>(response, "response is CellsCloudResponse"); Assert.AreEqual(response.Code, 200); }