Java API to clear list objects on local Microsoft Excel and OpenOffice Calc spreadsheet

Java Clear to clear list objects on local Microsoft Excel and OpenOffice Calc spreadsheet

Use Cells Clear REST API to clear list objects on local Microsoft Excel and OpenOffice Calc spreadsheet workflows in Java. This professional solution clear list objects on local Microsoft Excel and OpenOffice Calc spreadsheet using Java.

C#
Java
Python
PHP
Go
Node
Perl
Swift
Ruby
Android

Clear list objects on local Microsoft Excel and OpenOffice Calc spreadsheet - Java REST API

API Request:
POST
https://api.aspose.cloud/v3.0/cells/clear
Api Reference

Clearing list objects on local Microsoft Excel and OpenOffice Calc spreadsheet is a complex task. Clearing list objects on local Microsoft Excel and OpenOffice Calc spreadsheet transitions is performed by our Java SDK while maintaining the source spreadsheet's main structural and logical content. Our Java library is a professional solution to clear list objects on local Microsoft Excel and OpenOffice Calc spreadsheet online. This Cloud SDK gives Java developers powerful functionality and perfect API.

Java code for clearing list objects on local spreadsheets

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
try{
CellsApi api = new CellsApi(System.getenv("CellsCloudTestClientId"),System.getenv("CellsCloudTestClientSecret"),"v3.0",System.getenv("CellsCloudTestApiBaseUrl"));
String remoteFolder = "TestData/";
String localName = "Book1.xlsx";
String remoteName = "Book1.xlsx";
String AssemblyTestXlsx = "assemblytest.xlsx";
String DataSourceXlsx = "datasource.xlsx";
HashMap<String,File> fileMap = new HashMap<String,File>();
fileMap.put(AssemblyTestXlsx , new File("D:\\TestData\\" + AssemblyTestXlsx));
fileMap.put(DataSourceXlsx , new File("D:\\TestData\\" + DataSourceXlsx) );
PostClearObjectsRequest request = new PostClearObjectsRequest();
request.setFile(fileMap);
request.setObjecttype("ListObject");
request.setSheetname("");
request.setOutFormat("");
request.setPassword("");
request.setCheckExcelRestriction(false);
FilesResult response = api.postClearObjects(request);
} catch (ApiException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
view raw Example-Clear-ListObject.java hosted with ❤ by GitHub


How to use Java API to clear list objects

  1. Create an account at Dashboard to get free API quota & authorization details
  2. Initialize CellsApi with Client Id, Client Secret, Base URL & API version
  3. Call postClearObjects method to get the resultant stream


System Requirements

  1. Android 7 or newer
  2. Java(TM) SE Runtime Environment