Aspose.Cells-Cloud-SDK-Android

Aspose.Cells-Cloud-SDK-Android

Aspose.Cells-Cloud-SDK-Android

Example-DeleteWorksheetShape.java

// 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);

Example-DeleteWorksheetShapes.java

// 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);

Example-GetWorksheetShape.java

// 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);

Example-GetWorksheetShapes.java

// 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);

Example-PostWorksheetShape.java

// 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);

Example-PutWorksheetShape.java

// 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);

Examples-Android-cells-add-cells-area-for-format-condition.java

// 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();
}

Examples-Android-cells-add-condition-for-format-condition.java

// 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();
}

Examples-Android-cells-add-format-condition.java

// 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();
}

Examples-Android-cells-ChangeCellStyleWorksheet-change-cell-style-in-worksheet.java

// 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();
}

Examples-Android-cells-clear-all-formatting.java

// 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();
}

Examples-Android-cells-ClearCellContentStyleWorksheet-clear-cell-content-style.java

// 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();
}

Examples-Android-cells-ClearCellFormattingWorksheet-clear-cells-formatting.java

// 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();
}

Examples-Android-cells-get-conditional-formatting-worksheet.java

// 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();
}

Examples-Android-cells-get-conditional-formatting.java

// 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();
}

Examples-Android-cells-GetCellStyleWorksheet-get-cell-style-from-worksheet.java

// 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();
}

Examples-Android-cells-GetCellWorksheet-get-cell-from-worksheet.java

// 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();
}

Examples-Android-cells-GetEndCellWorksheet-get-last-cell-excel-worksheet.java

// 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();
}

Examples-Android-cells-GetFirstCellWorksheet-get-first-cell-excel-worksheet.java

// 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();
}

Examples-Android-cells-GetMaxColumnWorksheet-get-max-column.java

// 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();
}

Examples-Android-cells-GetMaxDataColumnWorksheet-get-max-data-column.java

// 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();
}

Examples-Android-cells-GetMaxDataRowWorksheet-get-max-data-row.java

// 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();
}

Examples-Android-cells-GetMaxRowWorksheet-get-max-row-worksheet.java

// 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();
}

Examples-Android-cells-GetMergedCellWorksheet-get-merged-cell-from-worksheet.java

// 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();
}

Examples-Android-cells-GetMinColumnWorksheet-get-min-column-from-worksheet.java

// 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();
}

Examples-Android-cells-GetMinDataColumnWorksheet-get-min-data-column.java

// 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();
}

Examples-Android-cells-GetMinDataRowWorksheet-get-min-data-row.java

// 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();
}

Examples-Android-cells-GetMinRowWorksheet-get-min-row-worksheet.java

// 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();
}

Examples-Android-cells-MergeCellsWorksheet-merge-cells-worksheet.java

// 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();
}

Examples-Android-cells-remove-cell-area-from-conditional-formatting.java

// 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();
}

Examples-Android-cells-remove-conditional-formatting.java

// 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();
}

Examples-Android-cells-SetCellWorksheet-set-cell-value-worksheet.java

// 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();
}

Examples-Android-cells-SetFormulaForCellWorksheet-set-formula-for-worksheet.java

// 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();
}

Examples-Android-cells-SetRangeValueWorksheet-1.java

// 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();
}

Examples-Android-cells-UnmergeCellsWorksheet-unmerge-cells-in-worksheet.java

// 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();
}

Examples-Android-chart-AddChart-1.java

// 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();
}

Examples-Android-chart-ConvertChartToImage-convert-chart-to-image.java

// 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();
}

Examples-Android-chart-DeleteAllCharts-delete-all-charts.java

// 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();
}

Examples-Android-chart-DeleteChartTitle-delete-chart-title.java

// 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();
}

Examples-Android-chart-DeleteOneChart-delete-single-chart.java

// 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();
}

Examples-Android-chart-GetChart-get-chart-from-worksheet.java

// 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();
}

Examples-Android-chart-GetChartArea-get-chart-area.java

// 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();
}

Examples-Android-chart-GetChartFillFormat-get-fill-format.java

// 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();
}

Examples-Android-chart-GetChartLegend-get-chart-legend.java

// 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();
}

Examples-Android-chart-HideChartLegend-hide-chart-legend.java

// 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();
}

Examples-Android-chart-SetChartTitle-set-chart-title.java

// 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();
}

Examples-Android-chart-ShowChartLegend-show-chart-legend.java

// 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();
}

Examples-Android-chart-UpdateChartLegend-update-chart-legend.java

// 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();
}

Examples-Android-chart-UpdateChartTitle-update-chart-title.java

// 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();
}

Examples-Android-Configuration-tester1.java

public static final String clientSecret = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxx";
public static final String clientId = "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx";

Examples-Android-filters-AddDateWorksheetExample-1.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 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();
}

Examples-Android-filters-AddFilterToFilterColumnExample-1.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 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();
}

Examples-Android-filters-AddIconFilterExample-1.java

// 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();
}

Examples-Android-filters-DeleteFilterForFilterColumnExample-1.java

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();
}

Examples-Android-filters-DeleteWorksheetDataExample-1.java

// 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();
}

Examples-Android-filters-FilterListCustomCriteriaExample-1.java

// 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();
}

Examples-Android-filters-FilterListDynamicCriteriaExample-1.java

// 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();
}

Examples-Android-filters-FilterTop10CriteriaExample-1.java

// 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();
}

Examples-Android-filters-GetAutoFilterDescriptionExample-1.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);
      AutoFilterResponse response = api.cellsAutoFilterGetWorksheetAutoFilter(name, sheetName, folder,null);
}
catch (Exception ex)
{
   ex.printStackTrace();
}

Examples-Android-filters-MatchBlanksListExample-1.java

// 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();
}

Examples-Android-filters-MatchNonBlanksListExample-1.java

// 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();
}

Examples-Android-filters-RefreshAutoFilterExample-1.java

// 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();
}

Examples-Android-hyperlinks-AddHyperlinkWorksheet-add-hyperlinks-to-worksheet.java

// 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();
}

Examples-Android-hyperlinks-DeleteHyperlinkWorksheet-delete-hyperlink-worksheet.java

// 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();
}

Examples-Android-hyperlinks-GetHyperlinkWorksheet-get-hyperlink-worksheet.java

// 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();
}

Examples-Android-hyperlinks-UpdateHyperlinkWorksheet-update-hyperlink-worksheet.java

// 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();
}

Examples-Android-images-AutoShapeToImageWorksheet-auto-shape-images.java

// 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();
}

Examples-Android-oleobjects-AddOleObjectsWorksheet-add-ole-objects-worksheet.java

// 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();
}

Examples-Android-oleobjects-ConvertOleObjectToImage-convert-ole-object-to-image.java

// 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();
}

Examples-Android-oleobjects-DeleteAllOleObjectsWorksheet-delete-all-ole-objects-worksheet.java

// 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();
}

Examples-Android-oleobjects-DeleteSpecificOleObjectWorksheet-1.java

// 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();
}

Examples-Android-oleobjects-DeleteSpecificOleObjectWorksheet-delete-specfiic-ole-object-worksheet.java

// 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();
}

Examples-Android-oleobjects-GetOleObjectWorksheet-get-ole-objects-worksheet.java

// 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();
}

Examples-Android-oleobjects-UpdateSpecificOleObjectsWorksheet-update-specific-ole-objects-worksheet.java

// 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();
}

Examples-Android-pictures-AddPicturesWorksheet-add-pictures-worksheet.java

// 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();
}

Examples-Android-pictures-ConvertPictureToImageWorksheet-convert-pictures-to-image-worksheet.java

// 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();
}

Examples-Android-pictures-DeleteAllPicturesWorksheet-delete-all-pictures-worksheet.java

// 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();
}

Examples-Android-pictures-DeleteSpecificPictureWorksheet-delete-specifc-pictures-worksheet.java

// 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();
}

Examples-Android-pictures-GetPictureWorksheet-get-picture-worksheet.java

// 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();
}

Examples-Android-pictures-UpdateSpecificPictureWorksheet-update-specfic-pictures-worksheet.java

// 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();
}

Examples-Android-pivottables-AddPivotFieldInPivottable-add-pivot-field.java

// 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();
}

Examples-Android-pivottables-AddPivottableWorksheet-add-pivot-table-worksheet.java

// 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();
}

Examples-Android-pivottables-DeleteWorksheetPivotTable-delete-worksheet-pivot-table.java

// 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();
}

Examples-Android-pivottables-DeleteWorksheetPivotTableIndex-delete-worksheet-pivot-table-index.java

// 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();
}

Examples-Android-pivottables-GetPivotTableIndexWorksheet-get-pivottable-index-worksheet.java

// 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();
}

Examples-Android-pivottables-GetPivotTableWorksheet-GetPivotTableWorksheet-12345.java

// 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();
}

Examples-Android-pivottables-GetWorksheetPivotInfoByIndex-1.java

// 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();
}

Examples-Android-properties-GetAllProperties-get-all-document-properties.java

// 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();
}

Examples-Android-properties-GetParticularProperty-get-particular-property.java

// 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();
}

Examples-Android-properties-RemoveAllProperties-remove-all-properties.java

// 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();
}

Examples-Android-properties-RemoveParticularProperty-remove-particular-property.java

// 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();
}

Examples-Android-properties-SetParticularProperty-set-particular-property.java

// 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();
}

Examples-Android-rows-AddEmptyRowInWorksheet-add-empty-row-in-worksheet.java

// 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();
}

Examples-Android-rows-AutoFitRowsInWorksheet-autofit-rows-in-worksheet.java

// 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();
}

Examples-Android-rows-CopyRowsInWorksheet-copy-rows-in-worksheet.java

// 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();
}

Examples-Android-rows-DeleteRowFromWorksheet-delete-row-from-worksheet.java

// 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();
}

Examples-Android-rows-GetRowFromWorksheet-get-row-from-worksheet.java

// 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();
}

Examples-Android-rows-GroupRowsInWorksheet-group-rows-in-worksheet.java

// 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();
}

Examples-Android-rows-HideRowsInWorksheet-hide-rows-in-excel-worksheet.java

// 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();
}

Examples-Android-rows-UngroupRowsInWorksheet-ungroup-rows-in-excel-worksheet.java

// 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();
}

Examples-Android-rows-UnhideRowsInWorksheet-unhide-rows-in-excel-worksheet.java

// 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();
}

Examples-Android-text-FindTextWorkbook-find-text-workbook.java

// 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();
}

Examples-Android-text-FindTextWorksheet-find-text-worksheet.java

// 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();
}

Examples-Android-text-GetTextItemWorkbook-get-text-item-workbook.java

// 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();
}

Examples-Android-text-GetTextItemWorksheet-get-text-item-worksheet.java

// 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();
}

Examples-Android-text-ReplaceTextWorkbook-replace-text-workbook.java

// 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();
}

Examples-Android-text-ReplaceTextWorksheet-replace-text-worksheet.java

// 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();
}

Examples-Android-workbook-ConvertWorkbookToAnotherFormat-convert-workbook-to-different-format.java

// 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();
}

Examples-Android-workbook-ConvertWorkbookToAnotherFormatWithoutStorage-convert-workbook-to-different-format-without-storage.java

// 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();
}

Examples-Android-workbook-ConvertWorkbookWithAdditionalSettings-convert-workbook-additional-settings.java

// 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();
}

Examples-Android-workbook-CreateEmptyWorkbook-create-empty-workbook.java

// 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();
}

Examples-Android-workbook-CreateWorkbookFromSmartMarkerTemplate-create-from-smart-marker.java

// 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();
}

Examples-Android-workbook-CreateWorkbookFromTemplate-create-empty-workbook-from-template.java

// 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();
}

Examples-Android-workbook-DecryptWorkbook-decrypt-excel-workbook.java

// 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();
}

Examples-Android-workbook-EncryptWorkbook-encrypt-workbook.java

// 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();
}

Examples-Android-workbook-MergeWorkbooks-merge-excel-workbooks.java