http://www.dpriver.com/pp/sqlformat.htm
Arquivo da tag: Formatter
Cannot get a text value from a numeric cell “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
https://stackoverflow.com/questions/30125465/cannot-get-a-text-value-from-a-numeric-cell-poi