Java读取本地Excel文件(.xlsx与.xls)
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
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.*;
import java.util.ArrayList;
import java.util.List;
/**
* 读取本地Excel文件(.xlsx与.xls)
* XSSFWorkbook支持.xlsx
* HSSFWorkbook支持.xlt与.xls
* 需导入依赖
*
* org.apache.poi
* poi
* 4.0.1
*
*
*
* org.apache.poi
* poi-ooxml
* 4.0.1
*
*/
public static void readExcel(String filePath) {
try {
/*
*简单判断后缀名,如需通