做一个Excel表格的读取时导入 org.apache.poi 包后居然提示
XSSFWorkbook找不到:
原来是还需要下载一个jar包: poi-ooxml 包 ,之后在引入相关类即可:
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
写到这里就顺便把读取Excel表格的方法也贴上来:
package com.test; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.io.InputStream; import java.util.ArrayList; import java.util.List; public class readExcels { private Workbook wb; //工作谱 private Sheet sheet; //工作表 private Row row; //工作行 //读取的Excel文件路径 private final static String path = "D:\\infor.xlsx";