Poi operation Excel exception cannot get a text value from a numeric cell

Console throws exception:Java.lang.IllegalStateException:Cannot get a text value from a numeric cell

The above error occurred when parsing an Excel file with POI in Java, indicating that the value of the text type cannot be obtained from a cell of a numeric type.

When a POI operates Excel, the data cell has different types, and when we try to read a string from a number type cell and write to the database , cannot get a text value appears. Exception error from a numeric cell.

The workaround is to set the cell type first, and then you can read the pure number as a string type :

if (Row.getcell (0)!=null) {
Row.getcell (0). Setcelltype (cell.cell_type_string);
User.setnum (Row.getcell (0). Getstringcellvalue ());
}

Poi operation Excel exception cannot get a text value from a numeric cell