无法从数字单元格“ Poi”获取文本值

在这种情况下，格式化程序可以正常工作。

import org.apache.poi.ss.usermodel.DataFormatter;FileInputStream fis = new FileInputStream(workbookName);Workbook workbook = WorkbookFactory.create(fis);Sheet sheet = workbook.getSheet(sheetName);DataFormatter formatter = new DataFormatter();String val = formatter.formatCellValue(sheet.getRow(row).getCell(col));list.add(val);   //Adding value to list