Skip to content

A very fast and lightweight (no dependency) library for creating ODS (Open Document Spreadsheet, mainly for Calc) files in Java. It's a Martin Schulz's SimpleODS fork

License

Notifications You must be signed in to change notification settings

juergen-albert/fastods

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Build Status Code Coverage

FastODS

(C) J. Férard 2016-2019

(C) M. Schulz 2008-2013 for SimpleODS

A very fast and lightweight (no dependency) library for creating ODS (Open Document Spreadsheet, mainly for Calc) files in Java. It's a Martin Schulz's SimpleODS fork.

TLDR;

Here's what some of the produced documents in the tutorial look like:

A regular table:
Periodic Table List of elements

A multiplication table:
Multiplication Table

The periodic table of Mr. Dmitri Mendeleev:
Periodic Table

Table of contents

Why FastODS?

Because I need to write big and simple ODS files very fast in Java.

There are some very good libraries for OASIS Open Document Format, like Simple ODF or JOpenDocument, but they are a little bit slow and cumberstone for only writing very simple spreadsheets. There is a simple and fast library by Martin Schulz, Simple ODS, but it is now discontinued, outdated (Java 1.3), has a few limitations (incorrect handling of UTF-8 encoding, missing XML escaping for attributes) and can be speed up.

FastODS is a fork of SimpleODS that aims to be a very fast ODS writing library in Java.

Limitations

FastODS won't deal with odt, odg, odf, or other od_ files. It won't even read ods files. Because it doesn't use XML internally, but only for writing files. That's why it is fast and lightweight.

It's an OpenDocument producer (Open Document Format for Office Applications (OpenDocument) Version 1.2, 2.3.1) and only an OpenDocument producer:

An OpenDocument producer is a program that creates at least one conforming OpenDocument document

FastODS documents and LibreOffice/OpenOffice/Excel/...

While an OpenDocument producer like FastODS can be reasonably simple because it just has to focus on the creation of OpenDocument files, OpenDocument consumers like LibreOffice, OpenOffice, Excel, ... are expected to handle numerous files created by various producers and are therefore more complex. Although the spec states that a producer has to:

parse and interpret OpenDocument documents according to the semantics defined by this specification [...] but it need not interpret the semantics of all elements, attributes and attribute values. (emphasis mine)

we expect those applications to open almost every proper OpenDocument file. But that's not so easy, because LibreOffice, OpenOffice, Excel, ... do not understand some tags, attributes or attribute values.

To be pragmatic, I chose to consider LibreOffice as the reference implementation. Hence the documents created by FastODS should be fully understood by LibreOffice (whereas there is a specific option to disable this enforced compatibility and to produce files that are slightly more concise). There is no plan to adapt the documents created by FastODS to OpenOffice, Excel or another reader, although it will be done if possible (your help is welcome).

Platforms and dependencies

FastODS has no runtime dependency beyond the standard Java Library version 6 or higher. Even the XML code is manually produced.

FastODS works on Android (tested on Android 9 Pie, see this issue).

Installation

Standard

Add the following dependency to your POM:

<dependency>
		<groupId>com.github.jferard</groupId>
		<artifactId>fastods</artifactId>
		<version>0.7.0</version>
</dependency>

From sources

Type the following command:

git clone https://github.com/jferard/fastods.git

Then:

mvn clean install

From jar

First download the jar file from the latest release.

Then run the following command to install the jar in your local repo:

mvn org.apache.maven.plugins:maven-install-plugin:2.5.2:install-file -Dfile=fastods-<version>.jar

Examples

Basic example

Taken from the tutorial:

final OdsFactory odsFactory = OdsFactory.create(Logger.getLogger("hello-world"), Locale.US);
final AnonymousOdsFileWriter writer = odsFactory.createWriter();
final OdsDocument document = writer.document();
final Table table = document.addTable("hello-world");
final TableRowImpl row = table.getRow(0);
final TableCell cell = row.getOrCreateCell(0);
cell.setStringValue("Hello, world!");
writer.saveAs(new File("generated_files", "readme_example.ods"));

Documentation

Writing a full documentation would be a considerable work, because every time you change the library, you have to rewrite the doc.

My idea is to provide a set of examples of the features of FastODS. This is ensures that the doc is up to date.

Those examples are located in the examples module and are fully commented. A tutorial was extracted from this examples.

To run those examples, one has to run:

mvn verify

The resulting ods files are written in generated_files directory, and can be opened with LibreOffice or OpenOffice.

Other examples

Other examples are implemented as integration tests: OdsFileCreationIT.java, OdsFileWithHeaderAndFooterCreationIT.java, etc.

To run those examples, one has to run:

mvn verify

The resulting ods files are written in generated_files directory, and can be opened with LibreOffice or OpenOffice. See the integration tests directory

Speed

Let's be concrete : FastODS is approximately twice as fast as SimpleODS and ten times faster than JOpenDocument for writing large ODS files. (SimpleODF is clearly not the right tool to write large ODS files.)

For more details, see https://github.com/jferard/fastods/wiki/Benchmarking-and-profiling.

History

See https://github.com/jferard/fastods/releases

About

A very fast and lightweight (no dependency) library for creating ODS (Open Document Spreadsheet, mainly for Calc) files in Java. It's a Martin Schulz's SimpleODS fork

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Java 99.3%
  • Other 0.7%