Define name

The following example shows you how to define range name.

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

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Spreadsheet spreadsheet = new Spreadsheet();

            Table sheet1 = new Table("Sheet1");
            spreadsheet.getTables().add(sheet1);

            NamedRange range1 = new NamedRange("MyRange");
            range1.setCellRangeAddress("$Sheet1.$A$1:.$C$1");
            range1.setBaseCellAddress("$Sheet1.$C$1");

            spreadsheet.getNamedElements().add(range1);

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

Independentsoft - any library, any programming language

JODF > Tutorial > Define name

Need help? Ask our developers: