import org.apache.poi.ss.usermodel.*;import org.junit.jupiter.api.Test;import java.io.FileInputStream;import java.util.Iterator;public class ApachePOITest { private String path = “E:測(cè)試數(shù)據(jù)表.xlsx”; @Test public void createWorkbook() throws Exception { System.out.println(path); // 通過【path】文件路徑拿到【W(wǎng)orkbook】工作?。〞?huì)自動(dòng)判斷Excel版本） Workbook workbook = WorkbookFactory.create(new FileInputStream(path)); // 取出【Sheet 工作表】迭代器 Iterator sheetIterator = workbook.sheetIterator(); // 遍歷【Sheet 工作表】 while (sheetIterator.hasNext()) { Sheet sheet = sheetIterator.next(); // 取出【Row 數(shù)據(jù)行】迭代器 Iterator rowIterator = sheet.rowIterator(); // 遍歷【數(shù)據(jù)行】 while(rowIterator.hasNext()) { Row row = rowIterator.next(); // 取出【Cell 單元格】迭代器 Iterator cellIterator = row.cellIterator(); // 遍歷【單元格】 while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); // 取出單元格內(nèi)容并打印 System.out.print(getCellValue(cell) + “;”); } System.out.println(); } } } /** * 按類型獲取單元格值的字符串形式 * @param cell * @return */ private String getCellValue(Cell cell) { switch (cell.getCellType()) { case BLANK: return “空單元格：”; case FORMULA: return “公式：” + cell.getCellFormula(); case NUMERIC: return “數(shù)字：” + cell.getNumericCellValue(); case STRING: return “字符串：” + cell.getStringCellValue(); case BOOLEAN: return “布爾值：” + cell.getBooleanCellValue(); case ERROR: return “錯(cuò)誤值：” + cell.getErrorCellValue(); default: return “未知類型：” + cell.getCellType(); } }}