Cell spanning

The following example shows how to merge cells across columns and rows in an ODS spreadsheet.

import com.independentsoft.office.odf.Cell;
import com.independentsoft.office.odf.Spreadsheet;
import com.independentsoft.office.odf.Table;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Spreadsheet doc = new Spreadsheet();
            Table table = new Table();
            table.setName("Spanning");

            Cell header = new Cell("Merged Header");
            header.setSpannedColumnsCount(3);
            table.set("A1", header);

            Cell sideLabel = new Cell("Tall Cell");
            sideLabel.setSpannedRowsCount(2);
            table.set("A2", sideLabel);

            table.set("B2", new Cell("Row 1, Col 2"));
            table.set("B3", new Cell("Row 2, Col 2"));

            doc.getTables().add(table);
            doc.save("c:\\test\\output.ods", true);
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JODF > Tutorial > Cell spanning

Need help? Ask our developers: