Merge ODS to PDF for Free in java

Java Code for Merging ODS Files into PDF: A Complete Guide

// Merge ODS to HTML
LightCellsApi api = new LightCellsApi(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) );

    PostMergeRequest request = new PostMergeRequest();
    request.setFile(fileMap);
    request.setFormat("png");
    request.setMergeToOneSheet(false);
    request.setPassword("");
    request.setCheckExcelRestriction(false);

    FileInfo response =  api.postMerge(request);
%!(EXTRA string=ODS, string=HTML)
// Merge HTML to PDF
ApiClient apiClient = new ApiClient(/*clientId*/ "####-####-####-####-####", /*clientSecret*/ "##################", null);
WordsApi wordsApi = new WordsApi(apiClient);
String localFile = "Sample.docx";

byte[] requestDocument = Files.readAllBytes(Paths.get(localFile).toAbsolutePath());
byte[] requestDocumentListDocumentEntries0FileReferenceStream = Files.readAllBytes(Paths.get(TestInitializer.LocalTestFolder, localFile).toAbsolutePath());
FileReference requestDocumentListDocumentEntries0FileReference = new FileReference(requestDocumentListDocumentEntries0FileReferenceStream);
DocumentEntry requestDocumentListDocumentEntries0 = new DocumentEntry();
requestDocumentListDocumentEntries0.setFileReference(requestDocumentListDocumentEntries0FileReference);
requestDocumentListDocumentEntries0.setImportFormatMode("KeepSourceFormatting");

ArrayList<DocumentEntry> requestDocumentListDocumentEntries = new ArrayList<DocumentEntry>();
requestDocumentListDocumentEntries.add(requestDocumentListDocumentEntries0);

DocumentEntryList requestDocumentList = new DocumentEntryList();
requestDocumentList.setDocumentEntries(requestDocumentListDocumentEntries);

AppendDocumentOnlineRequest appendRequest = new AppendDocumentOnlineRequest(requestDocument, requestDocumentList, null, null, null, null, null, null);
wordsApi.appendDocumentOnline(appendRequest);
%!(EXTRA string=HTML, string=PDF)