Examples with CTDefinedName org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDefinedName used on opensource projects

Example 6 with CTDefinedName

use of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDefinedName in project poi by apache.

the class XSSFWorkbook method createBuiltInName.

/**
     * Generates a NameRecord to represent a built-in region
     *
     * @return a new NameRecord
     * @throws IllegalArgumentException if sheetNumber is invalid
     * @throws POIXMLException if such a name already exists in the workbook
     */
XSSFName createBuiltInName(String builtInName, int sheetNumber) {
    validateSheetIndex(sheetNumber);
    CTDefinedNames names = workbook.getDefinedNames() == null ? workbook.addNewDefinedNames() : workbook.getDefinedNames();
    CTDefinedName nameRecord = names.addNewDefinedName();
    nameRecord.setName(builtInName);
    nameRecord.setLocalSheetId(sheetNumber);
    if (getBuiltInName(builtInName, sheetNumber) != null) {
        throw new POIXMLException("Builtin (" + builtInName + ") already exists for sheet (" + sheetNumber + ")");
    }
    return createAndStoreName(nameRecord);
}