取Excel单元格文件值时报错Error: org/apache/commons/compress/archivers/zip/ZipFile

Question

import java.io.FileInputStream;

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

public class ExcelRead {

public static void main(String[] args) {
	XSSFWorkbook excelWook;
	XSSFSheet excelWheet;
	XSSFCell cell;
	String path = "E:\\White_testNG\\ExcelRead.xlsx";
	String sheetName = "导入数据";
	try {
		FileInputStream exxelFile = new FileInputStream(path);
		excelWook = new XSSFWorkbook(exxelFile);
		excelWheet = excelWook.getSheet(sheetName);
		cell = excelWheet.getRow(3).getCell(2);
		String cellData = cell.getStringCellValue();
		System.out.println("cell data: " + cellData);
	} catch (Exception e) {
		e.printStackTrace();
	}
}

}

Answer 1

夏天 2018-09-26 22:19:25

好的，谢谢分享啊

Answer 2

提问者 慕先生8120188 2018-09-26 15:46:31

已解决：jar导入commons-compress-1.18
下载地址：https://commons.apache.org/proper/commons-compress/download_compress.cgi?Preferred=http%3A%2F%2Fmirrors.tuna.tsinghua.edu.cn%2Fapache%2F