maven文件中导入依赖

获取excel文件

 FileInputStream fileInputStream = new FileInputStream("文件路径");

获取Workbook对象

Workbook workbook = new XSSFWorkbook(fileInputStream);

获取Sheet对象

Sheet sheet = workbook.getSheet("目标sheet名称");

若需要取Sheet1，则getSheet(“Sheet1”)即可。

获取Row对象，即表中的一行

 Row row = sheet.getRow(0);

Cell对象为行中的一格

Cell cell = row1.getCell(0);

代码块

try {FileInputStream fileInputStream = new FileInputStream("文件路径");Workbook workbook = new XSSFWorkbook(fileInputStream);Sheet sheet = workbook.getSheet("目标sheet名称");Row row1 = sheet.getRow(0);Cell cell = row1.getCell(0);for(Row row : sheet){System.out.println(row.getCell(0));}} catch (FileNotFoundException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();}