java – Cannot get a STRING value from a NUMERIC cell

java – Cannot get a STRING value from a NUMERIC cell

From the error, I understand that you are trying to fetch the pincode value from excel sheet using cell.getStringCellValue() where the cell type is not text or General but number.

I recommend you to format the cell holding the pincode value to General and that will resolve the error.

enter

You might use setCellType to String then you can get the String values.

java – Cannot get a STRING value from a NUMERIC cell

Leave a Reply

Your email address will not be published. Required fields are marked *