XSSFWorkbook类型中的getSheetAt(int)方法引用了缺少的XSSFSheet类型

Question

我已经在项目构建路径中导入了apachepoi的所有jar文件，但我仍然收到错误“类型XSSFWorkbook中的方法getSheetAt（int）引用了缺少的类型XSSFSheet”

我使用版本- poi-bin-4.1.2-20200217

代码：

ackage ReadExcelData;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ReadExcel {

    /**
     * @param args
     * @throws Exception 
     */
    public static void main(String[] args) throws Exception {
        // TODO Auto-generated method stub

        
        File src = new File("C:\\Users\\Vishwa\\Desktop\\DeskTop\\Projects\\Automation Projects\\TestData.xlsx");
        
        FileInputStream fis = new FileInputStream(src);
        
        XSSFWorkbook wb = new XSSFWorkbook(fis);
                
        
        wb.getSheetAt(0);  //Error here: The method getSheetAt(int) from the type XSSFWorkbook refers to 

                            the missing type XSSFSheet  ,  

  The type org.apache.poi.xssf.usermodel.XSSFSheet cannot be resolved. It is indirectly referenced from required .class files
        
        
    }

Answer 1

你有吗

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

在你的舞会上。xml，如果您使用maven？

或者添加这个jar，如果你有一个lib

https://repo1.maven.org/maven2/org/apache/poi/poi-ooxml/4.1.2/.

poi-ooxml-4.1.2.jar