Thread: How to create a.odt document formatted in Java

Do you have a small, complete program that compiles and executes to demonstrate the problem?

Do you have a link for the documentation for the package you are using?

Well a complete program is not small.
I report the actions I do. It's very simple.

I load a JTable with a: DefaultTableModel modTable; loaded from a db table.
then I declare a file with:
File fiFileName = new File("/Directory/FileName.ods");
and then I create the file ods with:
SpreadSheet.createEmpty(modTable).saveAs(fiFileNam e);

The documentation is here: https://www.jopendocument.org/docs/o...readSheet.html

Sorry, without code to work with, i won't be able to help. I have no experience with the package you are using.
My suggestion is to read the API documentation for the package to see what methods will help.

I have done a simple example.
Unfortunately I can't attach it

As you can see there it is possible to use only setValue and setBackgroundColor
In the documentation there is also the setStyleName but it is not enough.

package ClassiTest;
import java.awt.Color;
import java.io.File;
import java.io.IOException;
import java.util.logging.Level;
import java.util.logging.Logger;
import org.jopendocument.dom.spreadsheet.MutableCell;
import org.jopendocument.dom.spreadsheet.Sheet;
import org.jopendocument.dom.spreadsheet.SheetTableModel.MutableTableModel;
import org.jopendocument.dom.spreadsheet.SpreadSheet;
//================================================================================
public class ProvaJOpenDocument {
  public ProvaJOpenDocument() {
    Person[] vPers = {  new Person("Mario", "Rossi", 1984, Sex.MASCHIO),
                        new Person("Lucia", "Verdi", 1954, Sex.FEMMINA),
                        new Person("Roberto", "Bianchi", 1966, Sex.MASCHIO),
                        new Person("Giacomo", "Neri", 1954, Sex.MASCHIO),
                        new Person("Anna", "Marrone", 1975, Sex.FEMMINA),
                        new Person("Marco", "Viola", 1961, Sex.MASCHIO), };
    SpreadSheet sprSheet = SpreadSheet.create(1, 1, 1);
    Sheet sht = sprSheet.getFirstSheet();
    sht.setName("Persone");
    sht.ensureRowCount(vPers.length);
    sht.ensureColumnCount(4);
    MutableTableModel<SpreadSheet> tm = sht.getMutableTableModel(0, 0);
//--------------------------------------------------------------------------------
    for (int ii = 0; ii < vPers.length; ii++) {
      Person people = vPers[ii];
      Color background = people.sesso == Sex.MASCHIO ? new Color(135, 206, 250) : new Color(255, 192, 203);
      setCella(tm.getCellAt(ii, 0), people.nome, background);
      setCella(tm.getCellAt(ii, 1), people.cognome, background);
      setCella(tm.getCellAt(ii, 2), people.annoNascita, background);
      setCella(tm.getCellAt(ii, 3), people.sesso, background);
    }
    try {
      sprSheet.saveAs(new File("/Export/Persone.ods"));
    } catch (IOException ex) {
      Logger.getLogger(ProvaJOpenDocument.class.getName()).log(Level.SEVERE, null, ex);
    }
  }
//================================================================================
  private static void setCella(MutableCell<SpreadSheet> cell, Object valore, Color background) {
    cell.setValue(valore);
    cell.setBackgroundColor(background);
  }
}
//================================================================================
class Person {
  public String nome;
  public String cognome;
  public int annoNascita;
  public Sex sesso;
//================================================================================
  public Person(String nome, String cognome, int annoNascita, Sex sesso) {
    this.nome = nome;
    this.cognome = cognome;
    this.annoNascita = annoNascita;
    this.sesso = sesso;
  }
}
//================================================================================
enum Sex {
  MASCHIO, FEMMINA
}

There is no main method in the posted code. How do I execute the code for testing?

I added a main method that creates an instance of the class. Nothing happens when I execute it. What do you expect the above posted code to do when it is executed? How does it show the problem?

Can you create an class that extends the Cell class and have it control how it is shown in the table?
Do the jopendocument classes support a custom Cell class?

The only other source for spreadsheet products I know of is Apache.

After some queries in Google:
https://forum.openoffice.org/en/foru...c.php?t=111005
https://stackoverflow.com/questions/...my-application