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.IOException;
public void readXSFileData(){ try { String filePath = "D:\\biao.xlsx"; // 替换为你的Excel文件路径(此路径为磁盘上的绝对路径) FileInputStream fis = new FileInputStream(filePath); Workbook workbook = new XSSFWorkbook(fis); Sheet sheet = workbook.getSheetAt(0); for (Row row : sheet) { for (Cell cell : row) { String cellValue = cell.getStringCellValue();(注意:表格中如果有数字格式,此处会报错,将Excel单元格转换成文本格式即可,转换完成后左上角会有个绿色小三角) System.out.println(cellValue); } } workbook.close(); fis.close(); } catch (IOException e) { e.printStackTrace(); } }