Last active
January 6, 2021 06:26
-
-
Save aspose-cloud/9d725d4678edaac53f95c5208e17783c to your computer and use it in GitHub Desktop.
Aspose.Cells-Cloud-SDK-Android
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-Android |
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/ | |
String name = "Book1.xlsx"; | |
String sheetName = "Sheet6"; | |
Integer shapeindex = 0; | |
String folder = "Temp"; | |
CellsApiUtil.Upload(api, folder , name); | |
CellsCloudResponse response = api.cellsShapesDeleteWorksheetShape(name, sheetName, shapeindex, folder,null); |
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/ | |
String name = "Book1.xlsx"; | |
String sheetName = "Sheet1"; | |
String folder = "Temp"; | |
CellsApiUtil.Upload(api, folder , name); | |
CellsCloudResponse response = api.cellsShapesDeleteWorksheetShapes(name, sheetName, folder,null); |
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/ | |
String name = "Book1.xlsx"; | |
String sheetName = "Sheet6"; | |
Integer shapeindex = 0; | |
String folder = "Temp"; | |
CellsApiUtil.Upload(api, folder , name); | |
ShapeResponse response = api.cellsShapesGetWorksheetShape(name, sheetName, shapeindex, folder,null); |
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/ | |
String name = "Book1.xlsx"; | |
String sheetName = "Sheet1"; | |
String folder = "Temp"; | |
CellsApiUtil.Upload(api, folder , name); | |
ShapesResponse response = api.cellsShapesGetWorksheetShapes(name, sheetName, folder,null); |
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/ | |
String name = "Book1.xlsx"; | |
String sheetName = "Sheet6"; | |
Integer shapeindex = 0; | |
Shape dto = new Shape(); | |
dto.setLowerRightColumn(10); | |
String folder = "Temp"; | |
CellsApiUtil.Upload(api, folder , name); | |
CellsCloudResponse response = api.cellsShapesPostWorksheetShape(name, sheetName, shapeindex, dto, folder,null); |
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/ | |
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"; | |
CellsApiUtil.Upload(api, folder , name); | |
ShapeResponse response = api.cellsShapesPutWorksheetShape(name, sheetName,null, drawingType, upperLeftRow, upperLeftColumn, top, left, width, height, folder,null); |
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(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer index = 0; | |
String cellArea = CELLAREA; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer index = 0; | |
String cellArea = CELLAREA; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String range = RANGE; | |
Integer startRow = 1; | |
Integer startColumn = 2; | |
Integer endRow = 10; | |
Integer endColumn = 7; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String range = RANGE; | |
Integer startRow = 1; | |
Integer startColumn = 1; | |
Integer endRow = 7; | |
Integer endColumn = 6; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellName = "A1"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "A1"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "endcell"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "firstcell"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "maxcolumn"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "maxdatacolumn"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "maxdatarow"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "maxrow"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer mergedCellIndex = 1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "mincolumn"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "mindatacolumn"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "mindatarow"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellOrMethodName = "minrow"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer startRow = 1; | |
Integer startColumn = 1; | |
Integer totalRows = 4; | |
Integer totalColumns = 6; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer index = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellName = CellName; | |
String value = "2018-08-28"; | |
String type = "Date"; | |
String formula = "=Now()"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellName = CellName; | |
String value = "2018-08-28"; | |
String type = "Date"; | |
String formula = "=Now()"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
Integer firstRow = 0; | |
Integer firstColumn = 0; | |
Integer rowCount = 3; | |
Integer columnCount = 2; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartNumber = 0; | |
String format = "png"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartNumber = 0; | |
String format = "png"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
Title title = new Title(); | |
title.setText("test"); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
Legend legend = new Legend(); | |
legend.setWidth(0); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = MYDOC; | |
String sheetName = SHEET3; | |
Integer chartIndex = 0; | |
Title title = new Title(); | |
title.setText("test"); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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
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(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder , name); | |
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(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String range = RANGE; | |
Integer fieldIndex = 0; | |
String criteria = "test"; | |
Boolean matchBlanks = true; | |
Boolean refresh = true; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder , name); | |
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(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer fieldIndex = 1; | |
String criteria = "test"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder , name); | |
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(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder , name); | |
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(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String range = RANGE; | |
Integer fieldIndex = 0; | |
String dynamicFilterType = "May"; | |
Boolean matchBlanks = true; | |
Boolean refresh = true; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder , name); | |
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(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer fieldIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer fieldIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer hyperlinkIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer hyperlinkIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer hyperlinkIndex = 0; | |
Hyperlink hyperlink = new Hyperlink(); | |
hyperlink.setAddress( "http://www.aspose.com"); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Integer shapeindex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Integer objectNumber = 0; | |
String format = 'png'; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Integer oleObjectIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Integer oleObjectIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Integer objectNumber = 0; | |
String format = null; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
String format = null; | |
Integer pictureNumber = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Integer pictureIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
String format = null; | |
Integer pictureNumber = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET6; | |
Integer pictureIndex = 0; | |
Picture picture = new Picture(); | |
picture.setLeft(10); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name =PivTestFile;; | |
String sheetName = SHEET4; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name =PivTestFile;; | |
String sheetName = SHEET4; | |
Integer pivotTableIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name =PivTestFile;; | |
String sheetName = SHEET4; | |
Integer pivottableIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name =PivTestFile;; | |
String sheetName = SHEET4; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name =PivTestFile;; | |
String sheetName = SHEET4; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String propertyName ="Author"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String propertyName = "Author"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String propertyName ="Name"; | |
CellsDocumentProperty property = new CellsDocumentProperty(); | |
property.setName("Name"); | |
property.setValue("Roy"); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer rowIndex = 1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String password = null; | |
Boolean isAutoFit = true; | |
Boolean onlySaveTable = true; | |
String format = "XPS"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer sourceRowIndex = 1; | |
Integer destinationRowIndex = 1; | |
Integer rowNumber = 1; | |
String worksheet = SHEET2; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer rowIndex = 1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer rowIndex = 1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer firstIndex = 1; | |
Integer lastIndex = 1; | |
Boolean hide = true; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer startrow = 1; | |
Integer totalRows = 1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer firstIndex = 1; | |
Integer lastIndex = 10; | |
Boolean isAll = true; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer startrow = 1; | |
Integer totalRows = 1; | |
Double height = 10.0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String text = "test"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String text = "123456"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String text = "test"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String oldValue = "!22"; | |
String newValue = "22"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String oldValue = "1234"; | |
String newValue = "56678"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String password = null; | |
Boolean isAutoFit = true; | |
Boolean onlySaveTable = true; | |
String format = "PDF"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String format = "pdf"; | |
String password = null; | |
String outPath = null; | |
String name = BOOK1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
File response = api.cellsWorkbookPutConvertWorkbook( | |
CellsApiUtil.GetFileHolder(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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String format = "pdf"; | |
String password = null; | |
String outPath = null; | |
String name = BOOK1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
File response = api.cellsWorkbookPutConvertWorkbook( | |
CellsApiUtil.GetFileHolder(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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
SimpleDateFormat df = new SimpleDateFormat("yyyyMMddHHmmss"); | |
String name = "NewBook_" + df.format(new Date()) + ".xlsx"; | |
String templateFile = BOOK1; | |
String dataFile = "ReportData.xml"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, dataFile); | |
CellsApiUtil.Upload(api, folder, templateFile); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
SimpleDateFormat df = new SimpleDateFormat("yyyyMMddHHmmss"); | |
String name = "NewBook_" + df.format(new Date()) + ".xlsx"; | |
String templateFile = BOOK1; | |
String dataFile = "ReportData.xml"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, dataFile); | |
CellsApiUtil.Upload(api, folder, templateFile); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
SimpleDateFormat df = new SimpleDateFormat("yyyyMMddHHmmss"); | |
String name = "NewBook_" + df.format(new Date()) + ".xlsx"; | |
String templateFile = "Sample3.xls"; | |
String dataFile = null; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, templateFile); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
WorkbookEncryptionRequest encryption = new WorkbookEncryptionRequest(); | |
encryption.setEncryptionType("XOR"); | |
encryption.setKeyLength(128); | |
encryption.setPassword("123456"); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
WorkbookEncryptionRequest encryption = new WorkbookEncryptionRequest(); | |
encryption.setEncryptionType("XOR"); | |
encryption.setKeyLength(128); | |
encryption.setPassword("123456"); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String mergeWith = "myDocument.xlsx"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
CellsApiUtil.Upload(api, folder, mergeWith); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
WorkbookProtectionRequest protection = new WorkbookProtectionRequest(); | |
protection.setProtectionType("All"); | |
protection.setPassword("123456"); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
PasswordRequest password = new PasswordRequest(); | |
password.setPassword("123456"); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String format = "png"; | |
Integer from = 1; | |
Integer to = 3; | |
Integer horizontalResolution = 100; | |
Integer verticalResolution = 90; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
WorkbookProtectionRequest protection = new WorkbookProtectionRequest(); | |
protection.setProtectionType("All"); | |
protection.setPassword("123456"); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer position = 1; | |
String sheettype = "VB"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String formula = "=NOW()"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer verticalResolution = 100; | |
Integer horizontalResolution = 90; | |
String format = "png"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
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); | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer row = 1; | |
Integer column = 1; | |
Integer freezedRows = 4; | |
Integer freezedColumns = 5; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi cellsApi = new CellsApi(Configuration.clientId,Configuration.clientSecret); | |
String input = "Sample1.xlsx"; | |
Path inputFile = Utils.getPath(GetAutoshape.class, input); | |
String sheet = "Sheet1"; | |
int autoshape = 0; | |
cellsApi.PutCreate(input, null, Utils.STORAGE, inputFile.toFile()); | |
com.aspose.cells.model.AutoShapeResponse ar = cellsApi | |
.GetWorksheetAutoshape(inputFile.getFileName().toString(), sheet, autoshape, Utils.STORAGE, 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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer columnIndex = 1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellName = "B3"; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = MYDOC; | |
String sheetName = SHEET1; | |
Integer validationIndex = 0; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder , name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Boolean isVisible = true; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
WorksheetMovingRequest moving = new WorksheetMovingRequest(); | |
moving.setDestinationWorksheet(SHEET3); | |
moving.setPosition("after"); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
WorksheetMovingRequest moving = new WorksheetMovingRequest(); | |
moving.setDestinationWorksheet(SHEET3); | |
moving.setPosition("after"); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
byte[] png = CellsApiUtil.GetFileData("WaterMark.png"); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
String cellArea = CELLAREA; | |
DataSorter dataSorter = new DataSorter(); | |
dataSorter.setCaseSensitive(true); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Integer row = 1; | |
Integer column = 1; | |
Integer freezedRows = 2; | |
Integer freezedColumns = 2; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Boolean isVisible = true; | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
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-android/ | |
try { | |
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret(),CellsApiUtil.GetAPIVersion(),CellsApiUtil.GetBaseUrl()); | |
String name = BOOK1; | |
String sheetName = SHEET1; | |
Worksheet sheet = new Worksheet(); | |
sheet.setIsGridlinesVisible(true); | |
sheet.setIndex(0); | |
String folder = TEMPFOLDER; | |
CellsApiUtil.Upload(api, folder, name); | |
WorksheetResponse response = api | |
.cellsWorksheetsPostUpdateWorksheetProperty(name, sheetName, | |
sheet, folder, null); | |
} | |
catch (Exception e) { | |
e.printStackTrace(); | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment