Styles and rows

[Bernd Lauert]

Hello,

is there any way to easily get a Row Object of my current Sheet in a SpreadSheet and apply a style to it?
I want to create a ods file programatically and apply styles to it in memory, then write it to an outputStream and not use any previously created templates that have to be stored somewhere.

something like:

Row row = sheet.getRow(int rowNumber);
row.setStyle(style);

Is it furthermore possible to create a style programatically?

something like:

Style style = new Style();
style.setFontWeight(Style.BOLD);
sheet.setStyle("styleName", style);

and then later:

row.setStyle("styleName");

or

cell.setStyle("styleName");

The documentation on the library is rather thin and the API is not very helpful either in this regard.

Thank you in advance!

[Cláudia Freitas]

Hello Bernard,

you can find such a solution?