Independentsoft
- any library, any programming language
Home
Purchase
Support
Company
Contact
JODF
>
Tutorial
> 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(); } } }
Need help? Ask our developers:
Name*
Email*
Message*