Java POI提供的数据似乎在Office2007+XML中

Question

<dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>3.13-beta1</version>
    </dependency> 

POIFSFileSystem fs;

            fs = new POIFSFileSystem(new FileInputStream(getFilePath()));

public void getBColum() {
    try {
        OPCPackage fs;

        fs = new OPCPackage.open(new File(getFilePath()));

        XSSFWorkbook wb = new XSSFWorkbook(fs);
        XSSFSheet sheet = wb.getSheet("Master column name - Used Car");
        XSSFRow row;
        CellReference cr = new CellReference("A1");
        row = sheet.getRow(cr.getCol());
        System.out.println(row.getCell(3));
    } catch (FileNotFoundException e) {
        if (logger.isDebugEnabled()) {
            logger.debug("How can this error be possible? we should have already thrown an exception in the construction");
        }
    } catch (IOException e) {
        logger.error(String.format("Exception in reading the file: %s",
                e.getMessage()));
    }
}

OpcPackage.Open无法解析为类型

Answer 1

根据Apache POI快速指南，POIFSFILESystem（或者类似地，NPOIFSFILESystem)仅与.xls（到2003年的Excel版本）文档一起使用。

.xlsx文档（Excel 2007+)的等价物是opcpackage。

OPCPackage pkg = OPCPackage.open(new File("file.xlsx"));

您可以从OpcPackage创建XSSFWorkbook:

XSSFWorkbook wb = new XSSFWorkbook(pkg);

XSSFWorkbook wb = new XSSFWorkbook(new File("file.xlsx"));

// or "file.xlsx"
Workbook wb = WorkbookFactory.create(new File("MyExcel.xls"));