XLSX ODS HTML NUMBERS CSV
Aspose.Cells  for Java
ODS

Merge ODS to ODS Formats in Java

Native and high performance document merger using server-side Aspose.Cells for Java APIs, without the use of any software like Microsoft or Open Office, Adobe PDF.

Merge ODS to ODS File Using Java

With Aspose.Cells for Java library, you can easily merge ODS to ODS file programmatically with a few lines of code. Aspose.Cells for Java is capable of building cross-platform applications with the ability to generate, modify, convert, render and print all Excel files. Java Excel API not only convert between spreadsheet formats, it can also render Excel files as images, PDF, HTML, ODS, CSV, SVG, JSON, WORD, PPT and more, thus making it a perfect choice to exchange documents in industry-standard formats. You can download its latest version directly from Maven and install it within your Maven-based project by adding the following configurations to the pom.xml.

Repository


<repository>
<id>AsposeJavaAPI</id>
<name>Aspose Java API</name>
<url>https://repository.aspose.com/repo/</url>
</repository>

Dependency


<dependency>
<groupId>com.aspose</groupId>
<artifactId>aspose-cells</artifactId>
<version>version of aspose-cells API</version>
<classifier>jdk17</classifier>
</dependency>

System Requirements

Our APIs are supported on all major platforms and Operating Systems. Before executing the code below, please make sure that you have the following prerequisites on your system.

  • Microsoft Windows or a compatible OS with Java Runtime Environment for JSP/JSF Application and Desktop Applications.
  • Get latest version of Aspose.Cells for Java directly from Maven.

How to Merge ODS to ODS File in Java

A basic document merging and concatenating with Aspose.Cells for Java APIs can be done with just few lines of code.

  • Load the ODS file with Workbook class.
  • Call the Workbook.Combine method for merging files.
  • Call the Workbook.Save method and pass the output file name as a parameter.
  • Now you can open and use the output file in Microsoft Office, Adobe PDF or any other compatible program.
Free App to merge Excel files on line
Select two files
Output format
   
                                   

	
  import  com.aspose.cells.Workbook;     
  Workbook workbook = new Workbook("Input.xlsx");
  workbook.combine(new Workbook("Combine.xlsx"));
  workbook.save("Output.pdf");
	 
                
            

ODS What is ODS File Format

Files with .ods extension stand for OpenDocument Spreadsheet Document format that are editable by user. Data is stored inside ODF file into rows and columns. It is XML-based format and is one of the several subtypes in the Open Document Formats (ODF) family. The format is specified as part of the ODF 1.2 specifications published and maintained by OASIS. A number of applications on Windows as well as other operating systems can open ODS files for editing and manipulation including Microsoft Excel, NeoOffice and LibreOffice. ODS files can also be converted into other spreadsheet formats as well like XLS, XLSX and others by different applications.

Read More

ODS What is ODS File Format

Files with .ods extension stand for OpenDocument Spreadsheet Document format that are editable by user. Data is stored inside ODF file into rows and columns. It is XML-based format and is one of the several subtypes in the Open Document Formats (ODF) family. The format is specified as part of the ODF 1.2 specifications published and maintained by OASIS. A number of applications on Windows as well as other operating systems can open ODS files for editing and manipulation including Microsoft Excel, NeoOffice and LibreOffice. ODS files can also be converted into other spreadsheet formats as well like XLS, XLSX and others by different applications.

Read More

Other Supported Merging Formats

Using Java, One can also merge ods to many other file formats including.

HTML (Hyper Text Markup Language)
MHTML (Web Page Archive Format)
ODS (OpenDocument Spreadsheet File)
TSV (Tab-Separated Values)
TXT (Text Document)
XLS (Excel Binary Format)
XLSB (Binary Excel Workbook File)
XLSM (Spreadsheet File)
XLSX (OOXML Excel File)
XLT (Microsoft Excel Template)
XLTM (Excel Macro-enabled Template)
XLTX (Office OpenXML Excel Template)