使用Apache POI列出Excel中所有已定义的名称 [英] List All defined names from Excel Using Apache POI

问题描述

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

How can i get the list of all the defined names/ range names in excel using Apache POI?

感谢@Axel Richter，下面是代码

EDITED: Thanks to @Axel Richter, Here is the code

        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();
    }

推荐答案

        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();
}

这篇关于使用Apache POI列出Excel中所有已定义的名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！