java - 使用 Apache POI 列出 Excel 中所有定义的名称

Question

如何使用 Apache POI 获取 Excel 中所有已定义名称/范围名称的列表？

已编辑:感谢@Axel Richter，这是代码

        List definedNames = new ArrayList();
    definedNames = workbook.getAllNames();
    Iterator<List> definedNameIterator = definedNames.iterator();
    while (definedNameIterator.hasNext()) {
        Name name = (Name) definedNameIterator.next();
        System.out.println(name.getNameName());
        System.out.println(name.getRefersToFormula());
        System.out.println();
    }

Answer 1

        List definedNames = new ArrayList();
definedNames = workbook.getAllNames();
Iterator<List> definedNameIterator = definedNames.iterator();
while (definedNameIterator.hasNext()) {
    Name name = (Name) definedNameIterator.next();
    System.out.println(name.getNameName());
    System.out.println(name.getRefersToFormula());
    System.out.println();
}