Excel exception cannot get a text value numeric cell

Excel exception cannot get a text value numeric cell
Poi there are different types of data cell when manipulating Excel, when we attempt to read a string from a cell of a numeric type and write to the database, an abnormal error cannot get a-text value from a numeric cell appears. The solution is to judge the type of the cell, and then you can read the pure numbers and then convert the BigDecimal to string type (no matter how large the number is, there is no problem):

int Num3=row.getcell ((short) 3). Getcelltype ()//perfect, if you fill in the number type, you can read out, and avoid the error
String sfz= "";
if (num3==1) {
SFZ = Row.getcell (short) 3). Getstringcellvalue (). toUpperCase (). Trim ();
}else{
Double Sfz_d=row.getcell ((short) 3). Getnumericcellvalue ();
BigDecimal bg=new BigDecimal (sfz_d);
Sfz=bg.toplainstring (). Trim ()//to convert the resulting double data to a string
}