import java.io.FileInputStream; import java.io.IOException; import org.apache.poi.EncryptedDocumentException; import org.apache.poi.openxml4j.exceptions.InvalidFormatException; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.FormulaEvaluator; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.WorkbookFactory; public class Role { public static void main(String[] args) throws IOException, EncryptedDocumentException, InvalidFormatException{ // TODO Auto-generated method stub // TODO Auto-generated method stub FileInputStream f=new FileInputStream ("C:\\Users\\Administrateur\\Desktop\\poi-3.17-beta1\\BMAHD1.xls"); org.apache.poi.ss.usermodel.Workbook workbook = WorkbookFactory.create(f); org.apache.poi.ss.usermodel.Sheet sheet = workbook.getSheetAt(0); FormulaEvaluator forlulaEvaluator= workbook.getCreationHelper().createFormulaEvaluator(); for(Row row:sheet){ for(Cell cell:row){ switch(forlulaEvaluator.evaluateInCell(cell).getCellType()) { case Cell.CELL_TYPE_NUMERIC: System.out.print(cell.getNumericCellValue() + "\t\t"); break; case Cell.CELL_TYPE_STRING: System.out.print(cell.getStringCellValue() + "\t\t"); break; }} }}}