Errors when run TestNG script

Error - java.lang.IllegalStateException: Cannot get a text value from a numeric cell
at org.apache.poi.hssf.usermodel.HSSFCell.typeMismatch(HSSFCell.java:650)
at org.apache.poi.hssf.usermodel.HSSFCell.getRichStringCellValue(HSSFCell.java:727)
at org.apache.poi.hssf.usermodel.HSSFCell.getStringCellValue(HSSFCell.java:710)


Cause - Your java code is trying to read everything as string. So for those strings you will need to specify them as text data in excel.


Solution - Select the cell in spreadsheet, Right click on cell Select Format cells, Select Numbers > Text and Click OK.