官网:http://poi.apache.org/
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsICdzFWRoRXdvN1LclHdpZXYyd2LcBzNvwVZ2x2bzNXak9CX90TQNNkRrFlQKBTSvwFbslmZvwFMwQzLcVmepNHdu9mZvwFVywUNMZTY18CX052bm9CX90zdONTQ61UejRkTxkEVZZXUYpVd1kmYr50MZV3YyI2cKJDT29GRjBjUIF2LcRHelR3LcJzLctmch1mclRXY39TNwgTMwQjMxEDMzcDM3EDMy8CX0Vmbu4GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.jpg)
核心文件:
基于maven坐标方式引入POI:
单元测试代码:
/**
* 使用POI解析Excel文件
* @throws IOException
* @throws FileNotFoundException
*/
@Test
public void test1() throws FileNotFoundException, IOException{
String filePath="F:\\java\\导入测试数据.xls";//转义
HSSFWorkbook workbook=new HSSFWorkbook(new FileInputStream(new File(filePath)));
//指定读取哪个标签页
HSSFSheet worksheet = workbook.getSheetAt();
//遍历所有行
for (Row row : worksheet) {
int rowNum = row.getRowNum();
if(rowNum == ){
//第一行 标题行
continue;
}
for (Cell cell : row) {
//遍历行中所有单元格 空的不遍历
String value = cell.getStringCellValue();
System.out.print(value + " ");
}
System.out.println();
}
}