Create a spreadsheet

With jOpenDocument, it's very easy to save any tabular data to an OpenDocument spreadsheet.

  // Create the data to save.
  final Object[][] data = new Object[6][2];
  data[0] = new Object[] { "January", 1 };
  data[1] = new Object[] { "February", 3 };
  data[2] = new Object[] { "March", 8 };
  data[3] = new Object[] { "April", 10 };
  data[4] = new Object[] { "May", 15 };
  data[5] = new Object[] { "June", 18 };

  String[] columns = new String[] { "Month", "Temp" };

  TableModel model = new DefaultTableModel(data, columns);  
    
  // Save the data to an ODS file and open it.
  final File file = new File("temperature.ods");
  SpreadSheet.createEmpty(model).saveAs(file);
    
  OOUtils.open(file);

As you can see in the code above, a spreadsheet can be generated directly from data by using the static method createEmpty of the class SpreadSheet with a javax.swing.TableModel as an argument. The only thing to be specified is the file where to save the data.

You will find in the SpreadSheet class different methods that let you define the version of the final generated document with the appropriate extension:


If you want to know more, look at the package org.jopendocument.dom.spreadsheet