做一个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";