Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
This Gist repository contains code snippet related to Aspose.Cells Cloud SDK for Java
Aspose.Cells-Cloud-SDK-Java
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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);
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
String name = "Book1.xlsx";
String sheetName = "Sheet1";
String folder = "Temp";
CellsApiUtil.Upload(api, folder , name);
CellsCloudResponse response = api.cellsShapesDeleteWorksheetShapes(name, sheetName, folder,null);
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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);
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
String name = "Book1.xlsx";
String sheetName = "Sheet1";
String folder = "Temp";
CellsApiUtil.Upload(api, folder , name);
ShapesResponse response = api.cellsShapesGetWorksheetShapes(name, sheetName, folder,null);
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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);
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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);
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
public static final String clientSecret = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxx";
public static final String clientId = "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx";
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();
}
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
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();
}
// 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();
}
// 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();
}
// 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();
}
// For complete examples and data files, please go to https://github.com/aspose-slides/Aspose.Cells-for-Cloud
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
try {
CellsApi api = new CellsApi(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();
}
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
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();
}
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
try {
CellsApi api = new CellsApi(CellsApiUtil.GetClientId(),Ce