Export WORKSHEET object to ODS format file using Cells Cloud SDK for Java
API
POST
https://api.aspose.cloud/v3.0/cells/export
Export WORKSHEET object to ODS file from Excel file is a complex task. Export WORKSHEET to ODS format transitions is performed by our Java SDK while maintaining the source WORKSHEET spreadsheet's main structural and logical content. Our Java library is a professional solution to export WORKSHEET objects to ODS format files online. This Cloud SDK gives Java developers powerful functionality and perfect ODS output.
Code example in Java using REST API to export WORKSHEET to ODS format from spreadsheet
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-java/
import java.io.*;
import java.util.HashMap;
import java.util.List;
import java.util.Base64;
import com.aspose.cloud.cells.api.*;
import com.aspose.cloud.cells.model.*;
public class Export {
public static void main(String[] args) {
String format = "ods";
String objectType = "worksheet";
HashMap<String,File> fileMap = new HashMap<String,File>();
fileMap.put("Book1.xlsx" ,new File("C:\Book1.xlsx") );
fileMap.put("myDocument.xlsx" ,new File("C:\myDocument.xlsx") );
try {
LightCellsApi cellsApi = new LightCellsApi(System.getenv("ProductClientId"), System.getenv("ProductClientSecret"),"v3.0","https://api.aspose.cloud");
FilesResult response = cellsApi.postExport(fileMap,objectType, format,null);
List<FileInfo> files = response.getFiles();
String filename = files.get(0).getFilename();
String fileContent = files.get(0).getFileContent();
byte[] data = Base64.getDecoder().decode(fileContent);
OutputStream outputStream = new FileOutputStream(filename);
outputStream.write(data,0,data.length);
outputStream.close();
}catch(Exception exception )
{
System.out.print(exception);
}
}
}
How to use Cells Cloud SDK for Java to export objects from Excel WORKSHEET to ODS
- Register an account at Dashboard to get free API quota & authorization details
- Initialize the Cells API with your Client ID, Client Secret, Base URL, and API version.
- Use the `postExport` method to retrieve the resulting stream.
System Requirements
- Maven 2.2.0 or newer
- Java(TM) SE Runtime Environment