Last active
November 8, 2021 02:58
-
-
Save aspose-cloud/af3fea45644d431483f6df52cf3bfe26 to your computer and use it in GitHub Desktop.
This Gist repository contains code snippet related to Aspose.Cells Cloud SDK for Java
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Aspose.Cells-Cloud-SDK-Java |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try{ | |
ListeCellsApi api = new ListeCellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String AssemblyTestXlsx = "assemblytest.xlsx"; | |
String DataSourceXlsx = "datasource.xlsx"; | |
HashMap<String,File> fileMap = new HashMap<String,File>(); | |
fileMap.put(AssemblyTestXlsx , new File("C:\\TestData\\" + AssemblyTestXlsx)); | |
fileMap.put(DataSourceXlsx , new File("C:\\TestData\\" + DataSourceXlsx) ); | |
FilesResult response = api.postAssemble(fileMap, "ds","xlsx"); | |
} catch (ApiException e) { | |
// TODO Auto-generated catch block | |
e.printStackTrace(); | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try{ | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
BatchConvertRequest batchConvertRequest = new BatchConvertRequest(); | |
batchConvertRequest.setFormat ("pdf") ; | |
batchConvertRequest.setSourceFolder(BatchFolder); | |
MatchConditionRequest matchConditionRequest = new MatchConditionRequest(); | |
List<String> sheetnameList=new ArrayList<>(); | |
sheetnameList.add("Book1.xlsx"); | |
sheetnameList.add("myDocument.xlsx"); | |
matchConditionRequest.setFullMatchConditions(sheetnameList); | |
batchConvertRequest.setMatchCondition(matchConditionRequest); | |
File response = api.postBatchConvert(batchConvertRequest); | |
} catch (ApiException e) { | |
// TODO Auto-generated catch block | |
e.printStackTrace(); | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try{ | |
ListeCellsApi api = new ListeCellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String AssemblyTestXlsx = "assemblytest.xlsx"; | |
String DataSourceXlsx = "datasource.xlsx"; | |
HashMap<String,File> fileMap = new HashMap<String,File>(); | |
fileMap.put(AssemblyTestXlsx , new File("C:\\TestData\\" + AssemblyTestXlsx)); | |
fileMap.put(DataSourceXlsx , new File("C:\\TestData\\" + DataSourceXlsx) ); | |
FilesResult response = api.postClearObjects(fileMap, "chart"); | |
} catch (ApiException e) { | |
// TODO Auto-generated catch block | |
e.printStackTrace(); | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = "Book1.xlsx"; | |
String folder = "Temp"; | |
MatchConditionRequest matchConditionRequest = new MatchConditionRequest(); | |
matchConditionRequest.addFullMatchConditionsItem("Sheet1"); | |
matchConditionRequest.addFullMatchConditionsItem("Sheet2"); | |
CellsCloudResponse response = api.cellsWorksheetsDeleteWorksheets(name,matchConditionRequest , folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try{ | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = "Book1.xlsx"; | |
String sheetName = "Sheet6"; | |
Integer shapeindex = 0; | |
String folder = "Temp"; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
api.cellsShapesDeleteWorksheetShape(name, sheetName, shapeindex, folder,null); | |
} catch (ApiException e) { | |
// TODO Auto-generated catch block | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = "Book1.xlsx"; | |
String sheetName = "Sheet1"; | |
String folder = "Temp"; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsShapesDeleteWorksheetShapes(name, sheetName, folder,null); | |
} catch (Exception e) { | |
//TODO: handle exception | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try{ | |
ListeCellsApi api = new ListeCellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String AssemblyTestXlsx = "assemblytest.xlsx"; | |
String DataSourceXlsx = "datasource.xlsx"; | |
HashMap<String,File> fileMap = new HashMap<String,File>(); | |
fileMap.put(AssemblyTestXlsx , new File("C:\\TestData\\" + AssemblyTestXlsx)); | |
fileMap.put(DataSourceXlsx , new File("C:\\TestData\\" + DataSourceXlsx) ); | |
FilesResult response = api.postExport(fileMap, "chart","png"); | |
} catch (ApiException e) { | |
// TODO Auto-generated catch block | |
e.printStackTrace(); | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = "Book1.xlsx"; | |
String sheetName = "Sheet6"; | |
Integer shapeindex = 0; | |
String folder = "Temp"; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
ShapeResponse response = api.cellsShapesGetWorksheetShape(name, sheetName, shapeindex, folder,null); | |
} catch (Exception e) { | |
//TODO: handle exception | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = "Book1.xlsx"; | |
String sheetName = "Sheet1"; | |
String folder = "Temp"; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
ShapesResponse response = api.cellsShapesGetWorksheetShapes(name, sheetName, folder,null); | |
} catch (Exception e) { | |
//TODO: handle exception | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try{ | |
ListeCellsApi api = new ListeCellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String AssemblyTestXlsx = "assemblytest.xlsx"; | |
String DataSourceXlsx = "datasource.xlsx"; | |
HashMap<String,File> fileMap = new HashMap<String,File>(); | |
fileMap.put(AssemblyTestXlsx , new File("C:\\TestData\\" + AssemblyTestXlsx)); | |
fileMap.put(DataSourceXlsx , new File("C:\\TestData\\" + DataSourceXlsx) ); | |
FileInfo response = api.postMerge(fileMap,"png",true); | |
} catch (ApiException e) { | |
// TODO Auto-generated catch block | |
e.printStackTrace(); | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try{ | |
ListeCellsApi api = new ListeCellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String AssemblyTestXlsx = "assemblytest.xlsx"; | |
String DataSourceXlsx = "datasource.xlsx"; | |
HashMap<String,File> fileMap = new HashMap<String,File>(); | |
fileMap.put(AssemblyTestXlsx , new File("C:\\TestData\\" + AssemblyTestXlsx)); | |
fileMap.put(DataSourceXlsx , new File("C:\\TestData\\" + DataSourceXlsx) ); | |
FilesResult response = api.deleteMetadata(fileMap, "ALL"); | |
} catch (ApiException e) { | |
// TODO Auto-generated catch block | |
e.printStackTrace(); | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try{ | |
ListeCellsApi api = new ListeCellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String AssemblyTestXlsx = "assemblytest.xlsx"; | |
String DataSourceXlsx = "datasource.xlsx"; | |
HashMap<String,File> fileMap = new HashMap<String,File>(); | |
fileMap.put(AssemblyTestXlsx , new File("C:\\TestData\\" + AssemblyTestXlsx)); | |
fileMap.put(DataSourceXlsx , new File("C:\\TestData\\" + DataSourceXlsx) ); | |
List<CellsDocumentProperty> response = api.getMetadata(fileMap, "ALL"); | |
} catch (ApiException e) { | |
// TODO Auto-generated catch block | |
e.printStackTrace(); | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try{ | |
ListeCellsApi api = new ListeCellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String AssemblyTestXlsx = "assemblytest.xlsx"; | |
String DataSourceXlsx = "datasource.xlsx"; | |
HashMap<String,File> fileMap = new HashMap<String,File>(); | |
fileMap.put(AssemblyTestXlsx , new File("C:\\TestData\\" + AssemblyTestXlsx)); | |
fileMap.put(DataSourceXlsx , new File("C:\\TestData\\" + DataSourceXlsx) ); | |
CellsDocumentProperty[] cellsDocumentProperties = new CellsDocumentProperty[1]; | |
CellsDocumentProperty cellsDocumentProperty = new CellsDocumentProperty(); | |
cellsDocumentProperty.setName ( "test"); | |
cellsDocumentProperty.setValue ( "test"); | |
cellsDocumentProperties[0] =cellsDocumentProperty; | |
FilesResult response = api.postMetadata(fileMap, cellsDocumentProperties); | |
} catch (ApiException e) { | |
// TODO Auto-generated catch block | |
e.printStackTrace(); | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = "Book1.xlsx"; | |
String sheetName = "Sheet6"; | |
Integer shapeindex = 0; | |
Shape dto = new Shape(); | |
dto.setLowerRightColumn(10); | |
String folder = "Temp"; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsShapesPostWorksheetShape(name, sheetName, shapeindex, dto, folder, null); | |
} catch (Exception e) { | |
//TODO: handle exception | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try{ | |
ListeCellsApi api = new ListeCellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String AssemblyTestXlsx = "assemblytest.xlsx"; | |
String DataSourceXlsx = "datasource.xlsx"; | |
HashMap<String,File> fileMap = new HashMap<String,File>(); | |
fileMap.put(AssemblyTestXlsx , new File("C:\\TestData\\" + AssemblyTestXlsx)); | |
fileMap.put(DataSourceXlsx , new File("C:\\TestData\\" + DataSourceXlsx) ); | |
FilesResult response = api.postProtect(fileMap,"123456"); | |
} catch (ApiException e) { | |
// TODO Auto-generated catch block | |
e.printStackTrace(); | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = "Book1.xlsx"; | |
String sheetName = "Sheet1"; | |
String drawingType = "button"; | |
Integer upperLeftRow = 1; | |
Integer upperLeftColumn = 1; | |
Integer top = 10; | |
Integer left = 10; | |
Integer width = 100; | |
Integer height = 90; | |
String folder = "Temp"; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
ShapeResponse response = api.cellsShapesPutWorksheetShape(name, sheetName,null, drawingType, upperLeftRow, upperLeftColumn, top, left, width, height, folder,null); | |
} catch (Exception e) { | |
//TODO: handle exception | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try{ | |
ListeCellsApi api = new ListeCellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String AssemblyTestXlsx = "assemblytest.xlsx"; | |
String DataSourceXlsx = "datasource.xlsx"; | |
HashMap<String,File> fileMap = new HashMap<String,File>(); | |
fileMap.put(AssemblyTestXlsx , new File("C:\\TestData\\" + AssemblyTestXlsx)); | |
fileMap.put(DataSourceXlsx , new File("C:\\TestData\\" + DataSourceXlsx) ); | |
File response = api.postSearch(fileMap,"123456",null,null,null,null); | |
System.out.println(response.toString()) ; | |
} catch (ApiException e) { | |
// TODO Auto-generated catch block | |
e.printStackTrace(); | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try{ | |
ListeCellsApi api = new ListeCellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String AssemblyTestXlsx = "assemblytest.xlsx"; | |
String DataSourceXlsx = "datasource.xlsx"; | |
HashMap<String,File> fileMap = new HashMap<String,File>(); | |
fileMap.put(AssemblyTestXlsx , new File("C:\\TestData\\" + AssemblyTestXlsx)); | |
fileMap.put(DataSourceXlsx , new File("C:\\TestData\\" + DataSourceXlsx) ); | |
FilesResult response = api.postSplit(fileMap,"xlsx",null,null,null,null,null); | |
} catch (ApiException e) { | |
// TODO Auto-generated catch block | |
e.printStackTrace(); | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try{ | |
ListeCellsApi api = new ListeCellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String needUnlock = "needUnlock.xlsx"; | |
HashMap<String,File> fileMap = new HashMap<String,File>(); | |
fileMap.put(needUnlock , new File("C:\\TestData\\" + needUnlock)); | |
FilesResult response = api.postUnlock(fileMap,"123456"); | |
} catch (ApiException e) { | |
// TODO Auto-generated catch block | |
e.printStackTrace(); | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try{ | |
ListeCellsApi api = new ListeCellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String AssemblyTestXlsx = "assemblytest.xlsx"; | |
String DataSourceXlsx = "datasource.xlsx"; | |
HashMap<String,File> fileMap = new HashMap<String,File>(); | |
fileMap.put(AssemblyTestXlsx , new File("C:\\TestData\\" + AssemblyTestXlsx)); | |
fileMap.put(DataSourceXlsx , new File("C:\\TestData\\" + DataSourceXlsx) ); | |
FilesResult response = api.postWatermark(fileMap,"123456","#fff"); | |
} catch (ApiException e) { | |
// TODO Auto-generated catch block | |
e.printStackTrace(); | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer index = 0; | |
String cellArea = CELLAREA; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsConditionalFormattingsPutWorksheetFormatConditionArea(name, sheetName, index, cellArea, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer index = 0; | |
String cellArea = CELLAREA; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsConditionalFormattingsPutWorksheetFormatConditionArea(name, sheetName, index, cellArea, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer index = 0; | |
String cellArea = CELLAREA; | |
String type ="CellValue"; | |
String operatorType ="Between"; | |
String formula1 = "v1"; | |
String formula2 = "v2"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsConditionalFormattingsPutWorksheetFormatCondition(name, sheetName, index, cellArea, type, operatorType, formula1, formula2, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellName = CellName; | |
Style style = new Style(); | |
Font font = new Font(); | |
font.setSize(10); | |
style.setFont(font); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
StyleResponse response = api.cellsPostUpdateWorksheetCellStyle(name, sheetName, cellName, style, folder,null); | |
Assert.assertEquals("cellsPostUpdateWorksheetCellStyleTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsConditionalFormattingsDeleteWorksheetConditionalFormattings(name, sheetName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String range = RANGE; | |
Integer startRow = 1; | |
Integer startColumn = 2; | |
Integer endRow = 10; | |
Integer endColumn = 7; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPostClearContents(name, sheetName, range, startRow, startColumn, endRow, endColumn, folder,null); | |
Assert.assertEquals("cellsPostClearContentsTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String range = RANGE; | |
Integer startRow = 1; | |
Integer startColumn = 1; | |
Integer endRow = 7; | |
Integer endColumn = 6; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPostClearFormats(name, sheetName, range, startRow, startColumn, endRow, endColumn, folder,null); | |
Assert.assertEquals("cellsPostClearFormatsTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
ConditionalFormattingsResponse response = api.cellsConditionalFormattingsGetWorksheetConditionalFormattings(name, sheetName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
ConditionalFormattingsResponse response = api.cellsConditionalFormattingsGetWorksheetConditionalFormattings(name, sheetName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellName = "A1"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
StyleResponse response = api.cellsGetWorksheetCellStyle(name, sheetName, cellName, folder,null); | |
Assert.assertEquals("cellsGetWorksheetCellStyleTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "A1"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
Object response = api.cellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "endcell"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
Object response = api.cellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "firstcell"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
Object response = api.cellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "maxcolumn"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
Object response = api.cellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "maxdatacolumn"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
Object response = api.cellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "maxdatarow"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
Object response = api.cellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "maxrow"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
Object response = api.cellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer mergedCellIndex = 1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
MergedCellResponse response = api.cellsWorksheetsGetWorksheetMergedCell(name, sheetName, mergedCellIndex, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "mincolumn"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
Object response = api.cellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "mindatacolumn"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
Object response = api.cellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "mindatarow"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
Object response = api.cellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "minrow"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
Object response = api.cellsGetWorksheetCell(name, sheetName, cellOrMethodName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Range range = new Range(); | |
range.setFirstColumn(1); | |
range.setFirstRow(1); | |
range.setColumnCount(1); | |
range.setRowCount(10); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsRangesPostWorksheetCellsRangeMerge(name, sheetName, range, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer startRow = 1; | |
Integer startColumn = 1; | |
Integer totalRows = 4; | |
Integer totalColumns = 6; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsConditionalFormattingsDeleteWorksheetConditionalFormattingArea(name, sheetName, startRow, startColumn, totalRows, totalColumns, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer index = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsConditionalFormattingsDeleteWorksheetConditionalFormatting(name, sheetName, index, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellName = CellName; | |
String value = "2018-08-28"; | |
String type = "Date"; | |
String formula = "=Now()"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellResponse response = api.cellsPostWorksheetCellSetValue(name, sheetName, cellName, value, type, null, folder,null); | |
Assert.assertEquals("cellsPostWorksheetCellSetValueTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellName = CellName; | |
String value = "2018-08-28"; | |
String type = "Date"; | |
String formula = "=Now()"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellResponse response = api.cellsPostWorksheetCellSetValue(name, sheetName, cellName, value, type, formula, folder,null); | |
Assert.assertEquals("cellsPostWorksheetCellSetValueTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
Integer firstRow = 0; | |
Integer firstColumn = 0; | |
Integer rowCount = 3; | |
Integer columnCount = 2; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
RangeValueResponse response = api.cellsRangesGetWorksheetCellsRangeValue(name, sheetName, null, firstRow, firstColumn, rowCount, columnCount, folder,null); | |
assertTrue(response.getCellsList().size() > 0); | |
String rangeName = "A1:B3"; | |
response = api.cellsRangesGetWorksheetCellsRangeValue(name, sheetName, rangeName, null, null, null, null, folder,null); | |
rangeName = "Name_2"; | |
response = api.cellsRangesGetWorksheetCellsRangeValue(name, sheetName, rangeName, null, null, null, null, folder,null); | |
assertTrue(response.getCellsList().size() > 0); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Range range = new Range(); | |
range.setFirstColumn(1); | |
range.setFirstRow(1); | |
range.setColumnCount(1); | |
range.setRowCount(10); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsRangesPostWorksheetCellsRangeUnmerge(name, sheetName, range, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
String chartType ="Pie"; | |
Integer upperLeftRow = 5; | |
Integer upperLeftColumn = 5; | |
Integer lowerRightRow = 10; | |
Integer lowerRightColumn = 10; | |
String area = "C7:D11"; | |
Boolean isVertical = true; | |
String categoryData = null; | |
Boolean isAutoGetSerialName = null; | |
String title = null; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
ChartsResponse response = api.cellsChartsPutWorksheetAddChart(name, sheetName, chartType, upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn, area, isVertical, categoryData, isAutoGetSerialName, title, folder,null,null,null,null,null); | |
} catch (Exception ex) { | |
ex.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartNumber = 0; | |
String format = "png"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
File response = api.cellsChartsGetWorksheetChart(name, sheetName, chartNumber, format, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsChartsDeleteWorksheetClearCharts(name, sheetName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsChartsDeleteWorksheetChartTitle(name, sheetName, chartIndex, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
ChartsResponse response = api.cellsChartsDeleteWorksheetDeleteChart(name, sheetName, chartIndex, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartNumber = 0; | |
String format = "png"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
File response = api.cellsChartsGetWorksheetChart(name, sheetName, chartNumber, format, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
ChartAreaResponse response = api.cellsChartAreaGetChartArea(name, sheetName, chartIndex, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
FillFormatResponse response = api.cellsChartAreaGetChartAreaFillFormat(name, sheetName, chartIndex, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
LegendResponse response = api.cellsChartsGetWorksheetChartLegend(name, sheetName, chartIndex, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsChartsDeleteWorksheetChartLegend(name, sheetName, chartIndex, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
Title title = new Title(); | |
title.setText("test"); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
TitleResponse response = api.cellsChartsPutWorksheetChartTitle(name, sheetName, chartIndex, title, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsChartsPutWorksheetChartLegend(name, sheetName, chartIndex, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
Legend legend = new Legend(); | |
legend.setWidth(0); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
LegendResponse response = api.cellsChartsPostWorksheetChartLegend(name, sheetName, chartIndex, legend, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
Title title = new Title(); | |
title.setText("test"); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
TitleResponse response = api.cellsChartsPutWorksheetChartTitle(name, sheetName, chartIndex, title, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-android/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer rowIndex = 1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
RowResponse response = api.cellsPutInsertWorksheetColumns(name, sheetName, rowIndex, folder,null); | |
Assert.assertEquals("cellsPutInsertWorksheetColumns is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-android/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String password = null; | |
Boolean isAutoFit = true; | |
Boolean onlySaveTable = true; | |
String format = "XPS"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
File response = api.cellsWorkbookGetWorkbook(name, password, format, isAutoFit, onlySaveTable, folder, null, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-android/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer sourceRowIndex = 1; | |
Integer destinationRowIndex = 1; | |
Integer rowNumber = 1; | |
String worksheet = SHEET2; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPostCopyWorksheetColumns(name, sheetName, sourceRowIndex, destinationRowIndex, rowNumber, worksheet, folder,null); | |
Assert.assertEquals("cellsPostCopyWorksheetColumns is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-android/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer rowIndex = 1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsDeleteWorksheetColumn(name, sheetName, rowIndex, folder,null); | |
Assert.assertEquals("cellsDeleteWorksheetColumn is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-android/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer rowIndex = 1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
RowResponse response = api.cellsGetWorksheetColumn(name, sheetName, rowIndex, folder,null); | |
Assert.assertEquals("cellsGetWorksheetColumn is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-android/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer firstIndex = 1; | |
Integer lastIndex = 1; | |
Boolean hide = true; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPostGroupWorksheetColumnns(name, sheetName, firstIndex, lastIndex, hide, folder,null); | |
Assert.assertEquals("cellsPostGroupWorksheetColumnns is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-android/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer startrow = 1; | |
Integer totalRows = 1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPostHideWorksheetColumns(name, sheetName, startrow, totalRows, folder,null); | |
Assert.assertEquals("cellsPostHideWorksheetColumns is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-android/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer firstIndex = 1; | |
Integer lastIndex = 10; | |
Boolean isAll = true; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPostUngroupWorksheetColumns(name, sheetName, firstIndex, lastIndex, isAll, folder,null); | |
Assert.assertEquals("cellsPostUngroupWorksheetColumns is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-android/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer startrow = 1; | |
Integer totalRows = 1; | |
Double height = 10.0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPostUnhideWorksheetColumns(name, sheetName, startrow, totalRows, height, folder,null); | |
Assert.assertEquals("cellsPostUnhideWorksheetColumns is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public static final String clientSecret = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxx"; | |
public static final String clientId = "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
try | |
{ | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String range = RANGE; | |
Integer fieldIndex = 0; | |
String dateTimeGroupingType = "Day"; | |
Integer year = 2010; | |
Integer month = 10; | |
Integer day = 1; | |
Integer hour = 1; | |
Integer minute = 1; | |
Integer second = 1; | |
Boolean matchBlanks = true; | |
Boolean refresh = null; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsAutoFilterPutWorksheetDateFilter(name, sheetName, range, fieldIndex, dateTimeGroupingType, year, month, day, hour, minute, second, matchBlanks, refresh, folder,null); | |
} | |
catch (Exception ex) | |
{ | |
ex.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
try | |
{ | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String range = RANGE; | |
Integer fieldIndex = 0; | |
String criteria = "test"; | |
Boolean matchBlanks = true; | |
Boolean refresh = true; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsAutoFilterPutWorksheetFilter(name, sheetName, range, fieldIndex, criteria, matchBlanks, refresh, folder,null); | |
} | |
catch (Exception ex) | |
{ | |
ex.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String range = RANGE; | |
Integer fieldIndex = 0; | |
String iconSetType = "None"; | |
Integer iconId = 0; | |
Boolean matchBlanks = null; | |
Boolean refresh = null; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsAutoFilterPutWorksheetIconFilter(name, sheetName, range, fieldIndex, iconSetType, iconId, matchBlanks, refresh, folder,null); | |
} catch (Exception ex) { | |
ex.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
try | |
{ | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer fieldIndex = 1; | |
String criteria = "test"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsAutoFilterDeleteWorksheetFilter(name, sheetName, fieldIndex, criteria, folder,null); | |
} | |
catch (Exception ex) | |
{ | |
ex.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-slides/Aspose.Cells-for-Cloud | |
try | |
{ | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer fieldIndex = 1; | |
String dateTimeGroupingType = "Day"; | |
Integer year = 2010; | |
Integer month = 10; | |
Integer day = 1; | |
Integer hour = 1; | |
Integer minute = 1; | |
Integer second = 1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsAutoFilterDeleteWorksheetDateFilter(name, sheetName, fieldIndex, dateTimeGroupingType, year, month, day, hour, minute, second, folder,null); | |
} | |
catch (Exception ex) | |
{ | |
ex.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-slides/Aspose.Cells-for-Cloud | |
try | |
{ | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String range = RANGE; | |
Integer fieldIndex = 0; | |
String operatorType1 = "LessOrEqual"; | |
String criteria1 = "test"; | |
Boolean isAnd = false; | |
String operatorType2 = "LessOrEqual"; | |
String criteria2 = "test"; | |
Boolean matchBlanks = true; | |
Boolean refresh = false; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsAutoFilterPutWorksheetCustomFilter(name, sheetName, range, fieldIndex, operatorType1, criteria1, isAnd, operatorType2, criteria2, matchBlanks, refresh, folder,null); | |
} | |
catch (Exception ex) | |
{ | |
ex.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-slides/Aspose.Cells-for-Cloud | |
try | |
{ | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String range = RANGE; | |
Integer fieldIndex = 0; | |
String dynamicFilterType = "May"; | |
Boolean matchBlanks = true; | |
Boolean refresh = true; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsAutoFilterPutWorksheetDynamicFilter(name, sheetName, range, fieldIndex, dynamicFilterType, matchBlanks, refresh, folder,null); | |
} | |
catch (Exception ex) | |
{ | |
ex.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-slides/Aspose.Cells-for-Cloud | |
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String range = RANGE; | |
Integer fieldIndex = 0; | |
Boolean isTop = true; | |
Boolean isPercent = true; | |
Integer itemCount = 1; | |
Boolean matchBlanks = null; | |
Boolean refresh = null; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsAutoFilterPutWorksheetFilterTop10(name, sheetName, range, fieldIndex, isTop, isPercent, itemCount, matchBlanks, refresh, folder,null); | |
} catch (Exception ex) { | |
ex.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
try | |
{ | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
AutoFilterResponse response = api.cellsAutoFilterGetWorksheetAutoFilter(name, sheetName, folder,null); | |
} | |
catch (Exception ex) | |
{ | |
ex.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer fieldIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsAutoFilterPostWorksheetMatchBlanks(name, sheetName, fieldIndex, folder,null); | |
} catch (Exception ex) { | |
ex.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer fieldIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsAutoFilterPostWorksheetMatchNonBlanks(name, sheetName, fieldIndex, folder,null); | |
} catch (Exception ex) { | |
ex.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsAutoFilterPostWorksheetAutoFilterRefresh(name, sheetName, folder,null); | |
} catch (Exception ex) { | |
ex.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer firstRow = 1; | |
Integer firstColumn = 1; | |
Integer totalRows = 2; | |
Integer totalColumns = 3; | |
String address = "http://wwww.aspose.com"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
HyperlinkResponse response = api.cellsHypelinksPutWorksheetHyperlink(name, sheetName, firstRow, firstColumn, totalRows, totalColumns, address, folder,null); | |
Assert.assertEquals("cellsHypelinksPutWorkSheetHyperlinkTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer hyperlinkIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsHypelinksDeleteWorksheetHyperlink(name, sheetName, hyperlinkIndex, folder,null); | |
Assert.assertEquals("cellsHypelinksDeleteWorkSheetHyperlinkTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer hyperlinkIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
HyperlinkResponse response = api.cellsHypelinksGetWorksheetHyperlink(name, sheetName, hyperlinkIndex, folder,null); | |
Assert.assertEquals("cellsHypelinksGetWorkSheetHyperlinkTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer hyperlinkIndex = 0; | |
Hyperlink hyperlink = new Hyperlink(); | |
hyperlink.setAddress( "http://www.aspose.com"); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
HyperlinkResponse response = api.cellsHypelinksPostWorksheetHyperlink(name, sheetName, hyperlinkIndex, hyperlink, folder,null); | |
Assert.assertEquals("cellsHypelinksPostWorkSheetHyperlinkTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Integer shapeindex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
ShapeResponse response = api.GetWorksheetAutoshapeWithFormat(name, sheetName, shapeindex, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
OleObject oleObject = null; | |
Integer upperLeftRow = 1; | |
Integer upperLeftColumn = 1; | |
Integer height = 100; | |
Integer width = 10; | |
String oleFile = "OLEDoc.docx"; | |
String imageFile = "word.jpg"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsApiUtil.Upload(api, folder,imageFile); | |
CellsApiUtil.Upload(api,folder, oleFile); | |
OleObjectResponse response = api.cellsOleObjectsPutWorksheetOleObject( | |
name, sheetName, oleObject, upperLeftRow, upperLeftColumn, | |
height, width, folder+"/"+oleFile, folder+"/"+imageFile, folder, null); | |
Assert.assertEquals("cellsOleObjectsPutWorksheetOleObjectTest is OK.", | |
"OK", response.getStatus()) | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Integer objectNumber = 0; | |
String format = 'png'; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
File response = api.cellsOleObjectsGetWorksheetOleObject(name,sheetName, objectNumber, format, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsOleObjectsDeleteWorksheetOleObjects(name, sheetName,folder, null); | |
Assert.assertEquals( "cellsOleObjectsDeleteWorksheetOleObjectsTest is OK.", "OK",response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Integer oleObjectIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api .cellsOleObjectsDeleteWorksheetOleObject(name, sheetName, oleObjectIndex, folder, null); | |
Assert.assertEquals( "cellsOleObjectsDeleteWorksheetOleObjectTest is OK.", "OK", response.getStatus()); | |
} catch (Exception ex) { | |
ex.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Integer oleObjectIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsOleObjectsDeleteWorksheetOleObject(name, sheetName, oleObjectIndex, folder, null); | |
Assert.assertEquals("cellsOleObjectsDeleteWorksheetOleObjectTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Integer objectNumber = 0; | |
String format = null; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
File response = api.cellsOleObjectsGetWorksheetOleObject(name, sheetName, objectNumber, format, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Integer oleObjectIndex = 0; | |
OleObject ole = new OleObject(); | |
ole.setLeft(10); | |
ole.setTop(10); | |
ole.setHeight(100); | |
ole.setWidth(90); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsOleObjectsPostUpdateWorksheetOleObject(name, sheetName,oleObjectIndex, ole, folder, null); | |
Assert.assertEquals( "cellsOleObjectsPostUpdateWorksheetOleObjectTest is OK.", "OK",response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Picture picture = null; | |
Integer upperLeftRow = 1; | |
Integer upperLeftColumn = 1; | |
Integer lowerRightRow = 10; | |
Integer lowerRightColumn = 10; | |
String picturePath = "WaterMark.png"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsApiUtil.Upload( api,folder ,picturePath); | |
PicturesResponse response = api.cellsPicturesPutWorksheetAddPicture(name, sheetName, picture, upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn, folder +"/"+ picturePath, folder,null); | |
Assert.assertEquals("cellsPicturesPutWorksheetAddPictureTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
String format = null; | |
Integer pictureNumber = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
File response = api.cellsPicturesGetWorksheetPicture(name, sheetName, pictureNumber,format, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPicturesDeleteWorksheetPictures(name, sheetName, folder,null); | |
Assert.assertEquals("cellsPicturesDeleteWorksheetPictures is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Integer pictureIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPicturesDeleteWorksheetPicture(name, sheetName, pictureIndex, folder,null); | |
Assert.assertEquals("cellsPicturesDeleteWorksheetPictureTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
String format = null; | |
Integer pictureNumber = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
File response = api.cellsPicturesGetWorksheetPicture(name, sheetName, pictureNumber,format, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Integer pictureIndex = 0; | |
Picture picture = new Picture(); | |
picture.setLeft(10); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
PictureResponse response = api.cellsPicturesPostWorksheetPicture(name, sheetName, pictureIndex, picture, folder,null); | |
Assert.assertEquals("cellsPicturesPostWorkSheetPictureTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name =PivTestFile;; | |
String sheetName = SHEET4; | |
Integer pivotTableIndex = 0; | |
String pivotFieldType = "Row"; | |
PivotTableFieldRequest request = new PivotTableFieldRequest(); | |
List<Integer> data = new ArrayList<Integer>(); | |
data.add(1); | |
request.setData(data); | |
Boolean needReCalculate = null; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPivotTablesPutPivotTableField(name, sheetName, pivotTableIndex, pivotFieldType, request, needReCalculate, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name =PivTestFile;; | |
String sheetName = SHEET4; | |
Integer pivotTableIndex = 0; | |
String pivotFieldType = "Row"; | |
PivotTableFieldRequest request = new PivotTableFieldRequest(); | |
List<Integer> data = new ArrayList<Integer>(); | |
data.add(1); | |
request.setData(data); | |
Boolean needReCalculate = true; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPivotTablesPutPivotTableField(name, sheetName, pivotTableIndex, pivotFieldType, request, needReCalculate, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name =PivTestFile;; | |
String sheetName = SHEET4; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPivotTablesDeleteWorksheetPivotTables(name, sheetName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name =PivTestFile;; | |
String sheetName = SHEET4; | |
Integer pivotTableIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPivotTablesDeleteWorksheetPivotTable(name, sheetName, pivotTableIndex, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name =PivTestFile;; | |
String sheetName = SHEET4; | |
Integer pivottableIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
PivotTableResponse response = api.cellsPivotTablesGetWorksheetPivotTable(name, sheetName, pivottableIndex, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name =PivTestFile;; | |
String sheetName = SHEET4; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
PivotTablesResponse response = api.cellsPivotTablesGetWorksheetPivotTables(name, sheetName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name =PivTestFile;; | |
String sheetName = SHEET4; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
PivotTablesResponse response = api.cellsPivotTablesGetWorksheetPivotTables(name, sheetName, folder,null); | |
} catch (Exception ex) { | |
ex.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsDocumentPropertiesResponse response = api.cellsPropertiesGetDocumentProperties(name, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String propertyName ="Author"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsDocumentPropertyResponse response = api.cellsPropertiesGetDocumentProperty(name, propertyName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsDocumentPropertiesResponse response = api.cellsPropertiesDeleteDocumentProperties(name, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String propertyName = "Author"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsDocumentPropertiesResponse response = api.cellsPropertiesDeleteDocumentProperty(name, propertyName, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String propertyName ="Name"; | |
CellsDocumentProperty property = new CellsDocumentProperty(); | |
property.setName("Name"); | |
property.setValue("Roy"); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsDocumentPropertyResponse response = api.cellsPropertiesPutDocumentProperty(name, propertyName, property, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer rowIndex = 1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
RowResponse response = api.cellsPutInsertWorksheetRow(name, sheetName, rowIndex, folder,null); | |
Assert.assertEquals("cellsPutInsertWorksheetRowTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String password = null; | |
Boolean isAutoFit = true; | |
Boolean onlySaveTable = true; | |
String format = "XPS"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
File response = api.cellsWorkbookGetWorkbook(name, password, format,isAutoFit, onlySaveTable, folder, null, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer sourceRowIndex = 1; | |
Integer destinationRowIndex = 1; | |
Integer rowNumber = 1; | |
String worksheet = SHEET2; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPostCopyWorksheetRows(name, sheetName, sourceRowIndex, destinationRowIndex, rowNumber, worksheet, folder,null); | |
Assert.assertEquals("cellsPostCopyWorksheetRowsTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer rowIndex = 1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsDeleteWorksheetRow(name, sheetName, rowIndex, folder,null); | |
Assert.assertEquals("cellsDeleteWorksheetRowTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer rowIndex = 1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
RowResponse response = api.cellsGetWorksheetRow(name, sheetName, rowIndex, folder,null); | |
Assert.assertEquals("cellsGetWorksheetRowTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer firstIndex = 1; | |
Integer lastIndex = 1; | |
Boolean hide = true; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPostGroupWorksheetRows(name, sheetName, firstIndex, lastIndex, hide, folder,null); | |
Assert.assertEquals("cellsPostGroupWorksheetRowsTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer startrow = 1; | |
Integer totalRows = 1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPostHideWorksheetRows(name, sheetName, startrow, totalRows, folder,null); | |
Assert.assertEquals("cellsPostHideWorksheetRowsTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer firstIndex = 1; | |
Integer lastIndex = 10; | |
Boolean isAll = true; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPostUngroupWorksheetRows(name, sheetName, firstIndex, lastIndex, isAll, folder,null); | |
Assert.assertEquals("cellsPostUngroupWorksheetRowsTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer startrow = 1; | |
Integer totalRows = 1; | |
Double height = 10.0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsPostUnhideWorksheetRows(name, sheetName, startrow, totalRows, height, folder,null); | |
Assert.assertEquals("cellsPostUnhideWorksheetRowsTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String text = "test"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
TextItemsResponse response = api.cellsWorkbookPostWorkbooksTextSearch( name, text, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String text = "123456"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
TextItemsResponse response = api.cellsWorksheetsPostWorksheetTextSearch(name, sheetName, text, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String text = "test"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
TextItemsResponse response = api.cellsWorkbookPostWorkbooksTextSearch( name, text, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
TextItemsResponse response = api.cellsWorksheetsGetWorksheetTextItems( name, sheetName, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String oldValue = "!22"; | |
String newValue = "22"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
WorkbookReplaceResponse response = api.cellsWorkbookPostWorkbooksTextReplace(name, oldValue, newValue, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String oldValue = "1234"; | |
String newValue = "56678"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
WorksheetReplaceResponse response = api.cellsWorksheetsPostWorsheetTextReplace(name, sheetName,oldValue, newValue, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String password = null; | |
Boolean isAutoFit = true; | |
Boolean onlySaveTable = true; | |
String format = "PDF"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
File response = api.cellsWorkbookGetWorkbook(name, password, format, isAutoFit, onlySaveTable, folder, null, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String format = "pdf"; | |
String password = null; | |
String outPath = null; | |
String name = BOOK1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
File response = api.cellsWorkbookPutConvertWorkbook( ("C:\\TestData\\"+name), format, password, outPath); | |
} catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String format = "pdf"; | |
String password = null; | |
String outPath = null; | |
String name = BOOK1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
File response = api.cellsWorkbookPutConvertWorkbook(("C:\\TestData\\"+name), format, password, outPath); | |
} catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
SimpleDateFormat df = new SimpleDateFormat("yyyyMMddHHmmss"); | |
String name = "NewBook_" + df.format(new Date()) + ".xlsx"; | |
String templateFile = BOOK1; | |
String dataFile = "ReportData.xml"; | |
String folder = TEMPFOLDER; | |
api.uploadFile(folder+"//"+ dataFile, new File("c:\\TestData\\" + dataFile) , null); | |
api.uploadFile( folder+"//"+templateFile, new File("c:\\TestData\\" + templateFile) , null); | |
WorkbookResponse response = api.cellsWorkbookPutWorkbookCreate(name, folder + "/" + templateFile, folder + "/" + dataFile, true,folder, null); | |
} catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
SimpleDateFormat df = new SimpleDateFormat("yyyyMMddHHmmss"); | |
String name = "NewBook_" + df.format(new Date()) + ".xlsx"; | |
String templateFile = BOOK1; | |
String dataFile = "ReportData.xml"; | |
String folder = TEMPFOLDER; | |
api.uploadFile(folder+"//"+ dataFile, new File("c:\\TestData\\" + dataFile) , null); | |
api.uploadFile( folder+"//"+templateFile, new File("c:\\TestData\\" + templateFile) , null); | |
WorkbookResponse response = api.cellsWorkbookPutWorkbookCreate(name, folder + "/" + templateFile, folder + "/" + dataFile, true,folder, null); | |
} catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
SimpleDateFormat df = new SimpleDateFormat("yyyyMMddHHmmss"); | |
String name = "NewBook_" + df.format(new Date()) + ".xlsx"; | |
String templateFile = "Sample3.xls"; | |
String dataFile = null; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder+"//"+templateFile, new File("c:\\TestData\\" + templateFile) , null); | |
WorkbookResponse response = api.cellsWorkbookPutWorkbookCreate(name, folder + "/" + templateFile, folder + "/" + dataFile, true, folder, null); | |
} catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
WorkbookEncryptionRequest encryption = new WorkbookEncryptionRequest(); | |
encryption.setEncryptionType("XOR"); | |
encryption.setKeyLength(128); | |
encryption.setPassword("123456"); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsWorkbookDeleteDecryptDocument(name, encryption, folder, null); | |
} catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
WorkbookEncryptionRequest encryption = new WorkbookEncryptionRequest(); | |
encryption.setEncryptionType("XOR"); | |
encryption.setKeyLength(128); | |
encryption.setPassword("123456"); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsWorkbookPostEncryptDocument( name, encryption, folder, null); | |
} catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String mergeWith = "myDocument.xlsx"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
api.uploadFile( folder +"/" +mergeWith, new File("c:\\TestData\\" + mergeWith) , null); | |
WorkbookResponse response = api.cellsWorkbookPostWorkbooksMerge(name,folder + "/" + mergeWith, folder, null); | |
} catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
NamesResponse response = api.cellsWorkbookGetWorkbookNames(name, folder, null); | |
} catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
WorkbookProtectionRequest protection = new WorkbookProtectionRequest(); | |
protection.setProtectionType("All"); | |
protection.setPassword("123456"); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsWorkbookPostProtectDocument( name, protection, folder, null); | |
} catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsWorkbookDeleteDocumentUnprotectFromChanges(name, folder,null); | |
} catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
PasswordRequest password = new PasswordRequest(); | |
password.setPassword("123456"); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsWorkbookPutDocumentProtectFromChanges(name, password,folder, null); | |
} catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String format = "png"; | |
Integer from = 1; | |
Integer to = 3; | |
Integer horizontalResolution = 100; | |
Integer verticalResolution = 90; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
SplitResultResponse response = api.cellsWorkbookPostWorkbookSplit(name,format, from, to, horizontalResolution, verticalResolution, folder, folder, null); | |
} catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
WorkbookProtectionRequest protection = new WorkbookProtectionRequest(); | |
protection.setProtectionType("All"); | |
protection.setPassword("123456"); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsWorkbookDeleteUnprotectDocument( name, protection, folder, null); | |
} catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer position = 1; | |
String sheettype = "VB"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
WorksheetsResponse response = api.cellsWorksheetsPutAddNewWorksheet(name, sheetName, position, sheettype, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String formula = "=NOW()"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
SingleValueResponse response = api.cellsWorksheetsGetWorksheetCalculateFormula(name, sheetName,formula, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer verticalResolution = 100; | |
Integer horizontalResolution = 90; | |
String format = "png"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
File response = api.cellsWorksheetsGetWorksheet(name, sheetName,format, verticalResolution, horizontalResolution, null, null,folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = "NewCopy.xlsx"; | |
String sheetName = SHEET5; | |
String sourceSheet = SHEET6; | |
CopyOptions options = new CopyOptions(); | |
options.setCopyNames(true); | |
String sourceWorkbook = BOOK1; | |
String sourceFolder = TEMPFOLDER; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, sourceWorkbook); | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsWorksheetsPostCopyWorksheet(name, sheetName, sourceSheet, options, sourceWorkbook,sourceFolder, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsWorksheetsDeleteWorksheetBackground(name, sheetName, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsWorksheetsDeleteWorksheetBackground(name, sheetName, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer row = 1; | |
Integer column = 1; | |
Integer freezedRows = 4; | |
Integer freezedColumns = 5; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsWorksheetsPutWorksheetFreezePanes(name, sheetName, row, column, freezedRows, freezedColumns, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer row = 1; | |
Integer column = 1; | |
Integer freezedRows = 4; | |
Integer freezedColumns = 5; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
com.aspose.cells.model.AutoShapeResponse ar = api.GetWorksheetAutoshape(name, sheet, autoshape,folder, null); | |
System.out.println("Autoshape HTML: " + ar.getAutoShape().getHtmlText()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer columnIndex = 1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
ColumnResponse response = api.cellsGetWorksheetColumn(name, sheetName, columnIndex, folder,null); | |
Assert.assertEquals("cellsGetWorksheetColumnTest is OK.", "OK", response.getStatus()); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellName = "B3"; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CommentResponse response = api.cellsWorksheetsGetWorksheetComment(name,sheetName, cellName, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = MYDOC; | |
String sheetName = SHEET1; | |
Integer validationIndex = 0; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
ValidationResponse response = api.cellsWorksheetValidationsGetWorksheetValidation(name, sheetName, validationIndex, folder,null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
WorksheetsResponse response = api.cellsWorksheetsGetWorksheets(name, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Boolean isVisible = true; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
WorksheetResponse response = api.cellsWorksheetsPutChangeVisibilityWorksheet(name, sheetName,isVisible, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
WorksheetMovingRequest moving = new WorksheetMovingRequest(); | |
moving.setDestinationWorksheet(SHEET3); | |
moving.setPosition("after"); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
WorksheetsResponse response = api.cellsWorksheetsPostMoveWorksheet(name, sheetName, moving, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
WorksheetMovingRequest moving = new WorksheetMovingRequest(); | |
moving.setDestinationWorksheet(SHEET3); | |
moving.setPosition("after"); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
WorksheetsResponse response = api.cellsWorksheetsPostMoveWorksheet(name, sheetName, moving, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
byte[] png = CellsApiUtil.GetFileData("WaterMark.png"); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsWorksheetsPutWorksheetBackground(name, sheetName, png, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellArea = CELLAREA; | |
DataSorter dataSorter = new DataSorter(); | |
dataSorter.setCaseSensitive(true); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsWorksheetsPostWorksheetRangeSort(name, sheetName,cellArea, dataSorter, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer row = 1; | |
Integer column = 1; | |
Integer freezedRows = 2; | |
Integer freezedColumns = 2; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
CellsCloudResponse response = api.cellsWorksheetsDeleteWorksheetFreezePanes(name, sheetName,row, column, freezedRows, freezedColumns, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Boolean isVisible = true; | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
WorksheetResponse response = api.cellsWorksheetsPutChangeVisibilityWorksheet(name, sheetName,isVisible, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/ | |
try { | |
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl")); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Worksheet sheet = new Worksheet(); | |
sheet.setIsGridlinesVisible(true); | |
sheet.setIndex(0); | |
String folder = TEMPFOLDER; | |
api.uploadFile( folder +"/"+ name, new File("c:\\TestData\\" + name) , null); | |
WorksheetResponse response = api.cellsWorksheetsPostUpdateWorksheetProperty(name, sheetName, sheet, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// for complete examples and source code, please visit https://github.com/aspose-cells-cloud/aspose-cells-cloud-java | |
// specify clientID details | |
String clientId = "c235e685-1aab-4cda-a95b-54afd63eb87f"; | |
// specify clientSecret details | |
String clientSecret = "b8da4ee37494f2ef8da3c727f3a0acb9"; | |
try { | |
CellsApi api = new CellsApi(clientId,clientSecret); | |
String name = "conditional.xlsx"; | |
String password = null; | |
Boolean isAutoFit = true; | |
Boolean onlySaveTable = true; | |
String format = "PDF"; | |
// perform document conversion operation | |
File response = api.cellsWorkbookGetWorkbook(name, password, format, | |
isAutoFit, onlySaveTable, null, null, "Resultant.pdf"); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment